Changing format

mtechnocrat · Post by **mtechnocrat** » Fri Apr 02, 2004 8:11 am

Hi
I want to change the format from "abcdefghij" to "abcd.ef.ghij"

how to solve this.....????

Thanks

chulett · Post by **chulett** » Fri Apr 02, 2004 8:27 am

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!

ray.wurlod · Post by **ray.wurlod** » Fri Apr 02, 2004 7:43 pm

An alternative approach is to use the Fmt() function with a mask. for example

Code: Select all

Fmt(TheString,"L####.##.####")