Transpose one line/lines from column to row using shell

Question

I want convert a column of data in a txt file to a row of a csv file using unix commands.

example:

ApplChk1,
ApplChk2,
v_baseLoanAmountTI,
v_plannedClosingDateField,
downPaymentTI,

this is a column which present in a txt file

I want output as follows in a csv file

ApplChk1,ApplChk2,v_baseLoanAmountTI,v_plannedClosingDateField,downPaymentTI,

Please let me know how to do it.

Thanks in advance

Answer 1

If that's a single column, which you want to convert to row, then there are many possibilities:

tr -d '\n' < filename ; echo # option 1 OR
xargs echo -n < filename ; echo # option 2 (This option however, will shrink spaces & eat  quotes) OR
while read x; do echo -n "$x" ; done < filename; echo # option 3

Please let us know, how the input would look like, for multi-line case.