Latest Contributions by JoshuaBixby

Open a case with Esri Support, likely a regression defect in Pro 3.2. I can replicate this issue with a new/clean 11.2 enterprise geodatabase on SQL Server 2022 and Pro 3.2.  Using SQL Profiler, the SQL being passed to SQL Server is good and doesn't generate any errors or warnings, so this seems to be an internal Pro issue. ... View more

Although a regular expression answer has been put forward, I believe there is a more straightforward regular expression than what has been already proposed.  Also, all that is needed in terms of cursors is a single pass through the data set with an update cursor. First, the regular expression.  You are trying to match pairs of species-values that have been concatenated into a single string, so there are 3 things to differentiate:  1) a species-value pair, 2) the species within that pair, and 3) the numeric value for the species in that pair. The following regular expression captures that logic:   >>> import re >>> >>> reg_exp = "(?:([A-Za-z]+)\s*([0-9]+))+?" >>> >>> SPCOMP_samples = [ ... "Pj 60Sb 40", ... "Pj 60Sb 40", ... "Sb 80Pj 10La 10", ... "Pj 60Sb 40", ... "Pj 80Sb 10Pt 10", ... "Pj 80Sb 10Pt 10" ... ] >>> >>> for sample in SPCOMP_samples: ... re.findall(reg_exp, sample) ... [('Pj', '60'), ('Sb', '40')] [('Pj', '60'), ('Sb', '40')] [('Sb', '80'), ('Pj', '10'), ('La', '10')] [('Pj', '60'), ('Sb', '40')] [('Pj', '80'), ('Sb', '10'), ('Pt', '10')] [('Pj', '80'), ('Sb', '10'), ('Pt', '10')] >>>   The regular expression uses a non-capturing outer group to find the species-value pairs, and then uses two internal capturing groups to differentiate the species from the numeric value.  Using the expression with re.findall returns a list of tuples containing a species and a numeric value. Since each tuple contains the species and the value, you can use the species to look up the index of the species field in a cursor and update that field with the value. # Note: Code below hasn't been tested reg_exp = "(?:([A-Za-z]+)\s*([0-9]+))+?" fc = # path to feature class or shape file with arcpy.da.UpdateCursor(fc, "*") as cur: spcomp_idx = cur.fields.index("SPCOMP") for row in cur: for species, value in re.findall(reg_exp, row[spcomp_idx]): species_idx = cur.fields.index(species.upper()) row[species_idx] = value cur.updateRow(row)   ... View more