Parsing text

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

cherman - 15 Nov 2006 17:53 GMT

I'm trying to parse the following text to pull out the course info, which is
to the right of "below:" within the text. We can say the text value is
assigned to a variable called CourseInfo. There is always at least 1 space
between "below:" and the begninning of the course info, so I might need to
use Trim to drop the spaces.

"Please rate yourself based on the class listed below: PLN0010: Sales
Orders"

Much thanks,
Clint

Reply to this Message

fredg - 15 Nov 2006 18:23 GMT

> I'm trying to parse the following text to pull out the course info, which is
> to the right of "below:" within the text. We can say the text value is
[quoted text clipped - 7 lines]
> Much thanks,
> Clint

So if I understand you correctly, from the sentence below, you wish to
return
"PLN0010: Sales Orders"

SomeVariable = Trim(Mid(SomeText,InStr(SomeText,"below:")+7))

Signature

Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail

Reply to this Message

cherman - 15 Nov 2006 18:43 GMT

Perfect! Thanks.

> > I'm trying to parse the following text to pull out the course info, which is
> > to the right of "below:" within the text. We can say the text value is
[quoted text clipped - 13 lines]
>
> SomeVariable = Trim(Mid(SomeText,InStr(SomeText,"below:")+7))

Reply to this Message