Searching for " using Instr

[annandap]

Hi,
I am trying to search for " in a string using the Instr function. When using the following syntax it returns an error stating that I neeed to have double quotes..

myCount = instr(mystring, ""&quot

Any help would be greatly appreciated

 

[mrmovie]

i always get really confused with these sorts of "'" and wotnot. i tend to go for Chr(34) instead

try it, it might work

 

[mrmovie]

msgbox """"
'that displays a "
'dont ask me how, perhaps if you put that in your instr

 

[PHV]

And what about this:

myCount = Instr(mystring, Chr(34))

Hope This Help
PH.

 

[dilettante]

Yep,

myCount = InStr(mystring, """&quot

 

[annandap]

Thanks for that, I was doing some investigation into using CHR(34) but couldn't find any reference on the internet for ANSI/ASCII codes.

Anyway I tried both methods """" and CHR(34) and both worked perfectly.

Thanks for all your assistance..

Regards..

Peter

 

[clarkin]

Explanation: to escape a " just double it up as ""
Example:
[tt]myString = "This string has a "" in it"[/tt]
[tt] ^ appears as one " in the string[/tt]
So in your instr():
[tt]InStr(mystring, """")[/tt]
" " : start string & end string quotes
" : escape next quote
" : actual quote char

Posting code? Wrap it with code tags: [ignore]

[/ignore][code]CodeHere

[ignore][/code][/ignore].