DSXchange

Posted: **Wed Oct 31, 2007 4:29 pm**

This is all pretty simple string manipulation since you aren't working with variable length strings. Try doing it in 2 steps, one to right-align the numeric, then the second to do the string insertions

1. In.Col[1,1]:FMT(In.Col,"11'0'R")
2. do you explicit positional changes.

Posted: **Thu Nov 01, 2007 1:06 am**

Code: Select all

Left(In.Col,1) : Left(In.COLUMN1,3) : Left(In.COLUMN2,1) : Left(In.COLUMN3,1) : Right(In.Col,Len(In.Col)-1)

DSXchange

Converting/Adding 8 character into a 12 character string