problem with script

[#1]

I am having a table which consits of data 1010010001000

2020020002000

2002002002000

3003000300030

not i have to load them as

10.100.1000.1000

20.200.2000.2000

20.020.2000.2000

30.030.0030.0030

can anyone help

[#2]

help

[#3 · Accepted solution]

Try this:

left(YourField,2)&'.'&Right(Left(YourField,5),3)&'.'&Right(Left(YourField,9),4)&'.'&Right(YourField,4) as YourField

[#4]

11177715424444640444444

if i wanted to write in this format 11.17.771.54244446.40.444444

can you help me with this

[#5]

Left(YourField,2)&'.'&right(Left(YourField,4),2)&'.'& Right(Left(YourField,7),3)&'.'&right(left(YourField,15),8)&'.'& Left(Right(YourField,8),2)&'.'&Right(YourField,6)