This will count all words up to the first comma in the text field:
WordCount ( Left ( Table::TextField ; Position ( Table::TextField ; "," ; 1 ; 1 ) ) )
This expression will extract all words to the left of the first comma:
Let ( [ T = Table::TextField;
Wc = WordCount ( Left ( T ; Position ( T ; "," ; 1 ; 1 ) ) )
Leftwords ( T ; Wc )
As we say in New York, Phil "You da man!". Thank you very much for the quick reply, it was just what I needed.
All the best