Welcome to dbFreaks.com!
FAQFAQ      ProfileProfile    Private MessagesPrivate Messages   Log inLog in

TrimAll Function

 
   Database Help (Home) -> FileMaker RSS
Next:  Ajax and Javascript with PHP  
Author Message
martin.a.john

External


Since: Nov 16, 2007
Posts: 11



(Msg. 1) Posted: Mon Oct 06, 2008 8:07 am
Post subject: TrimAll Function
Archived from groups: comp>databases>filemaker (more info?)

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 
Back to top
Login to vote
Martin Trautmann

External


Since: Jan 15, 2004
Posts: 80



(Msg. 2) Posted: Mon Oct 06, 2008 12:25 pm
Post subject: Re: TrimAll Function [Login to view extended thread Info.]
Imported from groups: per prev. post (more info?)

This message is not archived

 >> Stay informed about: TrimAll Function 
Back to top
Login to vote
martin.a.john

External


Since: Nov 16, 2007
Posts: 11



(Msg. 3) Posted: Tue Oct 07, 2008 3:07 am
Post subject: Re: TrimAll Function [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

I think you are right. I tried a find/replace and it removed the
characters between the words but not trailing spaces. I guess I will
find someone to manually enter the data.
 >> Stay informed about: TrimAll Function 
Back to top
Login to vote
Martin Trautmann

External


Since: Jan 15, 2004
Posts: 80



(Msg. 4) Posted: Tue Oct 07, 2008 7:25 am
Post subject: Re: TrimAll Function [Login to view extended thread Info.]
Imported from groups: per prev. post (more info?)

Back to top
Login to vote
Display posts from previous:   
   Database Help (Home) -> FileMaker All times are: Pacific Time (US & Canada) (change)
Page 1 of 1

 
You can post new topics in this forum
You can reply to topics in this forum
You can edit your posts in this forum
You can delete your posts in this forum
You can vote in polls in this forum



[ Contact us | Terms of Service/Privacy Policy ]