topic Text file having Pipe separator. in Talend Studio

Text file having Pipe separator.

sbxr — Fri, 30 Nov 2018 10:27:20 GMT

Hi All,

I have a text file which is four columns in which three columns are separated by comma(","). But the fourth column is separated by pipe("|"). how can we move this input to a output delimited file with only comma(",") separated values .

Input:

a, b, c | d

Output:

a,b,c,d

Thanks

Re: Text file having Pipe separator.

vapukov — Fri, 30 Nov 2018 11:21:20 GMT

it always depend from real situation

is pipe always in same place?
is data could contain legal pipe (especially in last 2 columns)

in simple ways as described:

- read file as 3 column,

- after split last column with tExtractDelimitedFields

use "\\|" as delimiter