Hi, Sorry, I forgot to tell that I am on Windows. “$’\n’” looks so gurutic that I feel jealous. I hope I will never need to teach anybody to use it at work, though ☺
-Jukka- Chaitanya kumar wrote: Jukka, You can try to pass the newline character directly from the command line. With bash, you can use $'\n'. In your case it will be like this: ogr2ogr -f gpx test.gpx finland.osm.pbf -sql "select name,CONCAT(addr_street,"$'\n'",addr_housenumber) as 'desc' from points where amenity='toilets'" On Tue, Jul 31, 2012 at 12:09 PM, Jukka Rahkonen <jukka.rahko...@mmmtike.fi<mailto:jukka.rahko...@mmmtike.fi>> wrote: 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<mailto:gdal-dev@lists.osgeo.org> http://lists.osgeo.org/mailman/listinfo/gdal-dev -- Best regards, Chaitanya kumar CH. +91-9494447584 17.2416N 80.1426E
_______________________________________________ gdal-dev mailing list gdal-dev@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/gdal-dev
