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
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
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)