Selecting and reading a csv file with a filename that includes today's date yyyyMMdd


#1

Hi there,
On a daily basis, I need to read a csv file that has been deposited into a specific directory by another application. The filename for the csv file will include the current day’s date i.e. “ABC_DE_yyyyMMdd.csv”
How do I configure the workflow so that the software can read the file each and every day?

Many thanks


#2

Str fileName = “ABC_DE_” + now.ToString(“yyyyMMdd”)+".csv"

That will set your fileName variable to ABC_DE_20180705.csv (For today’s date)


#3

Thank you very much for your help @Alex_Trappett