find "

[osiris612mb]

I am trying to do a find/replace

i need to find 1 quotation and replace it with a single quote (apostrophe).

This is for exporting purposes.

so find " and replace it with '

I have tried doing a find for " " " and even " " " without spaces. Nothing seems to work.

Does anyone have any idea of how to do this.

[Lee Smith]

Try this Substitute(text; """; "'")

It appears that you have extra spaces before each. that is okay for the replace ', but it may be the problem with the quote.

HTH

Lee

[osiris612mb]

Lee,

Well I would think that would work but for some reason it won't. I have a text field that has the "text" in it and a calc field that has the substitute[] in it. The calc field ends up having the exact syntax as the text field.

Could it have anything to do with the Default language for indexing and sorting text?

ps. the spaces were for readability on the forum.

Thanks

[MoonShadow]

Are these smart quotes?

[Lee Smith]

I think you nailed it.

[osiris612mb]

YES you did!!

You two are great, thanks so much.

This finishes my database woohoo!