I'm looking to extract the schedule names out of the following files I've imported: Imported File NameDesired OutputFFIEC CDR Call Schedule RIA 09302020RIAFFIEC CDR Call Schedule RCB 09302020(1 of 2)RCB1FFIEC CDR Call Schedule RCB 09302020(2 of 2)RCB2 Any help would be appreciated.

Struggling with RegEx

I'm looking to extract the schedule names out of the following files I've imported:

Imported File Name	Desired Output
FFIEC CDR Call Schedule RIA 09302020	RIA
FFIEC CDR Call Schedule RCB 09302020(1 of 2)	RCB1
FFIEC CDR Call Schedule RCB 09302020(2 of 2)	RCB2

Any help would be appreciated.

Regex

Accepted answers

AngelosPachis

Hi @JLF ,

As long as what you want to parse is in capital letters, then that should work

or another option is to parse whatever comes after "FFIEC CDR Call Schedule " and before a digit

FFIEC CDR Call Schedule (.*?) \d

All comments

AngelosPachis

Hi @JLF ,

As long as what you want to parse is in capital letters, then that should work

or another option is to parse whatever comes after "FFIEC CDR Call Schedule " and before a digit

FFIEC CDR Call Schedule (.*?) \d

mhey01

Hey @JLF 🙂

In addition to @AngelosPachis' response, you should look up regexone and regex101 in a search engine (would copy and paste the sites for you but can't share URLs on this forum).

Regexone is really good for actually learning how to use regex, and then regex101 is really good for testing your regex before you stick it into Alteryx.

Hope this is useful! 🙂

JLF

Thank you so much for the help!

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703