Colleagues and Friends,

 

So that we may all be enlightened, here is the solution that worked. For those of you who contributed answers, thank you one and all! For those of you who asked for further clarification of the problem- I have a series of features with consecutive ID numbers (1,2,3,4,etc…). I needed to convert these values to their corresponding alphabetic value (A, B, C, D, E, ect…). Thank you Jim!

 

 

 

Hi Thad,

 

Try this:

 

chr( !ID!+64)

 

This is a python expression and ID is the numeric field that has a number 1-26 in it.  I add 64 to each ID value in the table to get the ASCI character value for that ID number.  So ID 1 (ASCI value 65) is A, ID 2 (ASCI value 66 ) is B, etc.

 

Let me know if this works for you.

 

Jim

 

 

 

 

Colleagues and Friends,

 

I issue you this challenge- I am trying to create an ID value that has a LETTER in it based on a numerical ID value… what would be the field calculator calculation code for generating an alphabetic value? For example, for ID 1- A, 2-B, etc… I look forward to the answer!

 

Kind regards,

 

Thad

 

 

Thad Dymkowski, GISP

GIS Manager

[log in to unmask]">

 

PRIME3SG: the Technology division of PRIME AE Group, Inc.

55 Capital Blvd. | 2^nd Floor | Rocky Hill, Connecticut 06067

P: 860 436 5600 | C: 860 657 6108 | [log in to unmask]

 

Connecting. Creating. Conserving. Community.

www.prime3sg.com

 

------------------------------------------------------------------------- This list (CTGIS-L) is an unmoderated discussion list for all CT GIS Users.

If you no longer wish to receive e-mail from this list, you can remove yourself by going to http://listserv.uconn.edu/ctgis-l.html