Home > Net >  Sed replace character tab delimited csv
Sed replace character tab delimited csv

Time:09-17

I am very new to shell scripting and having issue replacing character of tab delimited csv.

I want to convert the csv to text file and change the delimiter from tab to ~ , i tried below code but the delimiter turns out different some like japanese char " instead of ~.

sed 's/\t/\"\~\"/g' test.csv > test.txt

Appreciate your help.. thanks in advance

CodePudding user response:

If it's char for char, use tr:

cat test.csv | tr '\t' '~' > test.txt

CodePudding user response:

Use iconv to change encoding to UTF-8:

iconv -f utf-16 -t utf-8 < test.csv | sed 's/\t/"~"/g' > test.txt

" and ~ can go unescaped.

  • Related