Struggling with RegEx

[JLF]

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.

[AngelosPachis · Accepted solution]

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!