Split text?

@fairymemay - Another solution…

image

 "Suspend_de_20210613_175410.xlsx".Split("2"c)(0).trim("_"c)

Assuming you will get 2021 always

"Suspend_de_20210613_175410.xlsx".Split({"2021"},StringSplitOptions.None)(0).trim("_"c)

to make generalized

"Suspend_de_20210613_175410.xlsx".Split({now.year.tostring},StringSplitOptions.None)(0).trim("_"c)
2 Likes