Help with Get Text

[russ]

Hi, I’m new to UIPath and am trying to use Get Text to pull some info from a website.

The site is Molecular Mass Calculator - Christoph Gohlke and I want to grab the Average mass and Monoisotopic mass values.

I’ve managed to pull the full strings into an Excel spreadsheet (Average mass : 18.01529 and Monoisotopic mass: 18.01056) but I only want to pull the values rather than the words.

Can anyone explain how to do this?

[Gokul001 (Gokul Balaji)]

HI @russ

You can try like this

• After getting the text use that variable in split method or regex to get the value

Regex Method

• For Average mass -
  System.Text.RegularExpressions.Regex.Match(“GetTextVariable”,“(?<=Average\smass\s:\s)(\S+)”)
  regex101: build, test, and debug regex

• For Monoisotopic mass
  System.Text.RegularExpressions.Regex.Match(“GetTextVariable”,“(?<=Monoisotopic\smass:\s)(\S+)”)
  regex101: build, test, and debug regex

Regards
Gokul

[pravin_calvin (pravin kumar)]

Hi @russ

From the full string we can get the ouput by
Split operation

Split(gettextoutvar,“:”)(1)

Will give result only value!

Regards

[Gokul001 (Gokul Balaji)]

Split Method

• For Average Mass
  Use this expression Split("Average mass : 18.01529 ","Average mass : ")(1)

• For Monoisotopic mass
  Use this expression Split("Monoisotopic mass: 18.01056 ","Monoisotopic mass: ")(1)

Regards
Gokul

[russ]

Wow, thanks for the quick responses @Gokul001 and @pravin_calvin!

I’ll test these methods out and report back.

[sahad.kk]

HI,
Could you please split with ( and take the second part.

Eg: thatstring.Split(":“C)(1)
you can also use
thatstring.Split(”:"C).Last
Thanks
Regards
Sahad KK

[Gokul001 (Gokul Balaji)]

Hi @russ

If your query is resolved Kindly close this topic and mark the appropriate post as solved.

It will helps for other to

Forum FAQ - How to mark a post as a solution

Forum FAQ - How to mark a post as a solution This document is part of our beginners guide. This article will teach you how to properly mark a post as a solution. We were closely following our last UiPath Forum feedback round! topic and carefully extracted all the bits of feedback that was provided. As such, we would like to tackle the topic of solutions on our Forum and how to properly use them. When is the topic resolved? The topic can be considered resolved when the topic author has fo…

[russ]

Thank you all for the help! Everyone’s suggested fixes using Split worked. Appreciate your quick and informative answers!