Using 'sed' to delete or ignore columns in a dataset - UNIX for Dummies Questions & Answers

aarif · #1 02-29-2008

Hi,

I've already posted elsewhere but am posting again here coz im a newbie. I hope you forgive me this time.

I want to know if its possible to delete or ignore columns in a large dataset using 'sed'. For example, I have the following dataset: -

20060714,X.XX,1,043004,Q,T,24.0000,1,25.5000,4,
20060714,X.XX,1,081209,Q,T,24.0000,1,25.5000,5,

As you can see, there are 10 columns here and the table that I am inserting into has 8 columns.

I want to delete the 3rd column (i.e. the 1's) and I want to delete the comma between Q and T. Finally I want to delete the comma at the end.

Is this possible with sed? Can any1 help me with this please?

I'll be extremely grateful if someone can help with this!! You can PM me or post back here.

Many Thanks, asif.

More UNIX and Linux Forum Topics You Might Find Helpful
Thread	Thread Starter	Forum	Replies	Last Post
Using 'sed' to delete or ignore columns in a dataset	aarif	UNIX for Dummies Questions & Answers	4	07-21-2008 09:22 AM
Numbers of records in SAS dataset	sasaliasim	Shell Programming and Scripting	2	04-21-2008 01:55 PM
Delete particular value from file using 'sed'	sai_nj	Shell Programming and Scripting	2	03-30-2008 09:38 PM
delete some columns	su_in99	UNIX for Dummies Questions & Answers	7	05-15-2007 11:08 PM
Accessing Mainframe Dataset	IcyGuava	UNIX for Dummies Questions & Answers	4	10-18-2001 05:12 PM

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