Text to columns - Help

[RKGV]

Hi

I am a newbee here seeking your support.

I have value is below in one column and need o/p as below.

Input - \\Folder\Example1\02_AlteryxFlow\IDOCTool_Hourly.yxmd

Output -  IDOCTool_Hourly

thanks in advance.

[Jean-Balteryx · Accepted solution]

Hi @RKGV ,

Here is a workflow using REGEX to extract filename whatever the file extension.

[RKGV]

Thanks Jean 🙂 

[Jean-Balteryx]

You are welcome @RKGV ! 🙂