AnsweredAssumed Answered

Why is LeftWords function deleting period?

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


Why is LeftWords function deleting period?


     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