Alteryx Designer, FileName, Extract Workbook Name and Sheet Name.

[brperkins2]

I am using Alteryx Designer. I have a column with the FileName that was imported into Alteryx Workflow. Here is an example.

H:\1_1_ALL\01.02.Working_On\Alteryx_Files\Input_Files\CB289_PopID_Input_File.xlsx|||`1_1$`.

How do I extract the Workbook Name and Sheet Name from the FileName column? I have attached the Alteryx workflow. I am familiar with Regex, but have not used it for this purpose yet in Alteryx.

[DataNath]

How does this look, @brperkins2?

If you don't want the .xlsx part in the workbook name then you can just move it out of the capture group like so:

Both examples in the attached.