topic Re: ArcPad Label Expression: split function? in ArcPad Questions

ArcPad Label Expression: split function?

MarcEylar — Tue, 15 Mar 2011 20:43:39 GMT

I am trying to figure out how to write a label expression that will split an address for me.

For example, the address pulled from the "SITUS" field is 209\Benton Street Ellensburg, and I would like it labeled as just 209.

Simple code I am sure, but need some assistance. Any help is greatly appreciated.

Thanks,

Marc

Re: ArcPad Label Expression: split function?

riyhen — Wed, 16 Mar 2011 05:21:53 GMT

Hi,

you would use this expression :
left([situs],instr([situs],"\")-1)

go to the layer properties -> labels tab , and in the "Labels using the Expression" type the previous expression in it ,,

hope that does it

the instr function gives the position of a text string within another , and the left function extracts a string from another one

riyhen

Re: ArcPad Label Expression: split function?

MarcEylar — Tue, 22 Mar 2011 14:47:25 GMT

Thanks riyhen! Simple and works great.

Marc