Page 1 of 1

Text Data

Posted: Fri Mar 11, 2011 12:08 pm
by pavan_test
I have incoming data as 8772794193.
The expected output is 877-279-4193

can anyone please suggest me how can I accomplish this.

Regards
Mark

Posted: Fri Mar 11, 2011 12:52 pm
by jwiles
Substring (string[start,len]) and concatenation ( : ).

Think about how you typed it into the post: 1st three digits, then dash, then 2nd three digits, then dash, then last four digits. Now emulate that using the substring and concatenation functionality.

Regards,