June 2, 200520 yr 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.
June 3, 200520 yr 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
June 3, 200520 yr Author 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
June 3, 200520 yr Author YES you did!! You two are great, thanks so much. This finishes my database woohoo!
Create an account or sign in to comment