on 03-07-2007 11:09 PM
Hi,
I am getting account as a 5 char field in the input file. I need to map this to a 10 char field in XI and add leading zeros in case the value is all numeric. Is there any standard data type/ mapping that can achieve this or I need to write a UDF.
Thanks,
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Input source --> Format Num (double click and give 0000000000) --> Target. Your issue solved.
---Satish
formatNum field will cause an exception if your input isnt all numeric...
I'd go for UDF id your input isnt always numeric.
Regards,
Henrique.
use the 'formatNum' function to achieve this....
the parameter of this function need tobe set as '0000000000'...
Renjith
Why dont you use concat function with '00000' + inputfiled and map it to output.
--Sudha Madhuri
I don't know the input value. It can be 4 digit, 3 digit or can contain some chars also- in that case I don't have add laeding zeros.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.