French Translation Library

[deborahb]

I need a function (UDF) or equivalent that will translate numbers into French. This could be a two step deal if necessary. Right now I can use ToWord to change the number "1" to "One". I'd like a function that will change "1" to "Un" (that is French for one?).

If you have something like this or know where I can acquire such a function it will be greatly appreciated. I have no use for a full translation tool like "Crystal Translator" - just a function that translates numbers. (This will be for a check (cheque) writing report.)

Thanks!
Deborah

 

[Madawc]

The replace command should be able to take the English number-to-word and convert.

Replace(Replace(@WordNUmber, "One", "Un), "Two", "Deux")

etc. Do it for all of the text, nesting or else using one part-converted formula field as input for another.

Madawc Williams (East Anglia, UK). Using Windows XP & Crystal 10

 

[deborahb]

Thank you for your reply but I think it is an over simplification of the problem. If I have a number like 1234.56 and I send it through the ToWord function I get

one thousand two hundred thirty-four and 56/100

which is exactly what I want - In French. With your method I'd have to have a replace for every number basically (only 100 or so I guess) plus dealing with the fraction at the end which I would want to keep.

Is that what you were thinking or am I missing something?

Thanks again,
Deborah

 

[Madawc]

Yes, and I don't think there is any short cut. Unless there is a French-language version of Crystal.

Madawc Williams (East Anglia, UK). Using Windows XP & Crystal 10

 

[deborahb]

There is a French Version but then everything comes in French which is not okay. I guess a brute force function is about the best I can do. Thanks for your time