I have a unique business case to develop logic which will allow for Blue Prism to select one specific option from a list of pull-down menu options in a web-based application, but those pull-down menu options will be DYNAMIC, thus requiring Blue Prism to evaluate current options and "write" or select the appropriate one. Conceptually I know how to achieve this, but am having trouble deriving the correct stages and syntax to achieve the desired goal, and am hoping a more experienced user or consultant can provide assistance.
A read stage will read the applicable Pull-Down Menu options and bring them into a temporary collection with one single field (Item Text) and as many rows as there are available options. From there, I need to devise a way to have Blue Prism read EACH line of that collection and determine IF IT CONTAINS a specific set of text characters (for each case, a specific 8-character position number (i.e., 01837452)).
The text values read from the pull-down menu will be DYNAMIC, in that they will always have a different number of total characters, and the exact location of the 8-character position number (text) within the matched option's text line will always by DYNAMIC, BUT that 8-character position number text value WILL ALWAYS EXIST in only ONE of those lines.
The logical goal I need to achieve is relatively simple - read each line of the available pull down menu option collection, and "find" the line which contains an exact text match for the current 8-character position number, feeding that line to a write stage so it will write/select the appropriate pull-down menu option and proceed with the process.
Is there an expression or syntax that can help me isolate an 8-character text value (numbers) from any given string of text, especially if that 8-character text value is already stored in a Data Item for reference?? If so, that would be all I need as I understand logically how to use loops to evaluate and cast data back and forth - just don't know how to use expressions to evaluate/isolate that 8-character text (number) value from a string of dynamic text characters.
Does anyone have a precedent for resolving an issue like this and suggestions for a way to address and resolve this unique scenario? Thank you all for your time and consideration!