Find and replace ?

[Ken]

I converted a database and it changed all single quotes to question marks. I
need to do a find and replace, but when I put in ? it thanks it's a wild
card. How do I do a find and replace to look for a question mark?

 

[KARL DEWEY]

WHERE InStr([YourField],Chr(63)) >0

 

[Ken]

I have opened the table and need to enter this in the Find and Replace tool,
not a query - Thanks.

WHERE InStr([YourField],Chr(63)) >0
--
KARL DEWEY
Build a little - Test a little

I converted a database and it changed all single quotes to question marks. I
need to do a find and replace, but when I put in ? it thanks it's a wild
card. How do I do a find and replace to look for a question mark?

 

[Douglas J. Steele]

You're far better off using an Update query than Find and Replace.

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)

I have opened the table and need to enter this in the Find and Replace
tool,
not a query - Thanks.

WHERE InStr([YourField],Chr(63)) >0
--
KARL DEWEY
Build a little - Test a little

I converted a database and it changed all single quotes to question
marks. I
need to do a find and replace, but when I put in ? it thanks it's a
wild
card. How do I do a find and replace to look for a question mark?

 

[Ken]

But I need the ability to leave question marks where they are appropriate.

You're far better off using an Update query than Find and Replace.

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)

I have opened the table and need to enter this in the Find and Replace
tool,
not a query - Thanks.

WHERE InStr([YourField],Chr(63)) >0
--
KARL DEWEY
Build a little - Test a little


:

I converted a database and it changed all single quotes to question
marks. I
need to do a find and replace, but when I put in ? it thanks it's a
wild
card. How do I do a find and replace to look for a question mark?

 

[Douglas J. Steele]

And how can you tell whether they're appropriate?

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)

But I need the ability to leave question marks where they are appropriate.

You're far better off using an Update query than Find and Replace.

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)

I have opened the table and need to enter this in the Find and Replace
tool,
not a query - Thanks.

:

WHERE InStr([YourField],Chr(63)) >0
--
KARL DEWEY
Build a little - Test a little


:

I converted a database and it changed all single quotes to question
marks. I
need to do a find and replace, but when I put in ? it thanks it's a
wild
card. How do I do a find and replace to look for a question mark?

 

[KARL DEWEY]

Ken could add a Yes/No field and pull all records with a question mark and
flag those to change. Then include the field with criteria in the update
query.
--
KARL DEWEY
Build a little - Test a little

And how can you tell whether they're appropriate?

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)

But I need the ability to leave question marks where they are appropriate.

You're far better off using an Update query than Find and Replace.

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)


I have opened the table and need to enter this in the Find and Replace
tool,
not a query - Thanks.

:

WHERE InStr([YourField],Chr(63)) >0
--
KARL DEWEY
Build a little - Test a little


:

I converted a database and it changed all single quotes to question
marks. I
need to do a find and replace, but when I put in ? it thanks it's a
wild
card. How do I do a find and replace to look for a question mark?

 

[Ken]

There is only 1 field i am working with There are about 300 records that are
editorials written by the author. Anywhere there were single quotes it
converted to question marks like the following:

'this is the content' was change to
?this is the contet?

or

that's was changed to that?s

I figured i could do a find and replace on the field, look for question
marks and then replace them with a ' where appropriate and leave the ? in
place where they were used correctly. I can't just replace all question marks.

The problem is when i look for ? it see's it as a wild card and stops on
every charachter when I press find next. I just really need a way to tell
find and replace to look for a ?.

Ken could add a Yes/No field and pull all records with a question mark and
flag those to change. Then include the field with criteria in the update
query.
--
KARL DEWEY
Build a little - Test a little

And how can you tell whether they're appropriate?

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)

But I need the ability to leave question marks where they are appropriate.

:

You're far better off using an Update query than Find and Replace.

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)


I have opened the table and need to enter this in the Find and Replace
tool,
not a query - Thanks.

:

WHERE InStr([YourField],Chr(63)) >0
--
KARL DEWEY
Build a little - Test a little


:

I converted a database and it changed all single quotes to question
marks. I
need to do a find and replace, but when I put in ? it thanks it's a
wild
card. How do I do a find and replace to look for a question mark?

 

[John W. Vinson]

There is only 1 field i am working with There are about 300 records that are
editorials written by the author. Anywhere there were single quotes it
converted to question marks like the following:

'this is the content' was change to
?this is the contet?

I strongly suspect that the original was some non-ASCII "smart quote"
character, not the ' (Chr(38)) singlequote character; and that your current
font doesn't have a representation of that character.

Try finding a record where the ' is the first character, or count characters
to find its position. Use Asc(Left([fieldname], 1) or Asc(Mid([fieldname],
<position>, 1) to ascertain the ASCII equivalent of the odd quote character
(or questionmark, as it's now being displayed).

Then run an Update query updating the field to

Replace([fieldname], Chr(356), ') (assuming that 356 is the ASCII value of
the offending character).

 

[Ken]

Thanks, I'll give that a try.

There is only 1 field i am working with There are about 300 records that are
editorials written by the author. Anywhere there were single quotes it
converted to question marks like the following:

'this is the content' was change to
?this is the contet?

I strongly suspect that the original was some non-ASCII "smart quote"
character, not the ' (Chr(38)) singlequote character; and that your current
font doesn't have a representation of that character.

Try finding a record where the ' is the first character, or count characters
to find its position. Use Asc(Left([fieldname], 1) or Asc(Mid([fieldname],
<position>, 1) to ascertain the ASCII equivalent of the odd quote character
(or questionmark, as it's now being displayed).

Then run an Update query updating the field to

Replace([fieldname], Chr(356), ') (assuming that 356 is the ASCII value of
the offending character).