Extract any single word from a string of several words in a text field?
Apologies if this has been answered elsewhere, but I've searched the posts and the knowledge base and can't find anything that covers this particular case.
I have a text field that can contain up to 16 words separated by a space. I'd like to be able to extract a word from that text string based on its position, e.g., the third or fifth word or any other word from a string of words in a text field. Near as I can figure, Leftwords, rightwords, etc., won't work because they define starting points but not lengths. I just need a single word.
Is it possible to extract the just third or fifth or any other word from a long string of words in a field?