AnsweredAssumed Answered

Why is LeftWords function deleting period?

Question asked by illbe on Dec 1, 2012
Latest reply on Dec 5, 2012 by illbe

Title

Why is LeftWords function deleting period?

Post

     OK, I know this is likely something easy but ...

     I have a feild derived by a LeftWords function that looks for a coma, if it sees one it splits the word, if not it displays the whole field:

      

     If ( Position ( vnname ; ","; 1; 1) = 0;LeftWords(vnname; 8);LeftWords ( vnname ; 1 ))

     This works just fine EXCEPT for one record that has a period at the end, filemake displays everything up to the period.

      

     i.e.: Beans Inc. displays as Beans Inc

      

     Please help before I'm completely bald :-)

      

     Thank you in advance

      

     Tom

Outcomes