I am using 10.0 ArcView and am trying to get the "R" in R12345678910 to drop.
The numbers are in a column in the attribute table and i've always used VB scripting.
I was using Field Calculator.
Geographic Information Systems Stack Exchange is a question and answer site for cartographers, geographers and GIS professionals. It only takes a minute to sign up.Sign up to join this community
[1:] to a string in python will remove the initial character. Look up slice in the python help.
To use this in the ArcGIS field calculator, you will need to turn on Python parsing
unitCode = enter
We're looking for long answers that provide some explanation and context. Don't just give a one-line answer; explain why your answer is right, ideally with citations. Answers that don't include explanations may be removed.
Right( [FieldName], 11 )
This code will take the 11 characters from the right, and anything left of those 11 characters is omitted.
This code takes a string and removes R from the left/front of it.
Both of these examples should get rid of the R in your strings.
Edit: Regan Sarwas' updated answer works great and is actually more versatile because it can handle more cases.