How to format a phone number in AMPscript

Question

I'd like to re-format a phone number in AMPscript from 1234567890 to (123) 456-7890 or 123-456-7890. I've tried using the Format function

%%=Format(%%CLIENT_PHONE%%,"(###) ###-####")=%%

where CLIENT_PHONE evaluates to 1234567890.

Can someone help?

Kelly J Andrews · Accepted Answer · 2013-12-12 14:40:59Z

5

Answering my own question here - sorry for that - looks like I added too many % signs.

%%=Format(CLIENT_PHONE,"(###) ###-####")=%%

That corrected the issue, and it now works perfectly. Thanks all!

answered Dec 12, 2013 at 14:40

Kelly J Andrews

4,4081 gold badge17 silver badges39 bronze badges

Hi Kelly, thanks for posting the answer. This helped me out!
– Nolan Maratas
Oct 5, 2015 at 17:29

Add a comment |

Daniel Hoechst · Accepted Answer · 2013-12-12 05:21:37Z

0

I don't have experience with AMPscript, but looking at the documentation, it appears that it uses C# syntax. Try

%%=Format("{0:(###) ###-####}", %%CLIENT_PHONE%%)=%%

answered Dec 12, 2013 at 5:21

Daniel Hoechst

24.9k7 gold badges78 silver badges113 bronze badges

Thank you - it turns out the syntax I had was correct, but I added too many percent signs. %%=Format(CLIENT_PHONE,"(###) ###-####")=%% would do the trick.
– Kelly J Andrews
Dec 12, 2013 at 14:38

Add a comment |

2 Answers 2