out:csv doesn't escape delimiter characters in values

ttomasz commented 3 years ago

Option out:csv doesn't properly escape delimiter characters.

If an object contains e.g. tab character in the name and the delimiter is tab you won't get quotes around the field value as expected.

Example query:

[out:csv(::id, name, leisure)][timeout:900];
(
  way(831409355);
);
out body;

@id name    leisure
831409355   Santuario de la Naturaleza  Isla Kaikué nature_reserve

2 tabs in header, 3 in row response should be:

@id name    leisure
831409355   "Santuario de la Naturaleza     Isla Kaikué"    nature_reserve

mmd-osm commented 3 years ago

Duplicate of #175

ronmacro commented 2 years ago

Shouldn't the escape character itself be handled here, e.g. if separator is \t use quotes for string to prevent broken csv files?

drolbr / Overpass-API