Regex for Date

Question

Hi Alteryx Champions,

Need help in extracting the numbers that are coming at the end. In the attached screen-shot, I would require -19,911 and 453,590 to come out into a separate column similarly 01/04/22 from the below string:

Date entered..............................................................01/04/22

Regex_Question.png

gawa · Accepted Answer

Try Regex tool or Formula's Regex_Replace function, with "^.*(\d{2}/\d{2}/\d{2}$)".

Pranab_C · Accepted Answer

Thank you so much for your quick reply, it worked for the dates, can you please help with the second part of the question too.

CoG · Accepted Answer

Based on the image, something like this may work:
.*\s(.*?\d.*?$)

gawa · Accepted Answer

For your reference, Regex Cheat Seat here

https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Discussions/Sharing-RegEx-Cheat-Sheet/m-p/1206220