How do I remove the left word only in a field?
Check out Substitute -
Substitute ( yourfield ; LeftWords (yourfield ; 1) ; "" )
MiddleWords ( YourField ; 2 ; WordCount ( YourField ) )
Note that the Substitute ( ) function can alter all the remaining text.
As usual, many ways to do the same thing in FM...
RightWords (text; WordCount (text) -1)
Karen, in your version it will remove all occurances of the left word. For example; "the quick brown fox jumped over the lazy dog" becomes "quick brown fox jumped over lazy dog".
You are correct - it would remove all occurrences! Didn't think of that. So that wouldn't work unless the leftmost word was unique.
Thanks for catching that!
Retrieving data ...