Mid, Left, Right

[Guest]

Hi there.

I have a string, for example:
"Mix 99.9Teddy GeigerFor You IOn Air NowMaura Grierson 9:00 am - 12:00 pmOn "

I need to be able to get just:
"Teddy GeigerFor You I"

The problem is that this string changes every 3-5 minutes, for instance, the
next string is:
"Mix 99.9U2Sometimes U Can't Make It On Your OwOn Air NowMaura Grierson 9:00 "

and I need....
"U2Sometimes U Can't Make It On Your Ow"

I was thinking that if there was a way to make a pointer in a string, in
this case "On Air"

I could then remove, using newstring = mid(string,1,8) *would remove Mix 99.9
and then somehow, find the "On Air" string - count the characters from the
start to the pointer.

Or maybe there is an easier way?

Thanks.
-State

 

[John Nurick]

Instr() will give you what you need.

 

[Guest]

Perfect.

Thanks.

Instr() will give you what you need.