| |||||||||||
| |||||||||||
Outputting numbers as words - MySQL with Perl or PHP
Oracle's in_char function lets you convert numbers into a text string, but it's an unusual facility to have as as built-in; there's no such facility (as far as I know) in MySQL but you can get around this easily enough within your controlling application - the Nums2Words module on the CPAN (in Perl), and a similar module on the PEAR (for PHP users) does all the hard work for you.
Here's a Perl example: use Nums2Words;When you run that, you get earth-wind-and-fire:~/jun07 grahamellis$ perl n2wA web search lead me to similar code in Java, and no doubt there's someting in the Cheeseshop if you're a Python programmer. Lesson to be learnt - look around before you re-write code! (written 2007-06-17 07:25:23) Associated topics are indexed under P219 - Perl - Libraries and ResourcesS157 - More MySQL Commands
Some other Articles
End of File on a Java BufferedReaderThe kind spirit of Melksham What proportion of our web traffic is robots? Trying things in Python Outputting numbers as words - MySQL with Perl or PHP A review of a week and a trip to Brugge Horses of Brugge Bathtub example Sur le Continent Commenting a Perl Regular Expression 1638 posts, page by page
Link to page ... 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21, 22, 23, 24, 25, 26, 27, 28, 29, 30, 31, 32, 33 at 50 posts per pageThis is a page archived from The Horse's Mouth at http://www.wellho.net/horse/ - the diary and writings of Graham Ellis. Every attempt was made to provide current information at the time the page was written, but things do move forward in our business - new software releases, price changes, new techniques. Please check back via our main site for current courses, prices, versions, etc - any mention of a price in "The Horse's Mouth" cannot be taken as an offer to supply at that price. Link to Ezine home page (for reading). Link to Blogging home page (to add comments). |
| ||||||||||
PH: 01144 1225 708225 • FAX: 01144 1225 707126 • EMAIL: info@wellho.net • WEB: http://www.wellho.net • SKYPE: wellho | |||||||||||