Hey yall, I currently have this but I am trying to create 3 separate formulas that create "Jan" , "2019" , and "Jan 2019". Anything that someone can do would help so much. Thanks!
I
Hi @chughes49
I would recommend using the following expressions in your Formula tool:
Month:
REGEX_Replace([Field1], ".*\-\s(.*)\s.*", "$1")
Year:
tonumber(REGEX_Replace([Field1], ".*\-\s.*(\d{4})", "$1"))
Both:
REGEX_Replace([Field1], ".*\-\s(.*)", "$1")
@chughes49 One way to do it would be using the Text to columns tool to parse out the date field. Attached is the workflow. Hope this helps.
Hi, @Kenda
thanks so much, that was very helpful. However, the month and both formulas are the same which give both. What would need to be changed for it to be just "Jan'?
