Insert comma in place of column

Shell Programming and Scripting
1

Hi all,

I have a file in which I have to insert commna between entries of 2 column and createa new file separated by commas not a columns

if input is

FHIT     Adenosine Monotungstate    Not Available

CS     Trifluoroacetonyl Coenzyme A    Not Available  
```[/b]



Theo expected output is

```text
FHIT,Adenosine Monotungstate ,Not Available
    
CS ,Trifluoroacetonyl Coenzyme A ,Not Available  
```[/b]


Kindly let me know scripting regarding this
    	 	 	 	 	body, div, table, thead, tbody, tfoot, tr, th, td, p \{ font-family: "Liberation Sans"; font-size: x-small; \}
2

Try this:

$ cat t
FHIT     Adenosine Monotungstate    Not Available
CS     Trifluoroacetonyl Coenzyme A    Not Available

$ sed 's/ \{2,\}/,/g' t
FHIT,Adenosine Monotungstate,Not Available
CS,Trifluoroacetonyl Coenzyme A,Not Available
3

Thankyou for reply.

I checked but the ouptu is exactly same as input, there is no commas in place of column

I have a big file with many rows and columns and there is not even slight differnet in ouput and input

I tried this

 sed 's/ \{2,\}/,/g' saradrugbankgenedrugnewlist.txt >saradrugbankgenedrugnewlist2.txt

and output file is exactly same as input file

4 
sed -e 's/[ \t]/,/'
5

Hi

Thankyou

Now it's inserting comma only between first and second column and not between other columns

I tried this

bash-3.2$ sed -e 's/[ \t]/,/' saradrugbankgenedrugnewlist.txt >saradrugbankgenedrugnewlist2.txt

the outptut is like this where comma is onlt between first and second column not the the 2 anf 4th an so on

FHIT,Adenosine Monotungstate Not Available
    
CS ,Trifluoroacetonyl Coenzyme A Not Available
6

It will add comma for all the columns..

 sed 's/[\t]/,/g'