Date Extract

[KamenRider]

Hi,

Can someone help me get the date 05.20.24?

05.20.24 Porres Beerend Holiday Luck Exp Date Report

Thanks,

Kamen

[alexnajm · Accepted solution]

RegEx_Replace([Field], "(\d\d\.\d\d\.\d\d).+", "$1")

[JBLove]

@KamenRider  - 

You can use a regex tool with the Parse output method selected.  The following expression will retrieve the date value(05.20.24) from the string: "05.20.24 Porres Beerend Holiday Luck Exp Date Report"

(\d+\.\d+.\d+)\s.+

If you're not familiar with regex, the parenthesis creates a marked grouping, and for these purposes that represents the new field extracting the date format out.

\d+ represents 1 or more digits

\. represents a single "."

\s represents a single whitespace

.+ represents 1 or more any character