ToWords in Spanish

[jenlion]

I need to be able to do towords in Spanish. Googled this and all indications are that if you get a Spanish version of Crystal, you get Spanish ToWords.

I downloaded a demo of Crystal 2008 and installed it, choosing spanish as the language. Went fine. But when I create a simple report with a formula for "towords" in it, the words are in English. I've set the product locale to Spanish, but no change.

I've found all the crtowords_en.dll on my computer and renamed to .old. No good, must be coming from somewhere else??

At any rate, I just need to FORCE it to use crtowords_es.dll, which did install, along with all the other possible languages. Anyone know how to do that???? We will need to print some checks in Spanish. TIA

 

[Madawc]

What you could do is take the English and use REPLACE to substitute the corresponding Spanish name for each number. Something like

Replace(@numberName, "one", "uno")

Assuming "uno" is the correct word, I don't know Spanish and I'm surprised that Crystal can't adjust.
You can do a hierarchy of replacements, use @StageA as input for another formula field that replaces "two" etc. You can also 'nest' replace statements within each other, e.g

Replace ( (Replace(@numberName, "two", "duo"), "one", "uno")

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

 

[jenlion]

We considered that, but it does get kind of tricky. It's not as "clean" as it should be -- I think it would be obvious that it was a clumsy translation. Three hundred, for example, is tresciento, not tres cien. But one hundred is just ciento, if I remember correctly. You might say "un ciento" or even "uno ciento" and be understood, but not unociento, I don't think. So, you could do a lookup table, or a replace function, and be *understood*, but it wouldn't be professional. And these are for professional checks, so I'm hoping to do better than that.

The thing that gets me is that there are a ton of references to towords in spanish from crystal, but I can't figure out how to get crystal to point to that instead of the english version. Tried the BO support site but every time I try to open a help subject I get site errors and can't read anything. rrrrrr. (happens in IE and FF both).

Thanks anyway on that. Anyone else know??

 

[Hetan]

Just do the following:

1. Go to C:\Program Files\Common Files\Business Objects\2.7\Bin\
2. Rename crtowords_en.dll to crtowords_xx.dll
3. Rename crtowords_es.dll to crtowords_en.dll

And that's it!!