Shell Programming and Scripting

Hi Don,

Thanks this was working as expected. it written all the 3 transactions as expected to separate files. I want to change the code in such a way that i want to write all three transactions set into single file. could you please help me?

Thanks.

I would be happy to help you!

So, exactly what pathname should this single output file have?

What good is this file going to be given that the script that will be reading this file can only handle a single transaction?

Looking at the awk script I provided, what do you think should be changed to produce a single output file instead of one output file per transaction?

My guess would be that one line needs to be removed and one line needs to be changed. And, it might make sense (as a minor optimization) to move that changed line from its current location into a BEGIN clause or an FNR==1 clause depending on whether the desired output file pathname is a constant or is a modification of the second input file's pathname).

Hi Don,

I just changed

Code:

delete t[transnum = $3] to 
delete t[transnum = 123456]

print l[i] > file
print l[i] >> file

Now it started to write all the transaction numbers into a same output file

/tmp/remedixz.20160120_085021_41222370_1_123456

I will make the (hopefully not too wild guess) from this that the name of pathname of the output file you want is the pathname of the input file with the string _123456 appended.

The variable transnum in that awk script is intended to be the transaction number of the transaction that is being copied from the input file to the output file. And, since your transaction numbers are 19 character alphanumeric strings (not six digit decimal strings), setting transnum = 123456 is NOT appropriate.

Changing the:

Code:

print l[i] > file

to:

Code:

print l[i] >> file

means that instead of creating a new output file each time you run this script, it will append all of the transactions requested on the latest run to the output produced on any earlier runs. This would not seem to be a desirable side effect.

Please undo the changes you made and make the following changes instead:
First, change the line:

Code:

	file = FILENAME "_" transnum

to:

Code:

	file = FILENAME "_123456"

and, second, delete the line:

Code:

		close(file)

With these changes, the transaction number printed when a transaction is copied to the output file will again be printed correctly and a single output file will be produced each time the script is run (and will contain only the transactions extracted on that execution of the script). Later executions of the script will replace the contents of that file (if it still exists from an earlier run) or create that file (if it had been removed).