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.
Solved! Go to 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
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! 🙂
Thank you so much for the help!