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