9 Replies Latest reply: Apr 18, 2012 3:46 AM by SH RSS

    Import script to remove zeros in Account field

      Dear FDM Experts,
      The problem is our source system always extracts 10 characters but we use 7 characters in HFM.
      Example, Account 0001201010 (10 characters) must be 1201010 (7 characters).

      I want to write an Import Script to remove, if any, all zeros from the left side of the account value at the import stage. We have no Accounts beginning with 0.

      Thanks in advance for your help,