String Extraction

[anjalimishra (Anjali)]

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

[lasithdilshan20 (Lasitha Wijenayake)]

Try this one

[anjalimishra (Anjali)]

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

[anjalimishra (Anjali)]

@anjalimishra

extract12638_interact

Because there is a possibility that extract12638_interact can increase to abc_xyz_extract12638_interact

[arivu96 (Arivazhagan A)]

Hi @anjalimishra,

@anjalimishra

extract12638_interact_04_07_2018.xlsm

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

[lasithdilshan20 (Lasitha Wijenayake)]

Please find the attachment
Main.xaml (5.7 KB)