Number format
Posted: Wed Aug 12, 2009 2:54 pm
How can i replace the number from 0009998888 to 000-999-8888
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)