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?"
...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.