topic Script to edit part of text string in Data Management Questions https://community.esri.com/t5/data-management-questions/script-to-edit-part-of-text-string/m-p/90400#M5280 <HTML><HEAD></HEAD><BODY><SPAN>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.)</SPAN><BR /><BR /><SPAN>Can anyone help? Is there a simple script for this? Thanks</SPAN></BODY></HTML> Wed, 07 Sep 2011 14:49:24 GMT JustineJedlicka 2011-09-07T14:49:24Z Script to edit part of text string https://community.esri.com/t5/data-management-questions/script-to-edit-part-of-text-string/m-p/90400#M5280 <HTML><HEAD></HEAD><BODY><SPAN>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.)</SPAN><BR /><BR /><SPAN>Can anyone help? Is there a simple script for this? Thanks</SPAN></BODY></HTML> Wed, 07 Sep 2011 14:49:24 GMT https://community.esri.com/t5/data-management-questions/script-to-edit-part-of-text-string/m-p/90400#M5280 JustineJedlicka 2011-09-07T14:49:24Z Re: Script to edit part of text string https://community.esri.com/t5/data-management-questions/script-to-edit-part-of-text-string/m-p/90401#M5281 <HTML><HEAD></HEAD><BODY><SPAN>If the attributes are of the same width (that is, all have 4 numbers), use the LEFT function.&nbsp; If not, you may need to query and TRIM the appropriate number of characters as needed.</SPAN></BODY></HTML> Wed, 14 Sep 2011 14:04:58 GMT https://community.esri.com/t5/data-management-questions/script-to-edit-part-of-text-string/m-p/90401#M5281 MarkEllis 2011-09-14T14:04:58Z