Programming

Dear All

I am using the following shell script to extract the columns from the file.

Code:

for filename in *.rpt
do
 awk -F"\t" '
    BEGIN {OFS="|"} FNR > 0 {print $1,$2,$3,$5,FILENAME}
    ' $filename >> output.txt
done

However, the script works fine. Instead of saving the single output file, I want to modify the script so that it saves as individual files.

Kindly advice.

Many Thanks
Balaji

change

Code:

$filename >> output.txt

to

Code:

$filename >> $(echo $filename)-output.txt

Will create "$filename-output.txt" for each $filename.

The echo command substitution is unnecessary. A simple $filename will do.

Regards,
Alister

Thank you for trying to use code tags. You got it nearly right. Next time use square brackets, [ ] , not triangular brackets, < >.

expl: That is a useless use of backticks. You don't need echo's help to get the value of a variable. You probably need { } to get the variable to expand properly however. ${filename} >> ${filename}-output.txt

This can be made much simpler by feeding the filenames right into awk. No loop necessary. It can even change the filename itself. It will work right with multiple files because FNR counts the line number inside a file, not the total numer of lines (NR).

FNR>0 will always print, incidentally, because FNR will always be a nonzero number. The very first line is 1. If you want it to skip the very first line of each file, that willl be FNR>1

Code:

awk 'BEGIN {OFS="|"} FNR > 0 {print $1,$2,$3,$5,FILENAME > FILENAME"-output.txt"}' *.rpt

Dear All

Thanks for all your suggestion and help.

It works.

Many Thanks
Balaji