Inverse (change) String position

[Hakimipous]

Hello,

Is it possible to inverse  (or change) string position from a field?

for example from "Jason Tod"

to "Tod Jason"

should also work with composed names (with 3 words or more)

Thanks!

[jdunkerley79 · Accepted solution]

Try the attached.

- Add a record ID

- Split the text on Space to rows

- Add a word ID using a MultiRow formula

- Sort by RecordID (Asc), WordID (desc)

- Summarise grouping by RecordID and concatenating the words

[Hakimipous]

Works like a charm, thanks!