topic Re: SUBSTRING SQL Expression in Mapping Questions

SUBSTRING SQL Expression

ToddCalico — Wed, 11 Jun 2014 18:24:44 GMT

Not having much experience in SQL or Python, I'm trying to take a shot at labeling a field using a SUBSTRING expression to return only the first 6 characters of a field.

The field is [SITE_ADDRE]

My expression looks like this:
SUBSTRING ([SITE_ADDRE] FROM 1 FOR 6)

I'm getting an error message so I know this is incorrect.

Any suggestions would be much appreciated.

Re: SUBSTRING SQL Expression

IanMurray — Wed, 11 Jun 2014 19:03:57 GMT

I don't think the label expressions take SQL expressions, only Jscript, python, and VBscript

For what you want you can use python and check advanced and put in this.

def FindLabel ( [[SITE_ADDRE] ):   return [SITE_ADDRE][0:6]

The [0:6] is an index which return the the values of the string values in your field, from the first(python is zero indexed so first thing is 0) up to 6, but not including it.

Should return the first 6 characters of your field value.

Re: SUBSTRING SQL Expression

ToddCalico — Wed, 11 Jun 2014 19:08:37 GMT

Great thank you so much!!!

Re: SUBSTRING SQL Expression

IanMurray — Wed, 11 Jun 2014 19:20:20 GMT

Actually, we have had alot of threads about how to format labels with python(and other means). Always be sure to check the forums for similar posts, before starting a new one.