Hi. I have several thousand records that I need to edit in the attribute table. Example = ####AA I need to retain the numberic data and need to delete the alpha data. (I'm working in a DB that does not allow adding fields.)
Can anyone help? Is there a simple script for this? Thanks
If the attributes are of the same width (that is, all have 4 numbers), use the LEFT function. If not, you may need to query and TRIM the appropriate number of characters as needed.
