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

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.

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

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.

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

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

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