asked on

Convert Number to Text

hi!...

i already have this program using delphi in converting number to text...is there any DLL for this is power builder or do i have to program same way..if i do could anyone give me a sample program? Thank you....

manny

gafoor78

hi

what u meant actually ?, casting with
string(number)
or convert an ascii integer to its char with

char(integer)
for eg: char(65) will return A.

can u make ur query more clear ?. actually what u want to do ?

rgrds
gafoor

Emmanuel_Tapangan

ASKER

i want to convert a number to words like...

250 -> Two hundred fifty

250.25 Two hundred fifty and 25/100 or Two hundred fifty and twenty five centavos

although im currently working it now but if u do have one..could u help me..tnx

manny

gajender_99

what you can do is creat a table with two colums number and number_charater
populate it from 1 to 100 and 1000,million,billion and then write a function which divied the number into parts and retrived the character value from the table.
if you want a example let me know

Emmanuel_Tapangan

ASKER

tnx a lot but honestly i made it already in delphi without using tables...i would be much more happy if u can help me in such a way without using any tables only constants variable...tnx a lot

regards
manny

Vikas_Dixit

Please take a look at http://groups.yahoo.com/group/PowerObject/files/PowerScript/
file Num2Words.srf

http://f5.grp.yahoofs.com/v1/gHS8P0Ty3Td2FWo5Z3LXvfEzlQrO0dL8Uh0dBYGWBhUEUHyj3DirpTo27pbLbndJXxFDHiGaU1k-_qbjLdbjh_HIuQ6dKUXe/PowerScript/Num2Words.srf

Regards,
VIkas D

ASKER CERTIFIED SOLUTION

gajender_99

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Emmanuel_Tapangan

ASKER

manny_tapangan@mmcc.com.ph...Viks..im looking forward some options...dnt worry...

Sys_Prog

Here's my code for that

HTH

Amit

Emmanuel_Tapangan

ASKER

hi...

im sorry i ddnt understand the words like "Lac,Crore"..i just want a simple output of my query like

125.25 [as_input]

equivalent to..

"One hundred twenty five and 25/100"

thats all....tnx a lot...

manny

Emmanuel_Tapangan

ASKER

gajender_99....did u email ur modified code regarding my query? actually we're almost there...i hope u have it
tnx a lot...

Emmanuel_Tapangan

ASKER

man...tnx a lot for ur help..im looking forward next if i need some tips from u or the other experts in PB..
tnx a lot guys for the time you've exert..have a nice day to you all....

Codezilla

Just wanted to add my 2 cents regarding the suggestion to create a table. The datawindow is a powerful object. You don't always need to create a table to take advantage of its power. Embedding data in a datawindow object and assigning the datawindow object to a datastore lets you take advantage of the datastore's Find and Filter and Sort functionality.