1 2 Previous Next 17 Replies Latest reply on Feb 1, 2017 10:21 AM by fmpro_novice

    How do I separate words in a sentence?

    fmpro_novice

      If I have a field that contains the following, for example:     Boo Ray vs Bushwhackers

      Legends vs Lightning Streaks

      How would I separate those words to everything in front of the "vs" and everything beyond the "vs?"

       

      Boo Ray

      Bushwhackers

      Legends

      Lightning Streaks

       

      ...is what I need to end up with.

       

      I know I could do "RightWords" and "LeftWords" but as you can see from the list, some of them have two words in front of the "vs" and some have one word. Same for the other side of the "vs." The "vs" needs to be what determines what words end up being Left Words and Right Words.

        1 2 Previous Next