Hi, I was playing with the new OSM driver and tried to transfer some POI features into my GPS. It goes well by using GPX format in between. However, I have a little problem. My GPS supports multiline descriptions but I do not know how to insert newlines into the output of ogr2ogr. The following command adds a space character between addr_street and addr_housenumber, but is is somehow possible to insert newline instead?
ogr2ogr -f gpx test.gpx finland.osm.pbf -sql "select name,CONCAT(addr_street,' ',addr_housenumber) as 'desc' from points where amenity='toilets'" I made two blind trials as CONCAT(addr_street,\n,addr_housenumber) which gives parsing error and CONCAT(addr_street,'\n',addr_housenumber) which adds string \n literally. -Jukka Rahkonen- _______________________________________________ gdal-dev mailing list gdal-dev@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/gdal-dev