export grid rows to clipboard bug

BubikolRamios's profile image BubikolRamios posted 11 years ago in General Permalink
say I have one column with data I got with concatenation using query:

data like:

"11","a","b"
"11","d","f"
etc

export that as excel csv:


"""11"",""a"",""b"""
"""11"",""d"",""f"""

should be

""11","a","b""
""11","d","f""

right ?

kalvaro's profile image kalvaro posted 11 years ago Permalink
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's profile image jfalch posted 11 years ago Permalink
cf RFC 4180, p. (6.) and especially (7.).
jfalch's profile image jfalch posted 11 years ago Permalink
erm, 2.6 and 2.7, that is.

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