Concatenate rows into 1 row and 1 column
Posted: Wed Feb 22, 2012 4:36 pm
Need to concatenate rows into columns:
For example:
cat f:\Data\Comm\ppt9.txt | tr '\n' ','
it does not like the pipe character, it completely wipes out the rest of the command.
or gives me a syntax error. Maybe this work in UNIX but not in Windows.
Does any know the filter concatenate syntax?
into:example:
A
B
C
D
etc
I found some relevant posts on sequential file "Filter Command" but it does not work in 8.1 windows datastage.A,B,C,D etc...
For example:
cat f:\Data\Comm\ppt9.txt | tr '\n' ','
it does not like the pipe character, it completely wipes out the rest of the command.
or gives me a syntax error. Maybe this work in UNIX but not in Windows.
Does any know the filter concatenate syntax?