Number format

devanars · Post by **devanars** » Wed Aug 12, 2009 2:54 pm

How can i replace the number from 0009998888 to 000-999-8888

arun_im4u · Post by **arun_im4u** » Wed Aug 12, 2009 3:03 pm

I assume you want to convert a number into a string value in this format. You cannot have dashes in number fields.

Convert the number to string and use a substring function in your transformer..

substr(input_column,1,3):'-':substr(input_column,4,3):'-':substr(input_column,7,4)

devanars · Post by **devanars** » Thu Aug 13, 2009 8:51 am

can we use the same in parallel jobs also

arun_im4u · Post by **arun_im4u** » Thu Aug 13, 2009 9:04 am

Absolutely.