Extracting the records which contains atleast one double quote(")

vsairam · #1 (**permalink**) 07-17-2009

Hi Experts,

I have a file with some of records contain double quotes ("). I need to write these records in separate file and have to delete the same records from the original file.

For Example:

Orginal File :

Code:

 
100000,abcd,CRED,MO
100001,"efgh",CRED
100002,ijkl,CRED,TX
100003,"mnop",CRED,TX
100004,qrstuv,CRED

rakeshawasthi · #2 (**permalink**) 07-17-2009

Try:

Code:

awk '{if($0 ~ "\"") printf $0"\n" >> "file1";else printf $0"\n" >> "file2"}' inputfile

panyam · #3 (**permalink**) 07-17-2009

Something Like this :

Code:

awk '$0 ~ /"/ {print >"File1";next} {print >"File2"}'  File_name.txt

zaxxon · #4 (**permalink**) 07-17-2009

Code:

$> awk '/\"/ {print >> "file2"; next} {print >> "file1"}' infile
$> cat file1
100000,abcd,CRED,MO
100002,ijkl,CRED,TX
100004,qrstuv,CRED
$> cat file2
100001,"efgh",CRED
100003,"mnop",CRED,TX

More UNIX and Linux Forum Topics You Might Find Helpful
Thread	Thread Starter	Forum	Replies	Last Post
double-quote inside double-quote	indraf	Shell Programming and Scripting	3	10-20-2008 06:53 AM
How to get rid of double quote in sed.	anakiar	Shell Programming and Scripting	6	07-28-2008 09:56 AM
Problem with double quote and string variable	mattemp	Shell Programming and Scripting	6	03-19-2008 01:21 AM
Escape Char for double quote	navik_pathak	Shell Programming and Scripting	1	01-05-2007 02:34 PM
single or double quote in SED	asami	Shell Programming and Scripting	2	07-17-2006 04:03 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