Shell Programming and Scripting

1,2,3,"ABC" 8" ABC,5,6,7 
1,2,3,"ABC"
8" ABC,5,6,7  ( New Line)
1,2,3,""ABC" 8" ABC", 5,6,7
1,2,3,"ABC"
,5,6,7(New line)

1|2|3|"ABC" 8" ABC|5|6|7
1|2|3|"ABC" 8" ABC|5|6|7
1|2|3|"ABC" 8" ABC|5|6|7
1|2|3|"ABC"|5|6|7

awk -F, 'NF!=7{ORS=(ORS!=" "?" ":RS)}{$1=$1}1' OFS=\| file

awk -F, '
        # if NF not equal to 7
        NF != 7 {
                # If ORS not equal to " " set ORS = " " else set ORS = RS (newline by default)
                ORS = ( ORS != " " ? " " : RS )
        }
        {
                # This stmt rebuilds current record, this is to set OFS = |
                $1 = $1
        }
        # 1 == true. If true, default awk operation is to print current record
        1
' OFS=\| file

awk -F, '/^1/ {a=1; OFS="|";v=$0;b=1} {if(a==1 && $0 !~ /^1/){v=v" "$0;b=0}} !b{gsub(/\,/,"|",v);print v} (a && b && NF==7){gsub(/\,/,"|",v);print v}' filename

1|2|3|"ABC" 8" ABC|5|6|7
1|2|3|"ABC" 8" ABC|5|6|7  ( New Line)
1|2|3|""ABC" 8" ABC"| 5|6|7
1|2|3|"ABC" |5|6|7(New line)

awk -F"," '{if($NF ~ "ABC"){ORS=" "} else {ORS="\n"}}{$1=$1} 1' OFS="|"  test14

1|2|3|"ABC" 8" ABC|5|6|7
1|2|3|"ABC" 8" ABC|5|6|7
1|2|3|""ABC" 8" ABC"| 5|6|7
1|2|3|"ABC" |5|6|7