How to extract word in between specific words

[RamyaGunasekaran]

Example I have,

\\abcd123\aa\bb\cc\zip\folder1

\\abcd321\dd\zip\foldername1\gg

\\abdc213\aa\bb\cc\dd\zip\folder3\ee\ff

I want folder names as output like

folder1

foldername1

folder3

Help on this!!

[Jean-Balteryx]

Hi @RamyaGunasekaran ,

I guess your folders doesn't always contain the word "folder" ?

[RamyaGunasekaran]

No it can be different name but following by zip folder

[Jean-Balteryx]

There is always "zip" before ?

[atcodedog05 · Accepted solution]

Hi @RamyaGunasekaran 

You can use regex like below. Filename after zip\

zip\\(\w+)\\?

Workflow:

Hope this helps : )

[Jean-Balteryx]

@RamyaGunasekaran here is a workflow with a regex extracting the folder name !

[Jean-Balteryx]

@atcodedog05 got it before me !

[RamyaGunasekaran]

Above solution is working fine. But I got another case like below. Not only following by zip folder also by Bias folder

\\abcd123\aa\bb\cc\zip\folder1

\\abcd321\dd\zip\foldername1\gg

\\abdc213\aa\bb\cc\dd\Bias\folder3\ee\ff

\\abcd321\dd\Bias\folderNam6\hh

Expected Output:

folder1

foldername1

folder3

folderNam6

Help on this..

[atcodedog05]

Hi @RamyaGunasekaran 

You can use regex like below.

(:?zip|Bias)\\(\w+)\\?

Workflow:

Hope this helps : )

[RamyaGunasekaran]

In case if I have space in folder name, am not getting the complete name  of the folder like below

\\abcd123\aa\bb\cc\zip\folder1 subname\folder2

\\abcd321\dd\zip\foldername1_tt\gg

Expected Output:

folder1 subname

foldername1_tt

The ouput which am getting is

folder1

foldername1_tt