Quotes in an export
Posted: Tue Nov 10, 2009 12:22 pm
[updated:LAST EDITED ON Nov-10-09 AT 12:31 PM (EST)]I have a report that has a number of character fields followed by a numberic field and then another character field. When I export the data the first character fields have quotes and the numberic field has no quotes, which is desired. The last character field has no quotes. I have surrounded the field with CHR(34) which results in ""FIELD"". Any ideas how to get the last character field quoted while leaving the numeric field unquoted? I would use the quote option on the export but this quotes the numeric fields as well. Thank you!____Example data:____CharField1, CharField2, CharField3, CharField4, NumField, CharField5____Result of export:____"CharField1","CharField2","CharField3","CharField4",NumField,CharField5____Desired export:__"CharField1","CharField2","CharField3","CharField4",NumField,"CharField5"