core.noscript.text
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!
Solved! Go to 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
Works like a charm, thanks!