jkbaker
4th May 2005, 15:29
Is there a way to change the default text qualifier in the output of a qptool query? We currently use qptool for various ad-hoc queries that we end up putting into spread sheets. The problem we run into is that sometimes a description field will contain apostrophes as part of its text. Since the text qualifier for a string field in qptool output is an apostrophe, Excel gets confused when it encounters fields with embedded apostrophes.

I realize there are other options for getting the data, but we would like to qptool if at all possible. Does anybody have any suggestions on how to overcome the issue of embedded apostrophes in a text field when using qptool?