Hi Carrie, in my opinion the easiest way would be converting the data to spatialite-DB (you get a lot of database-functions in a file based-DB - no client-server-architecture, just a file; at best you use ogr2ogr or QGIS for conversion) and then use replace function in your SQL-QUERY
i.e. to dynamically insert pipe "|" as wrap-character it should look like that (fieldname is "parcel_no"): SELECT *, replace(parcel_no, '.', '.|') AS parcel_no_wrap FROM parcel_table If you have a shapefile and your parcel-no have a strict pattern (ie. 2digits.3digits.4digits) then it should also be possible to use OGR generic "concat" and "substring"-function, which were introduced with GDAL 1.8 (according to documentation at http://www.gdal.org/ogr_sql.html#ogr_sql_flist_ops and http://www.gdal.org/ogr_sql.html#ogr_sql_functions): Example, also with pipe as wrap-character: SELECT *, CONCAT(SUBSTR(parcel_no,1,2),'.|',SUBSTR(parcel_no,4,3),'.|',SUBSTR(parcel_no,8,4)) AS parcel_no_wrap FROM parcel_table In both examples the new virtual field "parcel_no_wrap" could be used for displaying text with wrap character... Sincerely, Benjamin Schepers Von: mapserver-users [mailto:[email protected]] Im Auftrag von Mark Volz Gesendet: Donnerstag, 30. Juni 2016 15:09 An: [email protected] Betreff: Re: [mapserver-users] Map file, Label WRAP Function in mapbook removes character it Carrie, Our trick is to wrap on a character that you would otherwise not normally see in the string. LAYER .... CLASS TEXT ([LastName] * [PIN]) #overrides LABELITEM ..... LABEL WRAP "*" END #Parcel Label END #Parcel Class END #Parcel Layer Sincerely, Mark Volz, GISP -----Original Message----- From: mapserver-users [mailto:[email protected]] On Behalf Of [email protected] Sent: Wednesday, June 29, 2016 11:04 AM To: [email protected] Subject: mapserver-users Digest, Vol 101, Issue 37 Send mapserver-users mailing list submissions to [email protected] To subscribe or unsubscribe via the World Wide Web, visit http://lists.osgeo.org/mailman/listinfo/mapserver-users or, via email, send a message with subject or body 'help' to [email protected] You can reach the person managing the list at [email protected] When replying, please edit your Subject line so it is more specific than "Re: Contents of mapserver-users digest..." Today's Topics: 1. Map file, Label WRAP Function in mapbook removes character it is wrapping on. (Carrie Quast) ---------------------------------------------------------------------- Message: 1 Date: Wed, 29 Jun 2016 15:58:59 +0000 From: Carrie Quast <[email protected]> To: "'[email protected]'" <[email protected]> Subject: [mapserver-users] Map file, Label WRAP Function in mapbook removes character it is wrapping on. Message-ID: <[email protected]> Content-Type: text/plain; charset="utf-8" Hello - I'm working on updating my .MAP Documents to Mapserver 7.0.1. I'm trying to get the labels in my Parcel Layer to wrap on the decimal point (example 002.001.001.01.010) to make for a better a fit. I'm using the WRAP function, which works wonderfully , except it removes the character I am wrapping on. In this case, the point (.) In my parcel numbers. Each of the numbers should have a decimal between it. Any idea of how to get the line to wrap on a character, but also keep it in the displayed label? The MAXLENGTH works well too, but still removes all decimal points. I'm using Mapserver 7.0.1 with GeoMoose 2.9 Thank You - Carrie Quast, Brown County MN GIS Specialist [cid:[email protected]] -------------- next part -------------- An HTML attachment was scrubbed... URL: <http://lists.osgeo.org/pipermail/mapserver-users/attachments/20160629/8bda4b92/attachment.html> -------------- next part -------------- A non-text attachment was scrubbed... Name: image001.png Type: image/png Size: 66665 bytes Desc: image001.png URL: <http://lists.osgeo.org/pipermail/mapserver-users/attachments/20160629/8bda4b92/attachment.png> -------------- next part -------------- A non-text attachment was scrubbed... Name: image002.png Type: image/png Size: 31355 bytes Desc: image002.png URL: <http://lists.osgeo.org/pipermail/mapserver-users/attachments/20160629/8bda4b92/attachment-0001.png> ------------------------------ Subject: Digest Footer _______________________________________________ mapserver-users mailing list [email protected] http://lists.osgeo.org/mailman/listinfo/mapserver-users ------------------------------ End of mapserver-users Digest, Vol 101, Issue 37 ************************************************ _______________________________________________ mapserver-users mailing list [email protected] http://lists.osgeo.org/mailman/listinfo/mapserver-users _______________________________________________ mapserver-users mailing list [email protected] http://lists.osgeo.org/mailman/listinfo/mapserver-users
