topic Re: Regex assist needed in Python Questions

Regex assist needed

JustinWhisenant — Mon, 28 Jul 2014 20:16:42 GMT

I am trying to remove "/1" from the end of every entry in a certain field. I know I can just strip it off, but I would like to solve it with regex for my own edification. Here is my code so far. It runs without error but has no effect on the data.

with arcpy.da.UpdateCursor("Table", "parcel_ID") as rows:

... for row in rows:

... badtext=row[0]

... goodtext=re.sub(r'/1', '', badtext)

... row[0]=goodtext

Anyone know what I am doing wrong? Thanks.

Re: Regex assist needed

IanMurray — Mon, 28 Jul 2014 20:32:17 GMT

you probably need this after row[0] = goodtext

rows.updateRow(row)

ArcGIS Help (10.2, 10.2.1, and 10.2.2)‌

Re: Regex assist needed

AnthonyGiles — Mon, 28 Jul 2014 20:35:00 GMT

Justin,

you are looping through the rows but you are not looping through your fields and assigning any data to a particular field. Have a look at some of these examples:

ArcGIS Desktop‌

ArcGIS Help 10.1‌

Re: Regex assist needed

IanMurray — Mon, 28 Jul 2014 20:40:18 GMT

Anthony, he is calling the value of one field he is accessing with cursor with his index. You posted help for the old cursor, not the data access cursor, for which his syntax should be fine, since it takes a feature class name, and field(s) which he has(assuming his feature is called "Table")

He isn't looping through multiple fields, just the one field.

Re: Regex assist needed

AnthonyGiles — Mon, 28 Jul 2014 20:45:26 GMT

Cheers Ian,

i have just read this help and what you are saying makes sense:

ArcGIS Help 10.1‌

Re: Regex assist needed

IanMurray — Mon, 28 Jul 2014 20:49:12 GMT

tbh, I posted the wrong help the first time too and had to go correct myself, its easy to get the regular and data access cursors mixed up.

Re: Regex assist needed

AnthonyGiles — Mon, 28 Jul 2014 20:56:45 GMT

Ian,

will python in arcmap recognise the \Z metacharacter to ensure only the end of the string is changed and not any occurrences in the rest of the text

Re: Regex assist needed

IanMurray — Mon, 28 Jul 2014 21:03:27 GMT

I don't see why it wouldn't, I've never tested it but I would assume it would work.

Re: Regex assist needed

JustinWhisenant — Mon, 28 Jul 2014 21:10:11 GMT

Ian,

Thank you that was the problem. I forgot to apply the update. It seems obvious now.

Justin