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.
@hthompson,
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
Hello
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