Hi,
Just wanting to hear peoples experiences in dealing with commas in fields (mainly address fields) which, if left alone, may shift columns when exporting in csv format.
Do you leave them in the dB and deal with the problem when exporting or maybe replace each occurence in the dB with a space, or delete them. Same goes for apostrophes (') screwing up dynamic queries.
Any comments?