Devam Ediyor

Extracting Text From a Field

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!

Beceriler: Veri Girişi, Veri İşleme, Excel, Python, Visual Basic

Daha fazlasını görün: programming important, visual programming python, python programming help, python programming examples, programming visual basic 2010, programming from, programming definition, it field, definition programming, be smith, visual basic programming help, smith, extract tables, carbon, albert, text extracting, python extract, table extract, csv text file, text table, python csv text, python api, api programming examples, visual basic case project, text number 200

İşveren Hakkında:
( 4 değerlendirme ) Duchesne, United States

Proje NO: #728691