Number-to-text in Spanish.

[mexboy]

Do you know any script routine to convert numerical quantities to words in Spanish language (very different from English syntax rules).

[BobWeaver]

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.

[mexboy]

Do you have a FM file including your solution to share with us? ;-)

[BobWeaver]

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.

[mexboy]

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. ;-)

[BobWeaver]

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

[BobWeaver]

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