Find Quotes

[mattc66 via AccessMonster.com]

Hi All,

I have data that comes from an external source. Every now and then they
forget and have quotes for inches in the description.

I want to setup a query that checks for " quotes.

I can I do this?

 

[Guest]

SELECT InStr([TABLE_NAME],'"') AS Expr2,
Replace([TABLE_NAME],'"',"") AS Expr1
FROM A
WHERE InStr([TABLE_NAME],'"') >0;

For some reason I always have trouble looking for double-quotes using
something like this in the criteria: Like "*'"'*"

However doing an InStr seems to work. Notice that it's a single-quote
double-quote single-quote combination.

Also the second field returned shows an example of the Replace function. You
could use something like it to fix the data in an update query. For example:

Update To: Replace([TABLE_NAME],'"',"Inches")

 

[fredg]

Hi All,

I have data that comes from an external source. Every now and then they
forget and have quotes for inches in the description.

I want to setup a query that checks for " quotes.

I can I do this?

WHERE YourTable.FieldName Like '*"*'