llength=Position ( TheText ; "," ; 1 ; 1 )+1;
Wow! Can you explain this.. I have never scene the use of "llength" is the extra "l" for let length? and ( TheText ; "," ; 1 ; 1 )+1;
does this mean the space after the comma, then the word +1?
Thanks for the solution.
totlength,llength,tlength are all variables and can be anything. . Totlength is the total length of the field, llenght is the characters left of the comma,+1 accounts for the space pass the comma, tlength stand for the length of the return text. You can use any variables you desire, I try to use something to help me remember what each part does. You write 10,000 lines of code / script and then come back two years later and track down a bug or add a new feature. (I also add comments to my code)
You can also use this simpler expression:
RightWords ( YourText ; WordCount (yourText ) - 1 )