Regex Pattern for data extraction from file names

[BTanaji]

I have some filenames in .html format. from those names i want to extract some content. Sample file names are as below:

20210608_081442_20-0000428456.html
20210608_081442_328456.html

I need to extract the content in between last “_” and “.html”. Highlighted in above example. Please suggest the regex pattern for same

[Yoichi]

Hi,

Can you try the following?

System.Text.RegularExpressions.Regex.Match(yourString,"[^_]+(?=\.html)")

or

System.Text.RegularExpressions.Regex.Match(System.IO.Path.GetFileNameWithoutExtension(yourString),"[^_]+$")

Regards,

[prasath17 (Guru)]

@BTanaji - you can use file name without extension and split by _ and take last.

[Gokul001 (Gokul Balaji)]

Hi @BTanaji

Here is Regex Condition

@BTanaji

20210608_081442_ 20-0000428456 .html
20210608_081442_ 328456 .html

regex101: build, test, and debug regex

Activity

-Use Assign activity
Create variable = System.Text.RegularExpressions.Regex.Match(Input_Value,“[^_]+(?=.html)”)

If you face any issues, let me know

Regard,
Gokul