Searching for double quote in a string

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I've got a string that contains a double quote ("). It's a thickness
measurement in inches. I would like to extract everything in that string to
the left of - and including - the double quote.

I'm using the Left("String", characters) function to do this.
Unfortunately, the position of the double quote in the string changes so I
cannot hard code the number of characters in the Left function. I'm trying
to use the InStr function to programmically determine the double quote's
position and thereby determine the number of characters to return in the Left
function.

How do you tell the InStr function to search for a double quote since the
search argument is surrounded by a pair of double quotes.

Thanks

Jeff
 
from the immediate window to demonstrate:

sStr = "abcd""""efgh"
? sStr
abcd""efgh
? instr(sStr,"""")
5
? Left(sStr,Instr(sStr,""""))
abcd"
 
How do you tell the InStr function to search for a double quote since the
search argument is surrounded by a pair of double quotes.
Click to expand...

str1 = "aa" & Chr(34) & "bb"
iPos = InStr(str1, """")

This sets iPos to 3, which is what you want.

HTH,
Merjet
 
Back
Top