export grid rows to clipboard bug

BubikolRamios posted 5 years ago in General
say I have one column with data I got with concatenation using query:

data like:


export that as excel csv:


should be


right ?

kalvaro posted 5 years ago
No, it shouldn't. Your example is invalid CSV format.

Try saving HeidiSQL's output into a file and loading with it Excel, you'll see it's fine.
jfalch posted 5 years ago
cf RFC 4180, p. (6.) and especially (7.).
jfalch posted 5 years ago
erm, 2.6 and 2.7, that is.

Please login to leave a reply, or register at first.