topic Re: Move text after comma in Python Questions

Move text after comma

2Quiker — Fri, 18 Dec 2020 18:06:17 GMT

I have a table and in that table I have field Fld_1 and I would like to move the text after the comma to the front of the attribute and remove the comma. Not all attributes will have a comma.

I am able to split the filed attrubutes but am not sure how to work with the comma ','.

with arcpy.da.UpdateCursor(Table, ['Fld_1']) as cursor:
for row in cursor:
row[0] = " ".join(row[0].split()[:3])
cursor.updateRow(row)
del cursor

Example

Island Village, The --> The Island Village

Re: Move text after comma

DanPatterson — Fri, 18 Dec 2020 18:31:55 GMT

How fancy do you want to get??

def r(a, pad=" "): if "," in a: b = a.split(",") c = b[1].strip() + pad + b[0] else: return a return c r("first, last") 'last first'

Re: Move text after comma

BlakeTerhune — Fri, 18 Dec 2020 18:35:00 GMT

I would use rsplit() to ensure you only split once on the last separator. You can use .reverse() to put the last value first, then join it all back together.

with arcpy.da.UpdateCursor(Table, ['Fld_1']) as cursor: for row in cursor: value_split = row[0].rsplit(", ", 1) value_split.reverse() row[0] = " ".join(value_split) cursor.updateRow(row)

Also note: you don't need to del the cursor when using with

Re: Move text after comma

JoeBorgione — Fri, 18 Dec 2020 18:59:36 GMT

Check for the presence of a comma. Treat row[0] as a list, pop() off the last member of that list and glue the whole mess back together, replacing the comma....

with arcpy.da.UpdateCursor(Table, ['Fld_1']) as cursor: for row in cursor: if ',' not in row[0]: pass elif ',' in row[0]: rowList = row[0].split(' ') first = rowList.pop() last = ' '.join(rowList) newRow = f'{first} {last}'.replace(',','') row[0] = newRow cursor.updateRow(row)

Re: Move text after comma

JoshuaBixby — Fri, 18 Dec 2020 19:40:59 GMT

Just for the code golf fun of it:

>>> s = "Island Village, The" >>> " ".join(reversed(list(map(str.strip, s.split(','))))) 'The Island Village' >>> >>> s = "Peninsula Town" >>> " ".join(reversed(list(map(str.strip, s.split(','))))) 'Peninsula Town' >>>

Re: Move text after comma

JoeBorgione — Fri, 18 Dec 2020 19:42:53 GMT

I love the contrast in our styles!

Re: Move text after comma

DanPatterson — Fri, 18 Dec 2020 20:01:46 GMT

You guys...

Re: Move text after comma

BlakeTerhune — Fri, 18 Dec 2020 21:36:01 GMT

Can't believe I forgot about pop()!

Re: Move text after comma

JoeBorgione — Fri, 18 Dec 2020 21:59:02 GMT

That's what's so fun about a post like this! Several different approaches that all work. I've never ever used rsplit(). Joshua's nested map() is pretty cool too! Just hope the OP isn't overwhelmed!

Re: Move text after comma

BlakeTerhune — Fri, 18 Dec 2020 22:01:42 GMT

Haha, yeah, we all jumped on this like a pack of hungry ~~wolves~~ pythons.

Re: Move text after comma

JoshuaBixby — Fri, 18 Dec 2020 22:58:30 GMT

The Python questions must be light lately, everyone has pent up energy to write some code snippets.

Re: Move text after comma

DanPatterson — Sat, 19 Dec 2020 22:18:43 GMT

" ".join([i.strip() for i in a.split(",")][::-1]) # ---- forgot list comprehensions