Shell Programming and Scripting

Dear friends,


I have a pipe delimited file having 5 columns.
However the column no-3 is having extra new line characters as the data owing to owing , I am having issues.

Ideally my file should have only newline termination at the end of each record and not within column data of any of columns [1-4]. this is my requirement

Can you pls advice if we can resolve this via AWK/other commands

Awaiting reply
Many thx in advance

Regards,
Suresh

If your file has a format like this:

Code:

1|2|3
|4|5
11|12|13
|14|15
21|22|23|24|25

This should work:

Code:

awk -F"|" 'NF<5{printf("%s",$0);getline;print;next}1' file

Regards