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"


--
Regards,
Tom Ogilvy

"Jeff Harbin" wrote in message
...
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

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.

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

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

HTH,
Merjet