[mapserver-users] Change case of labels using a mapfile

[Lime, Steve D (DNR)]

Short of modifying the data you can't do it via configuration. This would
be a nice addition to parser support though and I could sneak it into 6.2
I think if someone would be so kind as to create a ticket...

Steve

-----Original Message-----
From: mapserver-users-bounces at lists.osgeo.org [mailto:mapserver-users-bounces at lists.osgeo.org] On Behalf Of Stephen Woodbridge
Sent: Friday, March 16, 2012 11:19 PM
To: mapserver-users at lists.osgeo.org
Subject: Re: [mapserver-users] Change case of labels using a mapfile

On 3/16/2012 11:40 PM, Peter Girgis wrote:
> Dear users
> Our data contains fields that we would like to use as labels and the
> field data is all in upper case.
>
> I have been trying to find a way to use the mapfile to make the label
> appear in lower case.
>
> Does anyone have any thoughts?

You might be able to do this with ogr2ogr. You can use a sql statement 
to modify the the column you want. Here are some links that might help:

http://www.gdal.org/ogr2ogr.html
http://www.gdal.org/ogr/ogr_sql.html
http://www.bostongis.com/PrinterFriendly.aspx?content_name=ogr_cheatsheet

You might try initcap(string), lower(string)

I have not tried this, but it is probably worth a try. Other options 
would be loading the file into postgis or spatialite and modifying it 
there then dumping it back out or writing a C, Perl, or Python script to 
modify the file.

-Steve W
_______________________________________________
mapserver-users mailing list
mapserver-users at lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users