Shell Programming and Scripting

I have a data file with around 1 million records and i have 12 data fileds in each
record seperated by 11 pipes. The file also has some bad records where there is
only one pipe in some of the records. I want to print all this records with only
one pipe in them. These bad records are broken into two lines and hence they are bad.

Can someone let me know how i can print these to a new file.

sample file with good and bad records;

I want tp print the bad records in the file to a new file.

Code:

awk -F"|" ' NF == 2 { print; getline ; print } ' file > newfile

dsravan,
Try this:
grep -v '.*|.*|.*|.*|.*|.*|.*|.*|.*|.*|.*|' input_file

Code:

sed -n '/^[^|]*|[^|]*$/p' file > newfile

Code:

grep '^[^|]*|[^|]*$'  FILE > BADFILE

If you want to join all such lines with the following line:

Code:

awk -F'|' 'NF == 2 { printf "%s|", $0; next }
                            { print }' FILE > NEWFILE