Extract Data out of a string

[marco.roensch]

Hello guys,
I am completely new in UI Path programming. For my automation I’d like to extract some figueres.
For example the string (folder name) is called “ABC_A.00135.A20_TestAutomation” and I’d like to extract,
and copy just the “A.00135.A20” part.

Is there a way to solve this?

Thanks already!

[ppr (Peter Preuss)]

@marco.roensch
Welcome to the forum

regex can help:

[CheatSheet] - System.Text.RegularExpressions | RegEx - News / Tutorials - UiPath Community Forum

[vishal.kp (vishal)]

Hi @marco.roensch ,

Try this:

system.Text.RegularExpressions.Regex.Match(InputString,"(?<=_).*(?=_)").Value

Regards,

[Gokul001 (Gokul Balaji)]

Hi @marco.roensch

Welcome to UiPath community !

How about this Regular expression?

System.Text.RegularExpressions.Regex.Match(YourString,"(?<=_)\S+(?=_)").Tostring

Regards
Gokul

[marco.roensch]

Thanks for your warm welcome
This helped me a lot. But what have I to type in if there are more underlines in the string?
For example:
ABC_A.00135.A20_TestAutomation_VRX_Battery_OFT
and I’m still looking for “A.00135.A20”

[Gokul001 (Gokul Balaji)]

Hi @marco.roensch

Try with this one

System.Text.RegularExpressions.Regex.Match(YourString,"(?<=_)\S+(?=_TestAutomation)").Tostring

Regards
Gokul

[marco.roensch]

Hi Gokul,
excuse me for not beeing precise enough. This was just one possible case. In my case, there are plenty of folders with different name endings. So it isn’t alsways _TestAutomation. It could be: _VW_123 or _Audi_135 and so on. But I am looking for a general term to seperate the string between the first and the second underline.
Thanks for your time !

[Gokul001 (Gokul Balaji)]

Share the sample input and output

[rmorgan]

Good thread here

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…

[postwick (Paul)]

I highly recommend the free training on the UiPath Academy web site.

[marco.roensch]

Input: Spring_A.00123.A20_VW Project Output: A.00123.A20
Input: Weber_A.00156.A20_Compound2x Output: A.00156.A20
Input: Mueller_A.01556.I20_ZX_59_CS Output: Output: A.01556.I20

[Gokul001 (Gokul Balaji)]

Hi @marco.roensch

How about this expression?

System.Text.RegularExpressions.Regex.Match(YourString,"[A-Z]\.\d+\.[A-Z0-9]+").Tostring

Regards
Gokul

[adiijaiin (Aditya Jain)]

@marco.roensch

Spring_A.00123.A20_VW Project Output: A.00123.A20
Input: Weber_A.00156.A20_Compound2x Output: A.00156.A20
Input: Mueller_A.01556.I20_ZX_59_CS Output: Output: A.01556.I20

If it’s always gonna start with A and follow the same pattern, use this:

System.Text.RegularExpressions.Regex.Match(YourString,“[A-Z].\d{0,}.\w{0,}”).Tostring.Trim(“_”.ToCharArray)