Deleting column from a flatfile with delimiter

rsprabha · #1 (**permalink**) 06-06-2008

I have a set of flatfiles which have columns delimited by #. How can a particular column be deleted in all the flatfiles. All flatfiles have same number of columns.

jaduks · #2 (**permalink**) 06-07-2008

Code:

$ cat filea
a#b#c
d#e#f
g#h#i

if you have to delete the 2nd column,

$ awk 'BEGIN{FS=OFS="#"}{$2=""}{print}' filea
a##c
d##f
g##i

or 

$ awk 'BEGIN{FS=OFS="#"}{$2="";gsub(FS "+",FS)}1' filea
a#c
d#f
g#i

//Jadu

rsprabha · #3 (**permalink**) 10-03-2008

Hi,
Thanks for the reply. Can you please clarify one point. What is "1' at the end of the braces mean.

matrixmadhan · #4 (**permalink**) 10-03-2008

Quote:

Originally Posted by rsprabha

Hi,
Thanks for the reply. Can you please clarify one point. What is "1' at the end of the braces mean.

1 => print

rsprabha · #5 (**permalink**) 10-03-2008

Thanks a lot once again.

era · #6 (**permalink**) 10-03-2008

Or cut -d '#' -f1,3- file

More UNIX and Linux Forum Topics You Might Find Helpful
Thread	Thread Starter	Forum	Replies	Last Post
Traverse a flatfile and check for errors	aravindc	Shell Programming and Scripting	1	04-17-2008 02:56 AM
Adding field of flatfile by an index.	djsal	Shell Programming and Scripting	2	02-14-2007 12:53 PM
How to insert a record in fixed width flatfile	limou	Shell Programming and Scripting	1	03-13-2006 04:55 PM
encrypting Unix flatfile	rkumar28	UNIX for Dummies Questions & Answers	1	04-29-2004 09:31 AM
Finding a column in a flatfile	peter.herlihy	UNIX for Dummies Questions & Answers	3	01-07-2002 08:08 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