drjonesx

Number to text

3 posts in this topic

Hello everybody

I'm trying to convert number to text en dutch but it doesn't work

i had some problem with the calc field when i m trying ( some are good but other doesn't work)

is there someone that can help me to resolve this little problem cose i m not a dutch person ;)

I join the file that i made to be more clear

In advance thanks u

cardinal2txt NL.fmp12

Share this post


Link to post
Share on other sites

Hey drjonesx,

Don't know Dutch, but do know FileMaker ;oP

I took an old custom function and converted it for you. It may need a bit of debugging and far as language, but the numbers portion is pretty solid. I have it in a custom function for English and Dutch. I, also, included a NON custom function version in case you do not have FileMaker Advanced. Between them all you should be able to solve your issue.

Hope this helps!

Don Wieland
DW Data Concepts

cardinal2txt NLv2.fmp12

Share this post


Link to post
Share on other sites

Thanks dwadata for trying to help me

but it s that the problem i need a dutch person cose in dutch some number are write in other way that english

for example when u write in english 23 u set the twenty the the three in dutch u set forst the three the the twenty :(

 

So that s way i m not arrive to do it cause i m not speak this language :( Grrrr

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!


Register a new account

Sign in

Already have an account? Sign in here.


Sign In Now

  • Similar Content

    • By Asu
      Hello FM Mavens, 
      I would like to be able to change an attribute (happens to be the size) of a selection in a text window with a script. (Basically, as if moving the size selector from the Formatting Bar into a button on a layout).
      I created a script that cuts the selection, puts it in another text field, makes the change, cuts it out and goes back to the original field but by then the insertion point is gone. I can manually paste it back of course.  I wonder if there is a way to remember the insertion point somehow and make it a so the paste step uses it. 
      Thanks
      Asu
       
    • By Mike_k
      OK I admit it ... I'm stumped. I'm not a FileMaker professional, merely an enthusiastic tinkerer.
      I'm trying to create a feedback system where a series of standard questions are checked. Based on this, those questions answered 'yes' are combined together and those answered 'no 'are ignored. I have created 2 fields per criteria, 'Preset text' and 'preset question'. 
      So ...Preset message = 
      (if preset question 1 = yes, include ‘preset text 1’ else, blank){cr}
      (if preset question 2 = yes, include ‘preset text 2’  else, blank){cr}
      ….
      (if preset question 10 = yes, include ‘preset text 10’ else, blank){cr}
      I've managed to get the display of answers based on yes/no, but I can't get rid of the blank lines.
      I'm am probably going about this the wrong way, so any suggestions?
      thanks
    • By Oyseka
      Hi All,
      I am trying to parse text from a Job Card Items table into the related Job Card and not getting the correct result.. as the Items in the Job Card are completed any anomalies have to be reported on the Job Card and with up to 50 items in the Job Card Items there may be more than one anomaly to report, (very rarely more than two) . If the Findings field is empty I am just inserting the Variables but when the field already contains data I am using this to parse the text:
      Position ( JobCard::Findings ; ":" ; 1 ; 1 )&¶ & $ProdName &" "& $ItemLocation & " " & $QItemSerial
      On the second insertion I am getting this:
      PR00023 FC iLLume Unit FC0000084 Unit damaged:46
      PR00023 FC iLLume Unit  FC0000084
       
      Where is the 46 coming from ?
    • By jax
      I use a formula to round a number to 1 decimal point and put brackets around it before plugging it into a text document. This works fine for most numbers but it fails for numbers ending in zero. They are instead returned by the function without any decimal, 1 nothing instead of 1.0. That's a bug as far as I can see. If I specify 1 decimal point and get none from the function, I consider the code broken.
      input:      numbers with variable decimal points, e.g. 2.345 and 1.0
      formula:    "(" & Round ( final grade ; 1 ) & ")"
      output:     2.3 (correct) and 1 (incorrect)
      expected:   2.3 and 1.0
      How can I work around this? I'm running FM Pro 12 Advanced.
    • By troi
      Troi Automatisering releases Troi Text Plug-in 4.0.1 for FileMaker Pro 15
       
       
      June 22nd, 2016, Alphen aan den Rijn, The Netherlands--Troi Automatisering today announced the availability of Troi Text Plug-in 4.0.1 for FileMaker Pro 15.
       
       
      What is new in version 4.0.1?
       
      Version 4.0.1 is further optimized for use with FileMaker 15. In this version we made description and type-ahead information available for all functions of the plug-in. This extra function description will be shown in FileMaker Pro 15 in the Specify Calculation dialog box when you type a function name and also as a text popup in the functions pane on the right. The type-ahead information is used by the auto complete functionality of FileMaker Pro 15.
       
      More detailed information on all changes and improvements implemented in Troi Text Plug-in 4.0.1 and earlier can be found at: http://www.troi.com/software/texthistory.html
       
       
      Pricing & upgrade information
       
      A fully functional version of Troi Text Plug-in 4.0.1 is available for downloading at Troi's web site at: http://www.troi.com/software/textplugin.html.
       
      Licenses cost US$ 49 per user. Details on developer licenses and multi-user discounts can be found on our web site. You can order licenses from our web site.
       
      Upgrading to version 4.0.1 is free for all users of version 4.0: version 4.0.1 works with the same registration as the 4.0 version. Product updates from earlier versions, bought on or after August 7th, 2015, are FREE: eligible users have been emailed a new 4.0 registration string. Contact us if you have not received yours.
       
      Upgrades from licenses bought before August 7th, 2015, are available from US$ 29 per user. Upgrade prices for other licenses can be found on our web site. You can order upgrades from our web site.
       
       
      Contact information  
       
      D. Budding
      Troi Automatisering
       
      Newsroom: http://www.troi.com/news/