[Solved] using sed delete a line from csv file based on specific data in two separate fields

Chris Eagleson · #1 10-10-2012

Hello,

I have a 12 column csv file. I wish to delete the entire line if column 7 = hello and column 12 = goodbye. I have tried everything that I can find in all of my ref books.

I know this does not work

Code:

/^[^,]*,[^,]*,[^,]*,[^,]*,[^,]*,[^,]*,[^,]"hello",[^,]*,[^,]*,[^,]*,[^,]*,[^,]"goodbye"/d

rdrtx1 · #2 10-10-2012

Code:

sed '/^[^,]*,[^,]*,[^,]*,[^,]*,[^,]*,[^,]*,"hello",[^,]*,[^,]*,[^,]*,[^,]*,"goodbye"/d' infile

Chris Eagleson · #3 10-10-2012

Perfect. That worked.

Thanks

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

More UNIX and Linux Forum Topics You Might Find Helpful
Thread	Thread Starter	Forum	Replies	Last Post
Delete line based on count of specific character	tiggyboo	Shell Programming and Scripting	5	06-25-2012 11:18 AM
[Solved] making each word of a line to a separate line	rbalaj16	Shell Programming and Scripting	8	03-26-2012 05:09 AM
Extracting specific lines of data from a file and related lines of data based on a grep value range?	Wynner	Shell Programming and Scripting	3	05-18-2011 11:35 AM
Match data based on two fields, and append to a line	jamessmith01	Shell Programming and Scripting	20	09-06-2010 12:22 PM
Delete line in file based on data in another file	earth_goddess	Shell Programming and Scripting	1	12-29-2008 09:47 AM