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.
example:
txt file
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
command use
cat test.txt | tr “|” “,” > test.csv
can someone help me?
How do you know when a politician is lying? His mouth is moving.