Hi. I have 20000 pdf’s that i need to extract data from. Unfortunately the ui elements are all over the place so i can just scrape data, which is very annoying. I have “Read PDF Text” then removed all unwanted characters (as there was arabic in the PDF’s) I now how a String with full text from th…

:smile: Looks that you have gone far since yesterday, so you will be more than fine!

@MarkC1500 , Please check the workflow below - I have applied both regex patterns for you, and both names and addresses are later entered to an excel spreadsheet in relevant columns B and C. Does this solve your problem? :slight_smile: string in between.xaml (16.7 KB)

Thank you @PAD . I haven’t used regex yet. Need to learn these things. Could your share the code for me that I would use. I need this to get the text surrounding @ after the 3rd occurrence of “email” ?!? I also think I will need a Boolean for “does @ occur within the 30 characters after 3rd occurren…

Sorry. Didn’t see your third post.

Here is where you would apply this regex: [email%20address%20regex] Let me know if this worked for you :slight_smile:

@PAD Thank you. I am going to leave the write each section to excel for now as files will be deleted after extracting names (files with no data), so when I get to the email section the file references will be different. Not important that one for now anyway. The regex code will work just fine, onc…

Please see these threads - when you arrange your items in a list of addresses, then you can use an invoked method to remove the unneeded elements: [image] How can i delete a element from a List of String in UiPath Help How can I delete an item(by index) from a List? I know…

A lot of indexing being used. My indexes will be different per pdf file. I need to somehow just find the 3rd occurrence of “email” then split the string.

You could also append your string which contains the whole text by re-assigning it as e.g. newString = System.Text.RegularExpressions.Regex.Replace(value, “^.?\S+@\S+.?\S+@\S+.?\S+@\S+.?”, “”) - where “value” is that old full string variable (just like I named it in my workflow). This should cut off…

Hi @PAD Sorry if I’ve made it confusing. It’s not actually the third email address I’m after out of my data. It’s the email address after the 3rd occurrence of the word “email”. I have done this by splitting the string with “email” and then utilising index 2, then applying your regex. Works like a …

Hi @PAD Moving onto the next issue. I am extracting phone number. Similar to extracting the email in first step. But second step I don’t have an “@” to play with. I have split the string after third occurrence of the word “Mobile”. So my outputs either start with phone number “05650456654 random t…

Extracting text between two Str Delimiters

Help

PAD February 5, 2019, 5:03pm 31

Please see these threads - when you arrange your items in a list of addresses, then you can use an invoked method to remove the unneeded elements:

Topic		Replies	Views
Substring after line containing specific text Help	32	13200	May 8, 2020
To extract values between two strings of text Help studio	21	18479	December 7, 2018
Extract String from Text file Help	24	13572	January 20, 2020
How to manipulate a part of string: Split, Trim, Substring, Replace, Remove, Left, Right Tutorials activities , faq	115	329583	September 9, 2025
Extract specific text from Text file Mobile Automation question , mobile_automation	2	105	September 19, 2024

Extracting text between two Str Delimiters

Related topics