Turn File URL into multiple variable columns

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

Try


node with _ as delimiter.

1 Like

This topic was automatically closed 182 days after the last reply. New replies are no longer allowed.