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)
Thanks so much in advance for your help!!