2 Replies Latest reply on Dec 30, 2014 3:51 PM by pauhana658

    Extract any single word from a string of several words in a text field?

    pauhana658

      Title

      Extract any single word from a string of several words in a text field?

      Post

      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?

      Thanks!