To remove the extra spaces in unix

Sho · #1 (**permalink**) 05-04-2006

Hi...
I am quite new to Unix and would like an issue to be resolved.

I have a file in the format below;
4,Reclaim,ECXTEST02,abc123,Harry Potter,5432 6730 0327 5469,0603,,MC,,1200,EUR,sho-001,,1,,,abc123,1223

I would like my output to be as follows;

4,Reclaim,ECXTEST02,abc123,Harry Potter,5432673003275469, 0603,,MC,,1200,EUR,sho-001,,1,,,abc123,1223

i.e i want the inbetween spaces from the 6th field to be removed.
Please do help

Thanks in advance

vino · #2 (**permalink**) 05-04-2006

Code:

nawk -F, -v OFS=, '{ gsub(/ /,//, $6); print }'

Sho · #3 (**permalink**) 05-04-2006

Thanks a lot.
But when I tried using the above nawk command, I got the followin error;
"nawk: empty regular expression
source line number 1
context is
{ gsub(/ >>> /,// <<< , $6); print }"

Not sure on what I m missing out.

Please do help me out. Thanks...

vino · #4 (**permalink**) 05-04-2006

Quote:

Originally Posted by vino

Code:

nawk -F, -v OFS=, '{ gsub(/ /,//, $6); print }'

Try

Code:

nawk -F, -v OFS=, '{ gsub(" ","", $6); print }'

Sho · #5 (**permalink**) 05-04-2006

Thats gr8888! A Million thanks to you...
Itz working perfect...

More UNIX and Linux Forum Topics You Might Find Helpful
Thread	Thread Starter	Forum	Replies	Last Post
remove spaces btw	tjmannonline	UNIX for Dummies Questions & Answers	7	05-26-2008 03:35 AM
removing extra spaces	agarwal	Shell Programming and Scripting	2	04-25-2008 05:54 AM
How to remove trailing spaces	mahek_bedi	UNIX for Dummies Questions & Answers	2	08-10-2007 08:21 AM
To remove Continous blank spaces from a file in UNIX	arunkumar_mca	UNIX for Dummies Questions & Answers	1	12-08-2006 01:10 AM
remove extra lines in the file	CamTu	Shell Programming and Scripting	8	03-29-2005 02:13 PM

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


	Powered by