Move/copy files from a folder to another folder based on a list of conditions

• Question

• 

  

  0

  Sign in to vote

  Friends,
  
  I have a folder with over 4k recordings that I need to sort based on three parameters that are inside a CSV or a TXT file. All these parameters are part of the file name.
  
  First, I need to select the files based on the Rec number, after that based on the date of recording and finally based on the test (verSacc, antisaccades, etc). Examples of some files names below.
  
  I am aware that I need to iterate through all files three times and pinpoint the right column in the CSV each time, but I do not know if a batch will be the right call for this or maybe another type of script...
  
  If you guys have experience with this, I would very much appreciate a response.
  
  Warm regards,
  Ovidiu
  
  EVALAB_Stimuli_26 feb 2017_antisaccades_Rec 01.tsv
  EVALAB_Stimuli_15 ian 2018_antisaccades_Rec 02.tsv
  EVALAB_Stimuli_11iulie2018_verSacc_Rec 57.tsv
  EVALAB_Stimuli_11iulie2018_verSacc_Rec 61.tsv
  EVALAB_Stimuli_29iulie2018_verSacc_Rec 109.tsv

  Thursday, January 9, 2020 5:46 PM