awk for loop on files in directory

Question

How could I loop through each file in a directory using this awk command?

awk -F: 'FNR==NR{a[$1]=$2;next} $2 in a{print $1 FS a[$2]}' email.phone.txt username.email.txt

Basically this partially matches columns and outputs the results in a combined fashion.

Example of this would be >

email.phone.txt - contains:

[email protected]:phoneexample

username.email.txt - contains:

user1:[email protected]
user131:[email protected]

EXPECTED OUTPUT - should be:

user1:phoneexample
user131:phoneexample

but this only works on 1 text file being

email.phone.txt

however I have multiple files with the same content in a subdirectory, example:

../lists/
email.phone1.txt
email.phone2.txt
email.phone3.txt
....

and it would be quite time consuming to individually awk each file, is it possible I could use a for loop for each file in directory and output example >

result1.txt
result2.txt
result3.txt
...

ilkkachu · Accepted Answer · 2019-03-28 23:14:44Z

0

Do you mean to run that awk script for each email.phone*.txt file, with the same username.email.txt? Something like this should do. The tail part (1.txt, etc.) of the output filename is taken from the input filename.

for f in email.phone*.txt; do
    out="result${f#email.phone}"       # remove leading 'email.phone'
    awk -F: 'FNR==NR{a[$1]=$2;next} $2 in a{print $1 FS a[$2]}' \
        "$f" username.email.txt > "$out"
done

answered Mar 28, 2019 at 23:14

ilkkachu

148k16 gold badges268 silver badges441 bronze badges

Thanks I'll give it a shot :) and accept answer once tested.

user343683
– user343683

2019-03-28 23:22:55 +00:00
Commented Mar 28, 2019 at 23:22

Add a comment |

Stack Exchange Network

awk for loop on files in directory

1 Answer 1

You must log in to answer this question.

Hot Network Questions

awk for loop on files in directory

1 Answer 1

You must log in to answer this question.

Related

Hot Network Questions