Format Phone Numbers at Load Time

[#1]

Hi all,

I am loading a phone number field into my module and each of the numbers are in a simple xxxxxxxxxx 10-digit format. I would like to change the format to be something more like xxx.xxx.xxxx or (xxx) xxx-xxxx. Is it possible to format this at load time?

Thanks,
Paul

[#2]

Use the MID statement.

Stephen

[#3 · Accepted solution]

More specific:

=MID(Field,1,3) &  "." & MID(Filed,4,3) & "." & MID(Field,7,4) as PhoneNumber

Stephen

[#4]

Thanks!