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!
Kind regards,
Thad
Thad Dymkowski, GISP
GIS Manager
[log in to unmask]">
PRIME3SG: the
Technology division of PRIME AE Group, Inc.
55 Capital Blvd. | 2nd Floor | Rocky Hill, Connecticut 06067
P: 860 436 5600 | C: 860 657 6108 |
[log in to unmask]
Connecting. Creating. Conserving.
Community.
From: Wysor, James [mailto:[log in to unmask]]
Sent: Monday, February 22, 2016 1:19 PM
To: Thad Dymkowski <[log in to unmask]>
Subject: RE: GIS Challenge
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
----------------------------------------
GIS Analyst
The Metropolitan District
555 Main Street, PO Box 800
Hartford, CT 06142-0800
P: 860-278-7850, x. 3414
F: 860-251-6618
From: Unmoderated discussion list for Connecticut GIS Users [mailto:[log in to unmask]]
On Behalf Of Thad Dymkowski
Sent: Monday, February 22, 2016 12:42 PM
To: [log in to unmask]
Subject: [CTGIS-L] GIS Challenge
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. | 2nd Floor | Rocky Hill, Connecticut 06067
P: 860 436 5600 | C: 860 657 6108 |
[log in to unmask]
Connecting. Creating. Conserving.
Community.
------------------------------------------------------------------------- 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