I have three .csv files (Duchesne Wells, Carbon Wells, Uintah Wells) that each have four fields (OBJECTID, NAME, WELL_NUM, API). I need to extract the Well Number (See below for Well Number and Well Alpha/Number Combo) from the name field and put it in the WELL_NUM field. I'll state the obvious just in case, the extracted information needs to correlate with the existing fields, espically the OBJECTID field and the NAME FIELD, so I can have a key to link this table to other tables.
Definition of Well Name:
Example Name: UTE TRIBAL 1-9-4-4
UTE TRIBAL = WELL OWNER
1 = WELL NUMBER
9 = SECTION
4 = TOWNSHIP
4 = RANGE
This is the typical structure for the well name, but there are variations. With these different variations I just need to extract the well alpha/number combo. (Note: There are more variations than what is listed) Example:
Example Name: CHEVRON UTE TRIBAL 2 (22-18)
Well Alpha/Number combo: 2 (22-18)
Example Name: ALBERT SMITH 1
Well Alpha/Number combo: 1
Example Name: OLSEN U 1-12A2
Well Alpha/Number combo: 1-12A2
The three tables have a total of 19,316 rows in them, so you can see why I need some help! Duchesne Wells has 4,887 rows, Uintah Wells has 12,808 rows, and Carbon has 1,621 rows. I have completed the first 200 rows in the Duchesne Wells file for more examples. This project can be done manually or if you can come up with a way to extract the Well Number and the Well Alpha/Number Combo through programming or other means that will be acceptable. It is very important that the information is extracted correctly!