UNIX for Dummies Questions & Answers

Hello Gurus,

I have a text file containing nearly 12,000 tab delimited characters with 4000 rows. If the file size is small, excel can convert the text into coloumns. However, the file that I have is very big. Can some body help me in solving this problem?

The input file example,

L36+univ06->22260 ML_GENO 2/2 2/2 2/2 1/1 1/1 1/2 2/2 1/2 2/2 2/2 2/2 2/1
L36+univ06->23326 ML_GENO 2/2 2/2 2/2 1/1 1/1 2/2 2/2 2/2 2/2 2/1 2/2 2/1

I want a text file which looks like

L36+univ06 22260 c3 c4 c5 c6 2 2 2 2 2 2 1 1 1 1 1 2 2 2 1 2 2 2 2 2 2 2 2 1
L36+univ06 23326 c3 c4 c5 c6 2 2 2 2 2 2 1 1 1 1 2 2 2 2 2 2 2 2 2 1 2 2 2 1

Basically I want to delete -> and ML_GENO and insert 4 new coloumns after 2nd coloumn. Finally I want to separate 2/2 into 2 2.

can somebody help me on this? Thanks a lot.

Code:

$ ruby -ne 'a=$_.gsub(/\/|ML_GENO|->/," ").split; a.insert(2,%w{c3 c4 c5 c6});puts a.join(" ")' file
L36+univ06 22260 c3 c4 c5 c6 2 2 2 2 2 2 1 1 1 1 1 2 2 2 1 2 2 2 2 2 2 2 2 1
L36+univ06 23326 c3 c4 c5 c6 2 2 2 2 2 2 1 1 1 1 2 2 2 2 2 2 2 2 2 1 2 2 2 1

thanks for the reply Kurumi. However, I have problem. Because the cygwin says bash: ruby: command not found.

Is there a script from perl or sed or awk?

Thanks a lot!

Code:

$ sed 's/ML_GENO/c3 c4 c5 c6/;s/->/ /;s|\/| |g' file
L36+univ06 22260 c3 c4 c5 c6 2 2 2 2 2 2 1 1 1 1 1 2 2 2 1 2 2 2 2 2 2 2 2 1
L36+univ06 23326 c3 c4 c5 c6 2 2 2 2 2 2 1 1 1 1 2 2 2 2 2 2 2 2 2 1 2 2 2 1

Thanks once again for code. It worked to insert the new 4 coloumns and also to delete ML_GENO and ->. However, it still can not separate 2/2 into 2 2 and also I want them in separate coloumn like L36+univ06 22260 c3 c4 c5 c6 2 2. But the present code gives me a file like L36+univ0622260 c3 c4 c5 c6 2/2 2/2.

Could you please help on this? thanks

well, as you can see, my output has no problem. Why don't you show how you do it

oh you are right. I am sorry about that. I made a mistake in typing the codes correctly. Thanks a million. It is working fine.