distal-attribute
distal-attribute
distal-attribute
distal-attribute

export grid rows to clipboard bug

BubikolRamios posted 2 years ago in General
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 posted 2 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 2 years ago
cf RFC 4180, p. (6.) and especially (7.).
jfalch posted 2 years ago
erm, 2.6 and 2.7, that is.

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