Dear All,
I got a requirement from my client to convert currency in number format to a word format, for eg, if the Amount is Rs 100 then it should also be reflected as Rupees Hundred Only.
Can you please help!
Regards
Ashwani
Hi Dan
Thanks for suggestion! But with the bit help of the R community ("https://gist.githubusercontent.com/hack-r/22104543e2151519c41a8f0ce042b31c/raw/01731f3176b4ee471785639533d38eda4790ab77/numbers2words.r"), I have created my own workflow.
Regards, Ashwani
hi @Ashwani333
This would be fairly easy to implement using the Find Replace tool or Regex once you have a mapping table between symbols and text. The tricky part would be the variations in the text, i.e. 100€ vs €100
Dan
Hi Dan,
Thanks for your response and pardon me if my query was not clear, so its not only about the currency symbol but also converting the number to words.
Eg. 200 should be converted to 'Two Hundred'
219 should be converted to 'Two Hundred Nineteen'
10,333 should be converted to 'Ten Thousand Three hundred and Thirty Three'
Regards,Ashwani
