Regex for Date

[Pranab_C]

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

[gawa · Accepted solution]

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

[Pranab_C · Accepted solution]

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 solution]

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

[Pranab_C]

Thank you that worked out

[gawa · Accepted solution]

For your reference, Regex Cheat Seat here

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