I have an 11 digit ID in one field I'll call "Current_ID". I would like to create a new field named "New_Field" and populate it with same value except I need to change the value of the 4th digit from a 5 to a 4.
Example:
"Current_ID" = 1505000001
"New_Field" desired ID = 1504000001
Both field types are Double
400 records
How can this be done using Field Calc?
Answer
Use field calculator expression:
"Current_ID"-1000000
No comments:
Post a Comment