Skip to main content
Question

Filename wildcard

  • August 7, 2023
  • 1 reply
  • 348 views

Forum|alt.badge.img

I have a bot that takes an excel file and makes it an access database.  There are list of filenames of files that need to be moved.  i have a column that says file name and it will say filename, however i don’t have the full name of the file as each day there will be a date added to the file.  example it will say filename “date” or filename_”date”.  

 

how do i get the bot so see the filename variable matches the filename in the table? 

1 reply

rbkadiyam
Premier Pathfinder | Tier 7
Forum|alt.badge.img+17
  • Premier Pathfinder | Tier 7
  • August 9, 2023

@AA_Deathstar use string operation contains