I am importing data from excel into a filemaker database I have
created (using v8.5 adv).
A lot of the data I have is Arabic text when I import these records
filemaker creates spaces after the text, even though no spaces exist
in excel. I have tried to use the TrimAll function to remove these
spaces in both mac and windows environments but with no luck. Maybe I
am doing something wrong?
As the imported text was in a field called "Company Name Arabic" I
created a separate field "Company Name Arabic Copy", classed this as a
calculation field and under the settings for calculation field made
the following:
Company Name Arabic Copy = TrimAll(Company Name Arabic; 1; 0)
Is there something wrong with the above or does filemaker just have a
hard time with Arabic?
>> Stay informed about: TrimAll Function