Grep Out of a CSV

eltinator · #1 (**permalink**) 02-10-2009

Hi, I have a CSV file and would like to grep out a particular row of values. The CSV file looks something like...

"email", "data", "date", "other data", "blah", "NUMBER I WANT", "more stuff", and "more stuff"

The file has hundreds of lines and I basically just want the number after the 5th comma. If it helps any, the number is always preceded by the letter "E" Any help would be appreciated, thanks!

timontt · #2 (**permalink**) 02-10-2009

if just need to get col after 5th comma, try below

cat csvfile | awk -F, '{print $6}'

Thanks!

eltinator · #3 (**permalink**) 02-11-2009

Awesome! One more thing I forgot to mention, the number I want is surrounded by "". How can I get rid of those quotation marks? Thanks so much!

just4fundoit · #4 (**permalink**) 02-11-2009

cat csvfile | awk -F, '{print $6}' |sed 's/"//g'

More UNIX and Linux Forum Topics You Might Find Helpful
Thread	Thread Starter	Forum	Replies	Last Post
MEM=`ps v $PPID\| grep -i db2 \| grep -v grep\| awk '{ if ( $7 ~ " " ) { print 0 } else	hariza	Shell Programming and Scripting	4	09-18-2008 03:56 AM
grep and fetching lines after grep	arghya_owen	Shell Programming and Scripting	2	07-16-2008 08:25 AM
how to exclude the GREP command from GREP	yamsin789	UNIX for Advanced & Expert Users	2	10-05-2007 03:59 AM
How to grep	kamathg	Shell Programming and Scripting	2	08-06-2007 05:24 PM
Make grep -c display like grep -n?	Jerrad	Shell Programming and Scripting	2	08-25-2006 01:20 AM

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