topic Re: How do I make a label expression to add text after an attribute field? in AutoCAD Map 3D Forum

How do I make a label expression to add text after an attribute field?

KDAddison — Thu, 26 Jan 2023 20:10:49 GMT

How do I add text to the end of this field? Is this syntax after SQL or just some nameless hybrid?

Re: How do I make a label expression to add text after an attribute field?

Pointdump — Fri, 27 Jan 2023 07:09:04 GMT

Hi Keith,
You'd use CONCAT in Text Function.
Dave

Re: How do I make a label expression to add text after an attribute field?

KDAddison — Fri, 27 Jan 2023 16:27:18 GMT

Thanks!

For posterity here's what I ended up with to get the foot symbol apostrophe added: CONCAT (ToString("Contour") ,'''')

Re: How do I make a label expression to add text after an attribute field?

ChicagoLooper — Fri, 27 Jan 2023 17:01:52 GMT

Hi @KDAddison

Yes, @Pointdump is correct. Use CONCAT. Assuming your label is constant, it doesn't vary from contour-to-contour, then your expression will be like this.

Click Text Function dropdown. (Image-1)

Image-1

Your custom text, when enclosed in single quotes, would take this form. If you want a space to separate the elevation from you custom text, then make your expression look like this. (Image-2)

Image-2

The result will capture the elevation from the shapefile's database and concatenate, or group, it with the custom text that's written in the expression.

Image-3