Shell Programming and Scripting

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

Code:

/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

Redirect the output of this to another file and rename it.

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

Code:

/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

Code:

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

Vino..No Luck..

Let me tell u my requirement..

I have a file dmlog.txt with data like this

LOAD_STAGE STAGE_LOAD COMPLETE U0 10-OCT-05
LOAD_STAGE_A D_CA_PRODUCT COMPLETE U0 10-OCT-05
LOAD_STAGE_B D_CB_PRODUCT COMPLETE U0 10-OCT-05

Now i need to convert it to

LOAD_STAGE,STAGE_LOAD,COMPLETE,U0,10-OCT-05
LOAD_STAGE_A,D_CA_PRODUCT,COMPLETE,U0,10-OCT-05
LOAD_STAGE_B,D_CB_PRODUCT,COMPLETE,U0,10-OCT-05

Can u explain me on how to proceed with this Example.