Can Alteryx extract part of a file name and append it as a new column? I am trying to mass load 800 files, but need to extract the date that is part of each file name. To complicate matters, not all date formats are the same. Ideally I would like to ask Alteryx to grab everything that is right off the letters PPV (see screenshot):
Solved! Go to Solution.
@jrgo - you are a life saver! Thank you. I am super close to getting this incorporated into my workflow. I think the expression you provided needs to be modified, but I can't figure out the syntax. Can you please assist?
Yeah, that expression will not work if you're bringing in the entire file path. Try this instead...
^.+PPV\s(.+).xlsx\|.+$
THANK YOU!!!! I am so incredibly thankful.
Hi,
Can you help me to PARSE my FileName column-
\\ABC-WIN-NAS-P21.ABC.com\GOT_FS\Log_Cost\Contingency\Outputs\COGNOS\COGNOS_Unit_DC.csv
I need only COGNOS_Unit_DC from the Filename column
FileGetFileName([filepath]])
This function will pull out the file name, excluding the extension.
This is the most elegant way to retrieve the file name