5 Replies Latest reply on Dec 5, 2012 7:33 AM by illbe

    Why is LeftWords function deleting period?

    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