I have a 10 digit phone number in an attribute (e.g. 0123456789).
However, I want to output it formatted to a string like this: 012-345-6789.
How would I go about doing this?
Any help would be much appreciated.
Thanks
Solved
How to format phone number
+4- Contributor
Hello,
Best answer by ebygomm
Take 3 from the left, add a hyphen, 3 from the middle add a hyphen, 4 from the right
@Left(@Value(phone),3)-@Substring(@Value(phone),3,3)-@Right(@Value(phone),4)
+32- Influencer
- Best Answer
Take 3 from the left, add a hyphen, 3 from the middle add a hyphen, 4 from the right
@Left(@Value(phone),3)-@Substring(@Value(phone),3,3)-@Right(@Value(phone),4)Reply
Rich Text Editor, editor1
Editor toolbars
Press ALT 0 for help
Helpful Members This Week
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.