So I'm working on a solution that requires an ability to read dissected text from a field. The line number is variable, but the text I want always follows a known block of text, such as "Example:". I had figured using the left/right command, but the text needed isn't always the same length or on the same line.
In one text field it could be on the 10th line, another it could be on the 4th etc.
Is it possible to do something like:
Right ( Field ;( something to denote the end of that line ) - ( position of "example:" ) ; -1 )
Thanks in advance