UNIX for Dummies Questions & Answers

suppose there are 100 records.

out of that 50 records are errored out due to various reasons.
ex:

Input Rec # 80 Client: BGA Rx No: 7820730 Fill Date: 20070629
Error: (W)Submit Date before Fill Date(SUBMIT-DATE)

Input Rec # 143 Client: BGA Rx No: 7697233 Fill Date: 20070630
Error: (W)Submit Date before Fill Date(SUBMIT-DATE)

Input Rec # 150 Client: BGARx No: 7713043 Fill Date: 20070627
Error: (W)Submit Date after Fill Date(SUBMIT-DATE)

so i want to catch a row above error that was errored out due to "after fill date" so that i can have Rec#


so when i use sed -n '/after/{g;1!p;};h' abc.txt i get all blank lines.

I guess this helps

@cassj

Thank you for the way you have presented. just awesome!

There are blank lines present between records as i have displayed.

Ohh sachin.gangadha, I see the problem you're having.

The command you are using INCORRECTLY has "after" in it:

Code:

INCORRECT:  sed -n '/after/{g;1!p;};h' abc.txt

The CORRECT command you should be using should have "[Ee]rror" instead of "after".

Code:

CORRECT:  sed -n '/[Ee]rror/{g;1!p;};h' abc.txt

Cheers and all the thanks should go to vgersh99. :-)

A big thank you to vgersh99!

@cassg

look at this" Error: (W)Submit Date after Fill Date(SUBMIT-DATE)"

this error is due to after i.e, why i chose after if i choose error then it will list all the records errored out.

not sure what is wrong with the solution, but.....
sachin.txt:

Code:

Input Rec # 80 Client: BGA Rx No: 7820730 Fill Date: 20070629
Error: (W)Submit Date before Fill Date(SUBMIT-DATE)

Input Rec # 143 Client: BGA Rx No: 7697233 Fill Date: 20070630
Error: (W)Submit Date before Fill Date(SUBMIT-DATE)

Input Rec # 150 Client: BGARx No: 7713043 Fill Date: 20070627
Error: (W)Submit Date after Fill Date(SUBMIT-DATE)

Code:

sed -n '/after/{g;1!p;};h' sachin.txt

output:

Code:

Input Rec # 150 Client: BGARx No: 7713043 Fill Date: 20070627

Isn't what you would expect?
Or is it not what you wanted?

BTW, all the brownie points go to Eric Pement@ sed1line

yes i want this o/p:
Input Rec # 150 Client: BGARx No: 7713043 Fill Date: 20070627

to remove blank lines what i did was
cat abc.txt|grep -v "^$" >xyz.txt
but the blank line doesnt go away.

can any one tell me why the blank lines are not deleted.
I tried all the commands mentioned in this forum to delete blank lines but its not working.

Is there any way i can sent a sample of that file.

I don't understand why you need to delete blank lines, but....

Code:

sed -n '/^$/d;/after/{g;1!p;};h' sachin.txt

Maybe your 'blank lines' are not blank at all? Could there be spaces/tabs?

You can either attach the file to the thread OR using vB Codes quote a portion of the file.