mexboy Posted March 21, 2001 Share Posted March 21, 2001 Do you know any script routine to convert numerical quantities to words in Spanish language (very different from English syntax rules). Link to comment Share on other sites More sharing options...
BobWeaver Posted March 21, 2001 Share Posted March 21, 2001 Did you have a look at the following topic? http://www.fmforums.com/ubb/Forum15/HTML/000336.html The technique I described there works in both English and French, using a related file with the text version of numbers from 1 to 100. So, I expect it could be adapted to Spanish. Most languages seem to reach some sort of regular pattern after 100. Link to comment Share on other sites More sharing options...
mexboy Posted March 22, 2001 Author Share Posted March 22, 2001 Do you have a FM file including your solution to share with us? ;-) Link to comment Share on other sites More sharing options...
BobWeaver Posted March 25, 2001 Share Posted March 25, 2001 I have this as part of a much larger database which I can't send you unless I strip out everything else. From past experience, this is a rather time consuming process. If I get time in the next few days, I will see what I can do. Meanwhile, I'd be happy to answer any specific questions. Link to comment Share on other sites More sharing options...
mexboy Posted March 25, 2001 Author Share Posted March 25, 2001 Maybe you could just copy the full calculation included in merging field containing the final text, and paste it here in a board message... just an idea. ;-) Link to comment Share on other sites More sharing options...
BobWeaver Posted March 27, 2001 Share Posted March 27, 2001 Okay, here it is. You owe me muchas cervezas for this one. My apologies to everyone for such a large post. A word of warning, my spanish is terrible, so you will have to play with this to clean it up. In particular, I don't know when to use "milliones" instead of "milli Link to comment Share on other sites More sharing options...
BobWeaver Posted March 27, 2001 Share Posted March 27, 2001 Forgot to mention that the seven relationships are: NumTextgbl: based on a calculated constant equal to 1 in both files; NumText1a: field Grp1a in main file, N in NumText.fp5 NumText1b: field Grp1b in main file, N in NumText.fp5 NumText2a: field Grp2a in main file, N in NumText.fp5 NumText2b: field Grp2b in main file, N in NumText.fp5 NumText3a: field Grp3a in main file, N in NumText.fp5 NumText3b: field Grp3b in main file, N in NumText.fp5 Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 8430 days old. Please don't post here. Open a new topic instead.
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 accountSign in
Already have an account? Sign in here.
Sign In Now