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
Text Data
Moderators: chulett, rschirm, roy
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,
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,
- james wiles
All generalizations are false, including this one - Mark Twain.
All generalizations are false, including this one - Mark Twain.