Conversion of any delimited row to Pipe delimited

[chaithanya]

Hi

I have a row with data as follows

abc|xyz|a,b,c,d|123

I need the demiter comma to be replaced by Pipe as follows


abc|xyz|a|b|c|d|123 :D

[prasson_ibm]

Hi,
If your source is sequential file,it can be done in different methods:-

Method 1:-

Read seq. file as a single string and apply convert function in transformer.
Convert(",","|",InputLink.Col)

Method2:-

In the input sequential file stage,write below sed command at Option->Filter

sed '1,$s/,/|/g'

[ray.wurlod]

The tr command is cheaper to run than sed.