topic Re: How to handle spaces and special characters in arcpy.Select_analysis? in Python Questions

How to handle spaces and special characters in arcpy.Select_analysis?

ChrisBrannin — Fri, 25 Jul 2014 18:07:15 GMT

Hello

How do I handle ' in an attribute table using python?

Example

var = ["'Name"]

any help is greatly appreciated!

Cheers

Chris

Re: How to handle spaces and special characters in arcpy.Select_analysis?

IanMurray — Fri, 25 Jul 2014 18:19:17 GMT

I'd just use a backslash as an escape character, that way it doesn't try doesn't crash since there isn't a second single quote to end the string.

var = ["\'Name"]

Generally it not advisable to have special characters in field names, or to have them start with numbers.

Re: How to handle spaces and special characters in arcpy.Select_analysis?

ChrisBrannin — Mon, 28 Jul 2014 12:55:07 GMT

Thanks for the idea!

Working code below:

var = ["'\'Name"]

Re: How to handle spaces and special characters in arcpy.Select_analysis?

KimOllivier — Fri, 22 Aug 2014 13:55:38 GMT

I avoid escape characters by using triple quotes. It is so much easier and more legible.
Except when it is the first character when it is a bit hard to see.