Sstrhsrtj

What I'm trying to accomplish is to move files in my directory that match with the records in my text file based on 2 parameters.

For example I have a record in my text file that reads:

SPPARK|10416|3308123|3308123|Uphold|Thelma|1930/05/20||

I have a file in my directory that reads:

1123_M1123_UPHOLD_M1123_MESSAGE_SPPARK_348642.pdf

So if last name UPHOLD and 4th field M1123 match up to my fields in my text file, then I want to move them to a specified directory.

for files in test/* ; do

 echo $files | awk -F "_" '{print $3,$4}'

done

Try this one. Change "echo" command to cp or mv after testing:

for f in samples.txt ; do 

  echo /source/path/*$(cut -d '|' -f 5,2 $f | tr '|'a-z '_'A-Z)*.pdf /destination/path

done

I'm sorry, my bad. Thanks @Kusalananda. Please, consider the above answer wrong and try this one instead. Supposing you are filtering on 5-th and 4-th columns it copies files from /src to /dst:

awk -F "|" '{system("cp /src/*"toupper($5)"_"$4"*.pdf /dst")}' samples.txt

I would approach this the other way around:

• read and split the text file into fields line-by-line


• match and move the corresponding files

E.G. (assumes bash and GNU mv):

#!/bin/bash



shopt -s nullglob



while IFS='|' read -r loc a b c last first d e; do 

  echo mv --no-clobber -t path/to/target/ -- *_"$a"_"${last^^}"_*_*_*_*.pdf

done < file.txt

Remove the echo once you are satisfied that it is doing what you want