Hi, I am new to Alteryx and I'm trying to parse out the date information out of a string of text.
The text is written as follows ABC_DEF_GHI_JKL_MNO_202210189999. I am trying to use the first 8 digits in the last word of the text string to get month information. Any suggestions are appreciated! Thank you.
Hello @crownhang.
Here's one method, using a Formula tool. I've attached the workflow. The formula can be edited to be more robust; this is just an example. Please let me know if you need an explanation or further editing.
Thank you!!! It works. Would you mind explaining ".*_(2021\d{4}).*", "$1" in the formula? Appreciate it.
@crownhang One way of doing this
DateTimeFormat(DateTimeParse(REGEX_Replace([Field], '.*_(\d{8}).+', '$1'),'%Y%m%d'),'%B')
REGEX_Replace([Field], '.*_(\d{8}).+', '$1') -