Converting/Adding 8 character into a 12 character string

[ArndW]

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.

[ray.wurlod]

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)