need to concatenate two lines if the line doesnt end with quotes

laxmi131 · #1 (**permalink**) 10-27-2008

Hi

I am getting a source file where the columns are seperated by comma and double Quotes
Eg1 : "AAA","BBB","CCCC"
in the same source file i am also getting few lines where my last columns double quotes are ending in its next line or the next next line

Eg2: "AAA","BBB","CCC
CC"
(or)

"AAA","BBB","CCC
CC
CCC"
I need to concatenate all such lines( shown in Eg2) and make it in to single line (as shown in Eg1)

Can any one please help me in this regard.How can this be acheived through unix

Thanks in advance

laxmi131 · #2 (**permalink**) 10-27-2008

Hi

I am getting a source file where the columns are seperated by comma and double Quotes
Eg1 : "AAA","BBB","CCCC"

in the same source file i am also getting few lines where my last column double quotes are ending in its next line or the next next line

ForEg2: "AAA","BBB","CCC
CC"
(or)

"AAA","BBB","CCC
CC
CCC"
I need to concatenate all such lines(as shown in Eg2) and make it in to single line (as shown in Eg1)

Can any one please help me in this regard.How can this be acheived through unix

Thanks in advance

Annihilannic · #3 (**permalink**) 10-27-2008

Cross posted:

http://www.unix.com/shell-programmin...nd-quotes.html

ranjithpr · #4 (**permalink**) 10-27-2008

$ cat file.txt
"AAA","BBB","CCC
CC"
"AAA","BBB","CCC
CC
CCC"
$ awk '{if(substr($0,length)=="\"") print;else printf("%s",$0);}' file.txt
"AAA","BBB","CCCCC"
"AAA","BBB","CCCCCCCC"

laxmi131 · #5 (**permalink**) 10-27-2008

Hey
Thanks a lot its working

laxmi131 · #6 (**permalink**) 10-27-2008

How can we acheive this using "sed" command

zaxxon · #7 (**permalink**) 10-27-2008

Code:

root@isau02:/data/tmp/testfeld> cat infile
"AAA","BBB","CCC
CC"
"AAA","BBB","CCC
CC
CCC"
root@isau02:/data/tmp/testfeld> sed -e :a -e '/[^"]$/ { N; s/\n// ;ta}' infile
"AAA","BBB","CCCCC"
"AAA","BBB","CCCCCCCC"

More UNIX and Linux Forum Topics You Might Find Helpful
Thread	Thread Starter	Forum	Replies	Last Post
concatenate all duplicate line in a file.	vaskarbasak	Shell Programming and Scripting	30	08-29-2008 05:31 AM
concatenate and display 2 lines as 1 with a condition for 2 line ?	vithala	Shell Programming and Scripting	7	07-11-2008 01:01 AM
Need solution concatenate and display 2 lines as 1 with a condition for 2 line ?	vithala	UNIX for Advanced & Expert Users	1	07-10-2008 01:27 PM
how to concatenate two command in one line and get the display in one screen	vasikaran	UNIX for Dummies Questions & Answers	9	07-01-2005 05:41 AM
SSH doesnt exit properly from command line	frustrated1	SUN Solaris	4	06-16-2005 04:30 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: