I am doing some first-time international monetary stuff, and having some trouble figuring out how to process the numbers in CF.
The problem is that decimal points and thousands separators can come in two flavors: US: xxx,xxx.yy - or - Europe, SA: xxx.xxx,yy Note that decimals and commas can have reverse functions. Either one can come is as input: For example, I also get a thousands separator with no trailing "cents": xxx,xxx or xxx.xxx as well as xxx,xxx.yy ... What I want to do is to remove all thousands separators, remove the decimal point or comma, and remove the trailing "cents" if there are any. So xxx,xxx.yy or xxx.xxx,yy becomes xxxxxx Any ideas appreciated? Rick ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:352770 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
