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...
![Rolling Eyes :roll:](./images/smilies/icon_rolleyes.gif)