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

[Stephen Woodbridge]

http://trac.osgeo.org/mapserver/ticket/4255

On 3/19/2012 6:21 PM, Lime, Steve D (DNR) wrote:
> 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
>
>