Hi - pretty easy one I hope:

I need to find the character " in a text string, but if I use a
function such as InStr, I have to put two of the same character around
the one I'm looking for - ie """ (what are they called, quote marks?).
So is there some way to differentiate between the quote marks required
for the function and the quote mark which I am searching for in the
line of text?

Thanks, Al.

Hi,



Use this function instead of the " : chr(34)




--
JP

http://www.solutionsvba.com


"astro_al" wrote in message
...
Hi - pretty easy one I hope:

I need to find the character " in a text string, but if I use a
function such as InStr, I have to put two of the same character around
the one I'm looking for - ie """ (what are they called, quote marks?).
So is there some way to differentiate between the quote marks required
for the function and the quote mark which I am searching for in the
line of text?

Thanks, Al.

Thanks very much.

Al.