Extract substring from directory path between symbols

[ciaramkm (Murph)]

Hi,

I am attempting to try and extract two separate strings from a file name in a directory path - I am able to extract the file name from the path but I want to be able to extract two separate substrings that is beween the last “/” and first underscore symbol _, and the second substring is between the first underscore symbol _ and second _

An example path would be: “C:\Users\Robot\Documents\UiPath\ExtractedFolder\123456_78912345_Test_File_2020.pdf”

So the first substring would be - 123456
Second substring - 78912345

I managed to get the entire file name alone but need to extract two substrings from the file name.
Closest I was able to get was: file.ToString.Substring(file.ToString.LastIndexOf(“")+”_".Length).Split(Environment.NewLine.ToCharArray)(0)

Any suggestions would be great please.

[Steven_McKeering]

Hi

I have two options/ potential solutions:

I have used a combination of string Split and Regex Replace activity. (Still working on my string manipulation skills).

I have found this String Manipulation post to be very helpful

How to manipulate a part of string: Split, Trim, Substring, Replace, Remove, Left, Right

Hi, if you are a beginner in the world of automation and would like to know how you can manipulate text based on the solutions available in the VB.NET code and using REGEX (regular expressions) then you are in the right place. In the topic below, you will learn how to easily extract data from any part of the search text using various methods. The topic includes solution examples with descriptions and graphics to better understand the topic for functions such as: Split Substring Left Right R…

OPTION 2: Use Regex Groups
.*(?<=\)([^]+)([^_]+)
Check out this Regex Pattern preview

If you want to learn Regex - check out my Regex Megapost

Regex help tutorial MEGAPOST – Making your first Regex post, Reusable Regex Patterns, Regex Troubleshooting, Sample Workflow and more

THE PURPOSE OF THIS POST IS TO HELP NEW REGEX USERS If you need help with Regex be sure to provide in your post, a Sample, the Output and the Pattern (as much as you know). CONTENTS: Section : I need a Regex Pattern ASAP! - My first Regex Post Section : Regex samples that you can use! Section : I need help applying regex in UiPath Section : Regex Matches and Groups Section : Le…

[ptrobot]

@ciaramkm Here’s another possible solution you can try:

Filename = Path.GetFileName("C:\Users\Robot\Documents\UiPath\ExtractedFolder\123456_78912345_Test_File_2020.pdf")
PartsArray = Filename.Split("_"c)
Part1 = PartsArray(0)
Part2 = PartsArray(1)

Filename, Part1 and Part2 are strings.
PartsArray is an array of strings.