Shell Programming and Scripting

$ DEL=$(printf '%b' "\x7F")
$ sed "s/~/$DEL/g" > infile <<EOF
> one,two,~Multi-line
> field
> with embedded ,~,four,five
> one,two,three,four,five
> one,two,~simple,string~,four,five
> EOF
$ sed "s/$DEL/|/g" infile
one,two,|Multi-line
field
with embedded ,|,four,five
one,two,three,four,five
one,two,|simple string|,four,five

awk -v DEL=$(printf "%b" "\x7F") '
@include "csv.awk"
{ num_fields = csv_parse($0, csv, ",", DEL, "", "\n", 1)
  for(i=1;i<=num_fields;i++) gsub("\n", " ", csv[i]);
  print csv_create(csv, num_fields, ",", DEL)
}' infile > outfile

$ sed "s/$DEL/|/g" outfile
one,two,|Multi-line field with embedded ,|,four,five
one,two,three,four,five
one,two,simple string,four,five

awk '(NR-1)%2  {$1=$1}1' RS=\" ORS=\" infile

 
 
Sample Data :
 
"Line1  RENT-A-
CAR XYZ LTD","00N0H","Enterprise Lake
View Way"
"Line 2 RENT-A-
CAR XYZ LTD","00N0H","Enterprise Lake
View Way"
 
Result :
 
"Line1 RENT-A- CAR XYZ LTD","00N0H","Enterprise Lake View Way"
"Line 2 RENT-A- CAR XYZ LTD","00N0H","Enterprise Lake View Way"
"
 
Expected:
 
"Line1 RENT-A- CAR XYZ LTD","00N0H","Enterprise Lake View Way"
"Line 2 RENT-A- CAR XYZ LTD","00N0H","Enterprise Lake View Way"

awk '{for(i=1;i<=NF;i+=6){print $i,$(i+1),$(i+2),FS,$(i+3),$(i+4),$(i+5)}}' FS="\n"  RS=""