creating columns with awk?

verse123 · 11-08-2011, 01:10 PM

Hi guys,

Does anyone know how to separate a column into two if a criteria is met using awk?

For example, how could one separate col1 into two columns if ":" is present while removing ":" in the output

col1 col2
T:3442 435
R:324 45560

this should look like this:
col1 col2 col3
T 3442 435
R 324 45560

verse123 · 11-08-2011, 01:17 PM

Nevermind... I figured it out

Tinkster · 11-08-2011, 01:39 PM

Now if you posted your solution others who search for the same
issue would actually be able to benefit from it ...

Cheers,
Tink

verse123 · 11-08-2011, 02:29 PM

instead of awk, a simple sed would work:

Code:

 sed 's/T://g' input > output

in my case this was going to excel so I had saved the "T:" initially in a separate column so I realized I didn't really need it. This sed command will remove T: and just print out the following numbers without it.

Tinkster · 11-08-2011, 03:03 PM

Quote:

Originally Posted by verse123

instead of awk, a simple sed would work:

Code:

 sed 's/T://g' input > output

in my case this was going to excel so I had saved the "T:" initially in a separate column so I realized I didn't really need it. This sed command will remove T: and just print out the following numbers without it.

Interesting :)

This doesn't do what you first described as what you want/need.
That would have been:

Code:

sed 's/:/ /g' input > output

Cheers,
Tink

verse123 · 11-08-2011, 03:21 PM

it doesn't does it

but since I had it already in excel, things worked out. Thanks for the tip though.

grail · 11-09-2011, 01:50 AM

And what about 'R:'?