Hi,

Can anyone let me know on how to convert a Tab delimited file to Comma delimited file in Unix

Thanks!!

You can use sed to convert the Tab delimited file to a comma delimited file

/export/home/test/mona>cat tab_del.dat
1       2       3       4       5
6       7       8       9       10
/export/home/test/mona>sed 's/        /,/g' tab_del.dat
1,2,3,4,5
6,7,8,9,10

When i use

/export/home/test/mona>sed 's/ /,/g' tab_del.dat

I m getting like this..
1,, 2 3 4 5,
6,, 7 8 9 10,


Where i need like this
1,2,3,4,5
6,7,8,9,10

Plz help me out on this..

Thanks!!

Hi,

In the below code, the integers are seperated by tab and not multiple spaces.

The same way in the sed command you should give a tab and not multiple spaces. I think problem occurs when you copy the below contents and run. Don't copy the contents, form the data file of your own and run the sed command.

Let me know if you still face any problem

/export/home/test/mona>cat tab_del.dat
1press the tab key here2       3       4       5
6       7       8       9       10
/export/home/test/mona>sed 's/        /,/g' tab_del.dat
1,2,3,4,5
6,7,8,9,10

Use tr

tr '\t' ',' < tab-delimited-file > comma-delimited-file

i think it is simpler to convert using tr. You can use sed but sed will not recognize escape sequences like \n,\t.. but all these will be accpeted in tr.

Great going Vino