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
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
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,
Jukka,
This should work:
ogr2ogr -f gpx test.gpx finland.osm.pbf -sql ^
*More? *select name,CONCAT(addr_street,'^
*More? *
*More? *',addr_housenumber) as 'desc' from points where amenity='toilets'
Note that the More? part is given by DOS. By giving ^ at the end of line
you are saying that
Hi,
Great, it does work. I was reading an entertaining page
http://stackoverflow.com/questions/245395/hidden-features-of-windows-batch-files
and because of http://stackoverflow.com/a/254169 I was just experimenting with ^
I wonder if OGR SQL could have one more special field for newline for