Hello. I have a current workflow that reads in several CSV files from a specified folder. These CSV files are intentionally named and have specific variable in the name. I am trying to figure out how to take the Data URL and turn it into several variable columns. Below is an example of what I mean.
file:/C:/Users/Name/Folder/Folder//ABCD_VARIABLE1_VARIABLE2_VARIABLE3.csv
that is an example of the data path. I want to take the variable 1 2 and 3 and put them in individual columns. It would be nice to manipulate the string backwards, since my folder names will change lengths but my csv files will always have the same length