Hi,
Can someone help me get the date 05.20.24?
05.20.24 Porres Beerend Holiday Luck Exp Date Report
Thanks,
Kamen
Solved! Go to Solution.
RegEx_Replace([Field], "(\d\d\.\d\d\.\d\d).+", "$1")
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