Text file having Pipe separator.

[sbxr]

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

[vapukov · Accepted solution]

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