topic Re: Move last word to first word in field calculator in Python Questions

Move last word to first word in field calculator

kat_h — Thu, 21 Oct 2021 15:50:14 GMT

Hi!

I'm trying to give watercourse names their French name from their English name, so I need to change the order of words a bit such as:

Wind Ruisseau -> Ruisseau Wind

I can remove Ruisseau with !Nom![:-9], but I can't figure out how to place it in the front with a space.

Some watercourse names hare three words like

West Wind Ruisseau

Would using an UpdateCursor be more simple than trying to figure out an expression in the Field Calculator?

Thanks!

Re: Move last word to first word in field calculator

ABishop — Thu, 21 Oct 2021 15:59:41 GMT

"West Wind"+' ' +"Ruisseau"

Re: Move last word to first word in field calculator

kat_h — Thu, 21 Oct 2021 16:00:59 GMT

I need to do it for thousands of unique names that end with "Ruisseau" and make them start with "Ruisseau"

Re: Move last word to first word in field calculator

ABishop — Thu, 21 Oct 2021 16:05:26 GMT

Are the unique names in a specific field you can call out? In this case, you could use the field calculator to do this:

"Ruisseau"+' ' +[FIELD NAME]

Re: Move last word to first word in field calculator

JoshuaBixby — Thu, 21 Oct 2021 16:07:37 GMT

>>> s = "Wind Ruisseau" >>> " ".join(s.split()[::-1]) 'Ruisseau Wind' >>>

Re: Move last word to first word in field calculator

kat_h — Thu, 21 Oct 2021 16:08:15 GMT

Ah yes, that's a much more simple solution than I was thinking. I think this should work, thank you!

Re: Move last word to first word in field calculator

kat_h — Thu, 21 Oct 2021 16:14:09 GMT

Thanks! I'll give this a try as well.

Can I make my field equal s? like s = !Nom! so it selects my selected rows from this field?

Re: Move last word to first word in field calculator

kat_h — Thu, 21 Oct 2021 16:23:39 GMT

Just tried with field name, which absolutely works! Thanks kindly.

Re: Move last word to first word in field calculator

kat_h — Thu, 21 Oct 2021 16:42:12 GMT

Hi Joshua,

Is there a way to I could keep the order of the middle words when there are three words in the string?

For example, this expression also reverses the names of the other words:

'West Wind Ruisseau' becomes 'Ruisseau Wind West'

and I would like 'Ruisseau West Wind'

Re: Move last word to first word in field calculator

BlakeTerhune — Thu, 21 Oct 2021 17:05:47 GMT

Here's another solution to consider.

s = "West Wind Ruisseau" s = s.rsplit(" ", 1) last_word = s.pop() s = " ".join([last_word] + s)

Re: Move last word to first word in field calculator

JoshuaBixby — Thu, 21 Oct 2021 18:06:40 GMT

If you just want to make the last word the first word:

>>> s = "West Wind Ruisseau" >>> " ".join(s.split()[-1:]+s.split()[:-1]) 'Ruisseau West Wind' >>>

Re: Move last word to first word in field calculator

kat_h — Fri, 22 Oct 2021 02:33:22 GMT

That makes sense! Thanks so much!

Re: Move last word to first word in field calculator

kat_h — Fri, 22 Oct 2021 02:34:23 GMT

Thanks Blake! I was wondering to workaround it with pop() as well.