How to split and get the date

Help Studio
, ,
1

var = “C:\Users\deviy\Desktop\use case\February\11 07\newyear sheet k9 final - blank (as of 13.04.2020).xlmx”
var1 = “C:\Users\deviy\Desktop\use case\February\11 07\newyear sheet k9 final - blank (as of 13.04.2020)(1).xlmx”

results = 13.04.2020
how can i get only the date

2

@Tharusha_Fernando - you can try regex pattern as shown below…

image
image564×572 26.6 KB

image

StrOuput = Regex.Matches(“C:\Users\deviy\Desktop\use case\February\11 07\newyear sheet k9 final - blank (as of 13.04.2020).xlmx”,“\d{2}.\d{2}.\d{4}”)

StrOuput Variable type is MatchCollection

Output:
image

1 Like
3

thank you @prasath17 it worked

1 Like
4

@Tharusha_Fernando - Glad to know. Please mark my post as solution, that will close this thread.

5

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