Search for invalid question marks in text 1

[mkjjj]

We copy and paste text from Word into a database. What happens when cutting and pasting from Word, it replaces an apostrophe with a question mark so for example "you're" becomes "you?re" in the database. Is there a way to search for all question marks that are not correct in Crystal since sometimes a question mark is correct when a question is being asked? I have Crystal 9.

Thank you

 

[pmax9999]

Searching for a "?" is easy enough, but what would determine if it is in the correct position?

The following Code would return TRUE if a "?" was found:

If      Instr({Table.YourField}, "?") > 0 
Then    True
Else    False

Assuming that the only way a "?" could be in the correct position was if it was at the end of a sentence (ie, followed by a space), you could try:

If      Instr({Table.YourField}, "? ") > 0 
Then    True
Else    False

It would not exclude any where the apostrophe was correctly at the end of a word, and therefore followed by a space though.

Hope this helps
Cheers
Pete

 

[mkjjj]

Thanks Pete. I'm going to try it.