>I used to have three different fields for my phones, ex: Are_phone (3), Phone_3(3) and Phone_4(4) instead of just one field with all the 10 digits in it. Now I created a new field called Home_Phone(15) and I replaced all the old 3 fileds into one single field called Home_phone; however, the numbers are all closed together ex: 7034485656 and I would like to know if I could separate them so it would make easier for my user to read them ex: 703 448 5656, it could be separeted by a space, dash or ( ). It would not matter to me.
>If anyone can help i would really appreciated it, and thank's in advance
>Eduardo
transform('1234567890','@R 999-999-9999')
123-456-7890
You can use any characters to separate the numbers, but note the space after the "@R".