10 Replies Latest reply on Mar 7, 2019 6:15 PM by Ashraya SN

# Can we convert number into words in RTF

Hi All

We have requirement to convert the Number into words in RTF which would be like this -

if the number is -  3,523,546.25  t

Behaving result -

RUPEES THREE MILLION SIX HUNDRED NINETY-NINE THOUSAND SEVEN

HUNDRED TWENTY-THREE AND FIFTY-SEVEN PAISA

Expected -  it should be convert like - Thirty five lakh twenty three thousands five hundred forty six

• ###### 1. Re: Can we convert number into words in RTF

Yes we can do this in RTF.

Open the RTF file and then open the properties of the particular column then paste the below given information. It will work.

<?xdofx:to_check_number(COLUMN_NAME, ‘EUR’, ‘CASE_LOWER’, ‘DECIMAL_STYLE_WORDS’)?>

note : Replace the column name with your column name.

Thanks

Sulaiman

• ###### 2. Re: Can we convert number into words in RTF

Hi Sulaiman,

But it is also return in 'million' not in 'lakh'.

we want to convert the number which we have got from data model l.g 3,523,546.25  .

can you have any logic to convert above number to words (in lakh)

• ###### 3. Re: Can we convert number into words in RTF

Actually it is predefined function provided by the oracle.

These are all predefined functions are mainly returns the US standard character. So we can't able to perform this with predefined function even in sql also.

We can do this with the PL SQL by creating the function to return indian standard words like lakh and crore and all.

• ###### 4. Re: Can we convert number into words in RTF

but we can't write plsql here, the Bi reports does not have data model, only we can modified RTF.

there is any other option to print the value in lakh and crore

Thanks

Umesh

• ###### 5. Re: Can we convert number into words in RTF

You are right. Since no customization permissible to create a custom function like this.

So, we need raise a SR to Oracle then work with oracle for any work around to do this.

I don't think any other option exist in the system.

• ###### 6. Re: Can we convert number into words in RTF

Hi Umesh,

Try the below one which is works good to me.

<?xdoxslt: toWordsAmt(3523546.25)?>

Thanks

Sulaiman

• ###### 7. Re: Can we convert number into words in RTF

Hi Sulaiman,

Yes , the above function work in this condition only but we have a data like this  <?xdoxslt: toWordsAmt(3,523,546.25)?> .

Comma separator value  does not support

Can we add another format function in this same function which would be first format the num and then num will convert into words.

• ###### 8. Re: Can we convert number into words in RTF

Ya correct.

First you have to format and then the conversion.

Thanks

Sulaiman

• ###### 9. Re: Can we convert number into words in RTF

Hey Umesh,

You got the answer right then you can close this discussion by choosing the correct answer.

Thanks

Sulaiman

• ###### 10. Re: Can we convert number into words in RTF

Hi Sulaiman ,

This function is giving the amount in words when we give the amount in static

but when I am trying the same in my RTF like below

<?xdoxslt: toWordsAmt(AMOUNT)?>  I am not getting the error (where AMOUNT is the run time amount value)

and <?xdofx:to_check_number(AMOUNT, ‘INR’, ‘CASE_LOWER’, ‘DECIMAL_STYLE_WORDS’)?>

(where AMONUT comes in run time) I am again getting the value in Number instead of words