|hi, need your advice here. i'm still new to this. i have a pipe delimited text file and want to convert to csv. the problem is whenever the data got comma (,) it will convert to next field. |
i like to eat burger, chicken wing and fries|i like to drink coke
output should be
i like to eat burger, chicken wing and fries<next field>i like to drink coke
but somehow, the output in csv become
i like to eat burger<next field> chicken wing and fries<next field>i like to drink coke
cat test.txt | tr "|" "," > test.csv
can someone help me?