Shell Programming and Scripting

Hi,

I have a delimited (|) file having millions of rows. Sometime the file comes with less number of delimiters than expected. In this scenario I want to delete the row having unmatched delimiters.

Can anyone help me with the command to achieve this?

Ex:
File1.txt

Code:

8039339595113|JIMMY JOHNS|||120281951||||NBM|
7039339595120|LOUANNA|||10020002||||NBM (here last delimiter is missing)

From the above file the o/p should return 1 line (that is the first line)

Thanks in advance..

Try:

Code:

awk -F\| NF==10 file > newfile

try also:

Code:

sed '/[|]$/!d' infile