Sorry for asking such a very basic question — but I can't for the life of me remember how it's done.
I've got three text strings — "big turtle", "great big turtle" and "great big huge turtle"
Using a 'space' as text item delimiter I can easily capture "turtle" as a separate string
How do I most easily capture everything up until that last space (ie. "big", "great big", etc.)
I'm assuming that looping through the remaining space delimited text items is the slow way
Many thanks for any help
Set the text item delimiters to a space, then get "text 1 thru text item -2 of theVar".
Briliant — thanks Shane
As always, your solution is so much more elegant than what I ended up with, doddling along on my own.