Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
it always depend from real situation
in simple ways as described:
- read file as 3 column,
- after split last column with tExtractDelimitedFields
use "\\|" as delimiter
it always depend from real situation
in simple ways as described:
- read file as 3 column,
- after split last column with tExtractDelimitedFields
use "\\|" as delimiter