The inverse of the Mid Function

[CrazyFileMaker]

Hello.
My question is about the Mid function.
I know the below code removes a specified portion of a string from a longer string.

Please Login or Register  to view this content.

The above assigns the variable sContentsRemoved with the value of the removed contents: "the string"

However, I want to do the opposite of the above.
I want to assign a variable with the contents remaining in the string, not the contents taken out of the string.
So, in the example above, I'd want to assign a variable sContentsRemaining with the value "This is "

In my actual program, I don't know the contents that will remain in the string, which is why I can't just pull them out specifically.
I only know the contents in the string I don't want. Thus, I hope to use my knowledge of the contents I do not want, in order to separate them from the contents that I DO want.

Any help would be greatly appreciated! Thanks so much!!

[shg]

Please Login or Register  to view this content.

[CrazyFileMaker]

Thanks, shg - just what I needed to know!

Cheers!!