How to handle delimiter value at field level?

[dssiddu]

Hi DSsss
Input is as below, with pipe delimiter. But In location field value there is chance of comming | as one of the character in the values. I want to pass as it is to target. I want to do this in sequential file stage only (no Tmf allowed)

Please suggest
Input
NUM|LOCATION|STATECODE
10|MUM|BAI|MH
11|BANGALORE|KA
12|HYDRABAD|AP
13|CHENNAI|TN

Requeired Output as below

NUM LOCATION STATECODE
10 MUM|BAI MH
11 BANGALORE KA
12 HYDRABAD AP
13 CHENNAI TN

Thanks in advance...

[mahadev.v]

Using sequential file stage alone, its not possible. You can, at the most reject all the records with extra delimiter from the Sequential file stage and continue processing the other records.

[chulett]

In order to do that, your string value would need to be quoted otherwise your file is invalid.

10|"MUM|BAI"|MH

Would read correctly. Otherwise you'd need to read it as a single string and then (attempt to) intelligently parse out the fields in a transformer.