awk/sed for splitting a field into two

sire · #1 (**permalink**) 06-22-2009

I have a tab delimitted dataset with 4 fields. I like to split the second field into two, and have 5 fields. I like to remove the "-" sign when I get a new fiel. would you help?

It is like:
1223 100-5 rr dd

I need it like:
1223 100 5 rr dd

scottn · #2 (**permalink**) 06-22-2009

You could try:

Code:

awk '{sub( "-", " ", $2); print}' your_file

sire · #3 (**permalink**) 06-23-2009

Many thanks scottn! It worked perfectly.

Quote:

Originally Posted by scottn

You could try:

Code:

awk '{sub( "-", " ", $2); print}' your_file

More UNIX and Linux Forum Topics You Might Find Helpful
Thread	Thread Starter	Forum	Replies	Last Post
awk - Summing a field based on another field	treesloth	UNIX for Dummies Questions & Answers	7	06-21-2009 06:04 PM
Sort alpha on 1st field, numerical on 2nd field (sci notation)	FrancoisCN	Shell Programming and Scripting	1	06-12-2009 10:45 AM
Find top N values for field X based on field Y's value	FrancoisCN	Shell Programming and Scripting	1	05-29-2009 09:57 AM
Retrieve 5th Field to Last Field !!	jobbyjoseph	UNIX for Dummies Questions & Answers	3	05-16-2007 03:20 AM
Moving Part of a field to another field using AWK	rjsha1	Shell Programming and Scripting	5	08-04-2006 05:39 AM

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Display Modes	Rate This Thread
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode	Rate This Thread: