Extract Date from Text

iteng

Hello,

I'm new to Alteryx and slowly developing my skillset. I'm trying to extract year information from text (for example "XXX - Year 2020" and "XXX - Year 2020-2022") to a new column. I'm trying out the RegEx function and want to write something that helps put information after "-" or word "year" into a new column, but having some trouble entering the correct regular expression. Any solution or suggestions would be much appreciated!

IraWatt

Hey @iteng,

This regex will get anything after a -

-(.*)

This regex will get anything after year

year(.*)

If you wanted to identify any 4 digits use this

\d{4}

For this problem I would use something like

year ([\d-]+)

Check out regex101: build, test, and debug regex to learn more about and test regex.

Any questions or issues please ask
HTH!
Ira

Workflow0506.yxmd