String Extraction

uiautomation

#1

Hi,
How to extract the date from extract12638_interact_04_07_2018.xlsm, please note that “extract12638_interact_” is dynamic which kept on changing


#2

Try this one

image


#3

is there a way where we can get 04_07_2018 (10 chars) before .xlsm?


#4

Because there is a possibility that extract12638_interact can increase to abc_xyz_extract12638_interact


#5

Hi @anjalimishra,

Use Regex

Pattern \d{2}_\d{2}_\d{4}

DateValue:
Use Matches activity
Properties
Input : YourString
Pattern : \d{2}_\d{2}_\d{4}
Result: iEnumResult ->IEnumberable
after that use assign activity to get the data
strDate=iEnumResult (0).ToString()

Regards,
Arivu


#6

Please find the attachment
Main.xaml (5.7 KB)