How to get particular parts from string

[Muhammad_Anas_Baloch]

Hey Everyone, the problem I am facing today is that I want to extract some data from a website.

I am using get text activity, but the problem is it is selecting the whole string but I want to extract some particular parts from the string.

Would you please help me out with this problem. I am attaching the screenshot for more clarity of my problem.

I want to extract “55283” and “Nierstein” but it is extracting “55283 Mainz-Bingen (Kreis) - Nierstein”

[Harshith_Adyanthaya]

Hi @Muhammad_Anas_Baloch

Number = Split(msg," “)(0)
Name = Split(msg,” “)(Split(msg,” ").count)

Hope this helps.

[supermanPunch (Arpan)]

@Muhammad_Anas_Baloch

55283 Mainz-Bingen (Kreis) - Nierstein

Hi @Muhammad_Anas_Baloch ,

From the Extracted Output, we can manipulate to get the required data :

Split(extractedValue).First                                   //First Number Output

Split(extractedValue,"-").Last                          //Last value

The above is assumed that all the data format will be the same, if the separators are only space and not -, for the second expression just remove the delimiter part.

Let us know what is the actual pattern and if the expression works for all the data that you have.

[Gokul001 (Gokul Balaji)]

Hi @Muhammad_Anas_Baloch

How about the Regular expression?

System.Text.RegularExpressions.Regex.Match(YourString,"^\d+").Tostring

System.Text.RegularExpressions.Regex.Match(YourString,"(?<=-\s)\S.*$").Tostring

Regards
Gokul

[wusiyangjia (Siyang Wu)]

Hi @Muhammad_Anas_Baloch

You can easily use Matches activity to compose a regular expression and use it extract what you want.

[Muhammad_Anas_Baloch]

Giving an error

[Muhammad_Anas_Baloch]

Giving an error @supermanPunch

[Muhammad_Anas_Baloch]

This Solution worked for me but in VB.net not in C#

[Muhammad_Anas_Baloch]

This solution worked for me in C#.

[anastasiia.petrenko88 (Anastasiia Petrenko)]

Thanks for the info, i had same problem so I’ll try. Thank you so much!