New and need some major help!!!!!

769
3
01-31-2013 06:59 AM
AndrewSmith
New Contributor III
I have a field (string 150), called RFID. It has a text coded number for RFID tags. I need to chop off the first part of the number, and leave only 8 identifying number at the back. is there a way of doing this, since I have over 2000 RFID tags, and I do not want to do it by hand.

Example

1st Field RFID_Tag (String, 150) 3000000000000000000000000000000000000000BC201001078 (needs to be reduced into field)
2nd field RFID_Code(String, 50)  BC201001078

They are both in the same table. The RFID_Tag comes from a spread sheet imported into ArcMap, them made into a feature class table, then a Feature class. But how do I remove the excess front numbers

Thank you for all your ideas and help.

Andrew
Tags (2)
0 Kudos
3 Replies
MathewCoyle
Frequent Contributor
You could just do this in field calculator unless you want to make it a script. Your example has more than 8 characters so modify the number you want if it isn't 8.
RFID_Code =
!RFID_Tag![-8:]
0 Kudos
AndrewSmith
New Contributor III
Thanks, that worked great, Thanks for the help. I also just learned where the results get posted to as well.

Thanks Mathew
0 Kudos
MathewCoyle
Frequent Contributor
Thanks, I just tried that, and keep getting there was a failure durring proessing, check Geoprocessinf Results widow for details.

No detail window is to be found either.


Did you use the Python parser?
0 Kudos