How to extract several smaller strings from a larger string?

Hi, I am scraping data from a PDF and am trying to assign each instance of a phrase coming up, i.e “Balance Today: $********” and the number that follows it. Unfortunately, the PDF is not consistently structured when read, sometimes phrases are separated by new lines and sometimes they are separated by /r/n/.

How do I extract each instance of that phrase, as well as the number that follows it under these circumstances? Unfortunately the data is sensitive so I cannot share an example.


Can you try with below code?

Dim newString As String = yourString.Replace(vbCr, "").Replace(vbLf, "")

Then you get string which will not have this characters


If you provide the a full sample, highlight all the expected outputs and information on the pattern we could provide the Regex pattern.

Try this link:

Want to learn more about Regex? Check out my Regex Megapost
Regex help tutorial MEGAPOST – Making your first Regex post, Reusable Regex Patterns, Regex Troubleshooting, Sample Workflow and more - News / Tutorials - UiPath Community Forum