Replace function with wildcard 1

[MikeCDPQ]

To make a long story short, I am looking for a way to use the replace function with a wildcard in the find argument.

something like:

replace("Hello, I hope this works as expected","work*","")

which should theoretically give me: "Hello, I hope this".

Basically, I want to replace "works" and everything that follows with an empty string.

I guess I don't know where to place the wildcard character *
I've tried everything and "works"* gives me following error: Compile error: Expected: expression

This must be so simple but yet .....

Thanks for any suggestion.

Mike

 

[RoyVidar]

I think I'd consider using a different function (or combination of functions).

[tt]if instr(strText,"Works")>0 then
strText=mid$(strText, 1, instr(strText,"Works")-1)
end if[/tt]

Roy-Vidar

 

[MikeCDPQ]

RoyVidar

Your suggestion was brilliant. I needed to adapt it to my script and bam !

Thank you so much !

I really appreciate it.