I want to program a robot to read a csv file found in a folder. However ever time a new csv file is put into the folder there is a unique id in the name of the file. The name would always have the same format with a name followed by an “_” then the date, YYYYMMDD, then the unique number , e.g. Account_20200216_981237.
Would like to know how to read the csv file and store the data into a data table without having to know what the unique number at the end is.
So if I understood correctly, you would like to read a CSV file’s content but the CSV filename is unknown to you.
What I would do is loop the directory and pick the file(s) you would like to have read by the robot. Here’s the code that you are able to use in the Invoke Code activity setting the activity’s language to “CSharp”: