I need help with this parse in the RegEx Tool. I want to extract the department name from the filepath. Thank you! Filename:Desired Result:Food Safety Self Audit - Bakery(1-733)BakeryFood Safety Self Audit - Grocery(1-454)GroceryFood Safety Self Audit - Meat(1-867)MeatFood Safety Self Audit - Produce(1-857)ProduceFood Safety Self Audit - Seafood(1-342)Seafood

RegEx Tool to Parse Out Part of File Name

I need help with this parse in the RegEx Tool. I want to extract the department name from the filepath. Thank you!

Filename:	Desired Result:
Food Safety Self Audit - Bakery(1-733)	Bakery
Food Safety Self Audit - Grocery(1-454)	Grocery
Food Safety Self Audit - Meat(1-867)	Meat
Food Safety Self Audit - Produce(1-857)	Produce
Food Safety Self Audit - Seafood(1-342)	Seafood

Regex

Parse

Accepted answers

echuong1

Try this: .+\-\s(\w+)\(.+

New Workflow1.yxmd

echuong1

Try this:

.+\-\s(\w.+)\(.+

This is essentially looking for text following a dash and a space, and including everything until it finds the first parenthesis.

New Workflow1 (10).yxmd

All comments

Emil_Kos

Hi @KmbrlyPC,

I have prepared a workflow for you:

The output:

Regex.yxmd

afv2688

Hello @KmbrlyPC ,

Try the following soltion:

Regex_Replace([Field1],'(.*\s\-\s)(.*)(\(.*\))','$2')

Regards

echuong1

Try this: .+\-\s(\w+)\(.+

New Workflow1.yxmd

KmbrlyPC

It worked, thank you!

KmbrlyPC

I have a few instances in which the Department Name that I want to parse from the file path is two words. For example "Prep Foods". For these two word departments, using .+\-\s(\w+)\(.+ is not working.

OliviaNoah87

Thanks I also got solution for my bakery.
Regards,
Delicia Manager

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15878

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703