Page 1 of 1
Changing format
Posted: Fri Apr 02, 2004 8:11 am
by mtechnocrat
Hi
I want to change the format from "abcdefghij" to "abcd.ef.ghij"
how to solve this.....????
Thanks
Posted: Fri Apr 02, 2004 8:27 am
by chulett
Not
exactly a lot of information to work from.
Do you
always need to insert a period after the fourth and sixth character in this particular 10 character string? Then simply substring it and concatenate it back together with them in place:
Code: Select all
YourField[1,4]:".":YourField[5,2]:".":YourField[7,4]
If that's not what you meant or needed, please feel free to post back with more information!
![Wink :wink:](./images/smilies/icon_wink.gif)
Posted: Fri Apr 02, 2004 7:43 pm
by ray.wurlod
An alternative approach is to use the Fmt() function with a mask. for example