Hi all,
I am looking to use geoprocessing tools or python script in ArcPro to identify numeric data (year) within cells of one attribute table column, pull the year and then populate a corresponding attribute table cell with that data. I've attached a screenshot example of the data for water pipe that I would look to use as a test.
I want to run the tool on a large number of records (over 12,000) have them identify and copy the four digit year from a project (district) description, then populate the 'year_inst' field with said number.
Is this feasible? Or at least a version of it that I could then QC? I would appreciate any and all feedback as I'm not looking forward to attempting to clean thousands upon thousands of attribute records.
Appreciate this community and any help offered.
Cheers,
-Matt