Trim and Copy numbers st passed the date

[jansson17]

I have a column of dates with added digits to the end of each date. 
I need to be able to trim the trailing digits off the end of the string/year and place them into a new column label overage.

Date

4/12/202252

7/8/202224

5/10/202248

3/17/202265

8/12/202298

4/27/202217

10/10/202299

12/1/202278

1/13/202296

Goal

Date	Overage
4/12/2022	52
7/8/2022	24
5/10/2022	48

[cjaneczko]

You can use a formula tool. To extract the date you can use Regex \d+\/\d+\/\d{4}. For the trailing digits you can use a right(FieldName,2)

[GMG0241]

Following on from @cjaneczko, If you want an all in one, you can use REGEX_REPLACE([Date],"\d+\/\d+\/\d{4}(.*)","$1") where the regex expression in the brackets is outputted. In the example I provided, it gets any character (digit, string, whatever) but you could change it to something like  "\d+\/\d+\/\d{4}(\d+)" if you specifically only wanted to grab digits