When I use this code:
'DTH' + @fileDate + '^.*$'
I get DTH201510080900.xlsx
What does ^.*$
do? Does that give me the 0900 time?
This question is related to
regex
"^.*$"
literally just means select everything
"^" // anchors to the beginning of the line
".*" // zero or more of any character
"$" // anchors to end of line
Source: Stackoverflow.com