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 cokeoutput should be
i like to eat burger, chicken wing and fries<next field>i like to drink cokebut 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.csvcan someone help me?
Can you use sed or awk to remove the commas before you convert the file? How do you know when a politician is lying? His mouth is moving.
Yes (14) | ![]() | |
No (14) | ![]() | |
I don't know (15) | ![]() |