[mapserver-users] Using a attribute substring for labeling

[Jeff McKenna]

On 2016-02-29 9:02 AM, lars lingner wrote:
> Hello,
>
> while using a ShapeFile, created with gdaltindex, as data source for a
> layer I'd like to use a substring of the location attribute for labeling.
>
> I could (and probably will) preprocess the ShapeFile to add the label
> text as additional attribute. But I wanted to try this step within
> MapServer first.
>
> My current example contains a path and file name. The file name has a 4
> digit number in it I would like to use as label. To make it more
> complicated, the substring has various positions within the whole string.
> Maybe there is a way with tostring() which accepts sprintf formatting,
> but I couldn't figure out the correct syntax yet.
>
> With a database layer of course I would be able to use SQL to extract a
> substring and pass it as additional attribute, but not with a ShapeFile.
>
> Is there a way to extract a substring from an attribute value and use it
> as label? It would be nice to have a function available to use in
> EXPRESSION or TEXT parameter.
>
> Thank you in advance for any hints.
>
> Lars

Hi Lars,

Did you try piping this shapefile layer through an OGR connection 
(CONNECTIONTYPE OGR) and then passing your SQL in the data statement? 
I'd first start at the ogrinfo commandline, and test your SQL there with 
the -sql switch, and then move to the mapfile next.

Otherwise I'd probably need a sample of your data to dive into this.

-jeff






-- 
Jeff McKenna
MapServer Consulting and Training Services
http://www.gatewaygeomatics.com/