Locate the " " " (inch) in a string

[Guest]

I cannot seem to find a way to locate a field with a " in it. I guess you
call those DOUBLE QUOTES? It don't matter to me if we use the InStr or the
Like way..I just need to hone in on when my idiot users put them in the part
description.

 

[Guest]

If you want to use Find and Replace to change all " to inches, it isn't too
hard to do.

To find " using a query is more work. I couldn't figure it out using Like
but got InStr to do the job.

SELECT InStr(1,[TextField],'"') AS Expr1, Inches.TextField
FROM Inches
WHERE (((InStr(1,[TextField],'"'))>0));

 

[Guest]

Been there, Done that...got "The Expression you entered has an invalid
String. A string can be up to 2048 charaters long, including opening and
closing quotation marks.

If you want to use Find and Replace to change all " to inches, it isn't too
hard to do.

To find " using a query is more work. I couldn't figure it out using Like
but got InStr to do the job.

SELECT InStr(1,[TextField],'"') AS Expr1, Inches.TextField
FROM Inches
WHERE (((InStr(1,[TextField],'"'))>0));
--
Jerry Whittle
Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.

I cannot seem to find a way to locate a field with a " in it. I guess you
call those DOUBLE QUOTES? It don't matter to me if we use the InStr or the
Like way..I just need to hone in on when my idiot users put them in the part
description.

 

[OfficeDev18 via AccessMonster.com]

With Instr? No problem.

InStr(StringName, Chr(34))

Sam

If you want to use Find and Replace to change all " to inches, it isn't too
hard to do.

To find " using a query is more work. I couldn't figure it out using Like
but got InStr to do the job.

SELECT InStr(1,[TextField],'"') AS Expr1, Inches.TextField
FROM Inches
WHERE (((InStr(1,[TextField],'"'))>0));

I cannot seem to find a way to locate a field with a " in it. I guess you
call those DOUBLE QUOTES? It don't matter to me if we use the InStr or the
Like way..I just need to hone in on when my idiot users put them in the part
description.

 

[fredg]

I cannot seem to find a way to locate a field with a " in it. I guess you
call those DOUBLE QUOTES? It don't matter to me if we use the InStr or the
Like way..I just need to hone in on when my idiot users put them in the part
description.

Like '*"*'

 

[John Spencer]

LIKE '*"*'
or
LIKE "*""*"

When you need to use a quote or an apostrophe in a string, you double them
up. Or use one type on the outside and the other type on the inside.

 

[Guest]

I cannot seem to find a way to locate a field with a " in it. I guess you
call those DOUBLE QUOTES? It don't matter to me if we use the InStr or the
Like way..I just need to hone in on when my idiot users put them in the part
description.

 

[Tom Lake]

Instr(textfield, """")

also works fine. Make sure there are TWO double quotes between the outer ones.

Tom Lake