I have a simple requirement but not able trace the right link for it. So posted here.
I am getting different file names which is having "Year" as part of the file name. I want to have some trend based on the "Quarter" & "Year" for which the file generated. I don't want to assume the "Year" is always in a fixed position especially from the right side.
My filename looks like : DK_Q3_XYX_DTRR_KL_2018-09-21_08-48-08.xlsx , to understand if the file name is holding a valid "year" or not i am using the below expression WildMatch(File,'*_20??-*'). At the moment we can assume, the filename always in YYYY format.
I want your suggestion what is the best way to extract the "Year" from the file name considering the dynamics ( specifically by the expression mentioned in the WildMatch function.