[resolved] Swap Data in text file

[ptromblee]

Hi,

 I have a text file that I need to change some data in. The file is x12 formatted file but there is only one segment where I need to move the data. This is a sample of one of the lines:

W01*1*EA*111101001985*VN*C4041C 058A P042 S*29.50*29.50**1**0.00*106480002

I need to swap 111101001985 and 106480002. This line is just delimited by an *.  I can't just read it in as a delimited file as there are other lines in the file that have different formatted text. But any lines that start with W01 I want to do this with.
I think I could do it by using tFileInputRaw and connect that with tjavarow. I'm just not sure the code to put in. Then the other lines I would just write back out to the text file as is.
Any help would be appreciated.

[Anonymous · Accepted solution]

Hi 
You can use tFileInputFullRow to read the file line by line, and then filter the lines that starts with " W01" and process these lines.
tFileInputFullRow--main--tFilterRow--main--....
                                                   --reject--...
BRS
Shong

[ptromblee]

Thanks. That helped me get the issue solved.