DSXchange

Hi All,

I have a field named AREA2 ( char 40 bytes). Say it has the following value " JT4VN13G4W36280604 98686" and I need to check whether the first 2 bytes are spaces and replace it with another string say "AB'.

I tried the following in my transformation.
If AREA2 [1,2] = ' '
then (AREA2 [1,1] : "AB" : AREA2 [4,37])
Else AREA2

and also this
If Alpha(AREA2 [1,2]) = 0
then (AREA2 [1,1] : "AB" : AREA2 [4,37])
Else AREA2

But I am not able to replace the spaces with "AB". Please help.

try the following:

If left(AREA2,2) = ' '
then ('AB':right(AREA2,len(AREA2)-2) )
Else AREA2