Shell Programming and Scripting

Hi, firstly,there was a superfluous ']' in the code, I took it out in the post...
To understand awk, perhaps it helps to realize that awk statements in the main section implicitly work on a per line basis, so they are executed as if in a loop and are processing every line in the file.

Could you give an example of such a transaction log with 3 records?

Scrutinizer,

Yes, after a second glance, I realized the extra "]" and when I took out, it just ran well.

Sure here is the sample set of records with 3 records instead of two.

Code:

11393 18.77(E) AUTH 43034
11393 23.77(E) PRES 43034
11393 23.77(E) SETT 43034


11571 25.03(E) AUTH 39840002
11571 34.53(E) PRES 39840002
11571 34.53(E) SETT 39840002


11884 76.29($) AUTH 4954884
11884 90.29($) PRES 4954884
11884 90.29($) SETT 4954884

and out of these, I just want the Account numbers as below and I dont want anymore details(& I just realized that now)

Code:

11393
11571
11884

as these are the values that are stored in Oracle and Im just trying to create a look up file so that sqlloader can insert these records into the db.

Finally, thanks a bunch on your help.

regards,
PGonzalez.

How about:

Code:

awk '/SETT/{print $1}' infile

If SETT is the final transaction (I don't know)
Or do you still need to check something?

Scrutinizer,

Thank you for the reply.

To make it a bit more clear, SETT is the final part of the puzzle & is an abbreviation for SETTLEMENT. These three records have to looked at together and if any of these three i.e., AUTH(AUTHORIZATION), PRES(PRESENTMENT) & SETT(SETTLEMENT) are not there then it is considered as INCOMPLETE record. We report only on COMPLETE SETS and only when you find all these three transactions then we would want to see that ACCOUNT NUMBER.

So, if you can just print only the account numbers that have all these three types of records, then we are good.

I hope Im clear now and in case of questions, please feel free to revert back to me and I shall respond back right away.

Thank you for the initiative & your BIG HELP.

regards,
PG.

Hi try this:

Code:

awk '/AUTH/{A[$NF]++} /PRES/{P[$NF]++} /SETT/&& A[$NF] && P[$NF]{print $1}' infile

or

Code:

 awk '/AUTH/{A[$NF]++} /PRES/{P[$NF]++} /SETT/&& A[$NF] && P[$NF]{print $1; delete A[$NF]; delete P[$NF]}' infile

for the more memory efficient version...

These will print the same account number multiple times if it has more than one transaction.

Scrutinizer,

You truly are exalted !

regards,
PGonzalez.