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?
Solved! Go to Solution.
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]
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'