Hi
my file data is like below

ramu,sony,"raju \n ravi \n ramya" \n
ravi,sarah,"sowmya \n sorry \n sangam" \n

i want replace new line characters in between double coats with single space.

for example
cat input_file

ramu,sony,"raju
ravi
ramya"
ravi,sarah,"sowmya
sorry
sangam"

which i dont want. i want out put like below.i want replace newline s in between double quoates.

ramu,sony,"raju ravi ramya"
ravi,sarah,"sowmya sorry sangam"

any body can help either perl script or any other script.

but JOEYG given follwoing solution.
it is not giving correct data

> cat new_lines | sed 's/" /" ~/' | tr "\n" " " | tr "~" "\n"

with above script iam getting out put in single line as below
ramu,sony,"raju ravi ramya" ravi,sarah,"sowmya sorry sangam"

but i want out put like below.

ramu,sony,"raju ravi ramya"
ravi,sarah,"sowmya sorry sangam"

Can you attach the datafile? I am having a difficult time undertanding the spacing of certain characters; also, trying to get at those floating <new-line> characters is difficult.

To attach a file here, use the paperclip icon.

 tr '\n' ' ' < file | sed 's/"  /"\
/g'

Hi JOYEG
please find attatchement as ZIP file.
Thanks

Attached Files

Book1.zip (852 Bytes, 7 views)

I think the issue from my script, and possibly other proposed solutions, has to do with the spacing around double-quotes and <new-line> characters.

See the following example coding. To begin with, made the file with a # in place of the <new-line> or \n character. Verify it is there, and then translate to get the charcter in the new file

> cat new_lines
ramu,sony,"raju # ravi # ramya" # 
ravi,sarah,"sowmya # sorry s\ sangam" # 
> cat new_lines | tr "#" "\n"
ramu,sony,"raju 
 ravi 
 ramya" 
 
ravi,sarah,"sowmya 
 sorry s\ sangam" 
 
> cat new_lines | tr "#" "\n" >new_lines2

> cat new_lines2 | sed 's/" /" ~/' | tr "\n" " " | tr "~" "\n" | tr -s " "
ramu,sony,"raju ravi ramya" 
 ravi,sarah,"sowmya sorry s\ sangam"

How about Perl:

vnix$ perl -0777 -pe '1 while s/("[^"\n]+)\n([^"]+"\r(?:$|\n))/\1 \2/' Book1.csv 
Mohan,Mohan,"Hello Hello Test"
Mohan,Mohan,"Hello Hello Test1"
Mohan,Mohan,"Hello Hello Test2"