Hi - I'm new to InformaticaCloud. A client wants to take info from a flat file (from another party) and configure a number to always display 6 digits in a Salesforce field that only accepts 6 digits. The numbers in the incoming field may be anything from 2-6 digits. I need a function that will add the right number of 0s at the start of any numbers that are less than 6 digits. Could you help me get my head around how informaticacloud would deal with this please? Thanks
Hi Jonathan...in the User Guide there is an example using LPAD that sounds quite similar to what you are trying to do.
LPAD( PART_NUM, 6, '0')
would convert 702 to 000702, or 1 to 000001.
Let me know if this helps or if I misunderstood your question.
All the best!
Toye | Mavens Consulting