[gdal-dev] How to concatenate with newlines by using OGR SQL?

Rahkonen Jukka Jukka.Rahkonen at mmmtike.fi
Tue Jul 31 00:36:22 PDT 2012


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 ☺


Chaitanya kumar wrote:


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.rahkonen at mmmtike.fi<mailto:jukka.rahkonen at mmmtike.fi>> wrote:

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 at lists.osgeo.org<mailto:gdal-dev at lists.osgeo.org>

Best regards,
Chaitanya kumar CH.

17.2416N 80.1426E
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/gdal-dev/attachments/20120731/7fed9aba/attachment.html>

More information about the gdal-dev mailing list