How do I separate words in a sentence?

Discussion created by fmpro_novice on Jan 31, 2017
Latest reply on Feb 1, 2017 by 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



Lightning Streaks 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.