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 makin
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 t
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, y
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'"
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