Shell Programming and Scripting

I get the desired output:

Code:

$ cat file
firstrecord|secondrecord|thirdrecord|fourthrecord|fivthrecord|s
ixhrecord|seventhrecord|

coulmnone|coulmntwo|coulmnthree|coulmnfour|coulmnfive|coul
mnsix|coulmnseven|

$ awk '!/\|$/ && NF{s=$0;getline;print s $0}' file
firstrecord|secondrecord|thirdrecord|fourthrecord|fivthrecord|sixhrecord|seventhrecord|
coulmnone|coulmntwo|coulmnthree|coulmnfour|coulmnfive|coulmnsix|coulmnseven|
$

Regards

Hi

i apologize for that, i have made a mistake in my query,my output looks like ,there is a whitespace in the continuation of the first line to the second line, but i need the output in a single line

firstrecord|secondrecord|thirdrecord|fourthrecord|fivthrecord|s
(Whitespace)ixhrecord|seventhrecord|

coulmnone|coulmntwo|coulmnthree|coulmnfour|coulmnfive|coul
(Whitespace)mnsix|coulmnseven|

which would need to be like ,

firstrecord|secondrecord|thirdrecord|fourthrecord|fivthrecord|sixhrecord|seventhrecord|
coulmnone|coulmntwo|coulmnthree|coulmnfour|coulmnfive|coulmnsix|coulmnseven|

Kindly advice.

Try this:

Code:

awk '!/\|$/ && NF{s=$0;getline;sub(/^ /, "");print s $0}' file

Hi ,

Thanks you very much, the cmd worked fine for any file created with a tab in the second line. But as my file was generated through isql this cmd dint worked for me, as isql result has a default of 80 char, once i chaged the default column width it worked for me .

isql -w 250

this is the cmd used to set coulum width.

Thanks for your replies.