UNIX for Dummies Questions & Answers

Hi,
Could anyone help me in changing a tabular format output to comma seperated file pls in K-sh. Its very urgent.

E.g : username empid
------------------------
sri 123

to

username,empid
sri,123

Thanks,
Hema

Hi,
try the following simple solution:

cat filename | sed 's/ /,/g'

the example above looks for 2 spaces and subtitutes it with a comma

Hope this helps,


Don

Hi Don,

I tried the same its just substituting the one comma for each space.
the space in between the columns are of variable length so could you please help me.

The data in table format will be something like this

User ID Eid T Profile S E
---------- ----------- - -------------------------------------------------- - -
234 1 U Data Administration A
123 2 U M A
and the header gets repeated for every 10 records.
could you please help me n removing the header records in between other than the first line also pls.

Thanks,
Hema.