How to get only report date from this string

Hi All, how to get only report date from this string :

“Details 09 Aug 2023.xlsx”

report date which is needed = 09 Aug 2023

Thanks.

Hi @Suastrian_Dika

\d+\s+\w+\s+\d+

image

1 Like

yourstring.split(" “c)(1).tostring.replace(”.xlsx",string.empty)

@Suastrian_Dika
Str_FileName=Path.GetFileNameWithOutExtension(“FilePath”)

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.