The above video deals with Data Manipulation and at this part of the video, (9min and 53s) shows how to use status.Split to find and return a word in a string that comes between “Record " and " has” as the delimiters.
I am looking for how to find and return a word that comes after a word, but the word that will follow my target data will vary each time so I can’t use 2 delimiters.
In the string: “Scheduled : 07.15.17” I’m looking to extract the date as I know it will always follow the “Scheduled :” but again, the word that would follow it will vary every time.
status.Split will split the string and I can return a word if I know what it is between, but how do I return a word if I only know what precedes it?
In standard English I’m trying to tell the computer, "Find the phrase “Scheduled :” and return the 8 characters that follow. (the place on the page where Scheduled will appear will vary as well so I can’t use Substring to find the information)
Where would I put this code in UIPath? I mean where would this code go, into what container? An “If” container? An assign Container? Sorry if that seems a silly question.
Second the code you gave seems to work great if there is nothing after the date I am looking to capture but it is capturing everything after the “Scheduled :”.
I can see that using regex is exactly what I need to get a firm hold of and that the Regex you showed me is returning only what I’m looking for even with text in front of it. Thank you, now I’m trying to get it entered into the “Matches” box and I’m getting the following error,
You can see that the input is what I’m having it read,
The output is a variable that is variable type: |Enumerable when I create the variable within the output field using ctrl K so it should be the right type.
That worked!!! Thanks so much, I’m just learning that Regex is something I can use to get a lot of mileage out of UIPath, so I really appreciate your help! I’ve got it up and running how I’d like. Thanks so much!!!