[SalesForce] System.TypeException: Invalid decimal Error in apex

I did something like below : \p{sc} is the REGEX that matches all the currency

string i= '₪10,000';
Pattern dollarPattern = Pattern.compile('[\\p{Sc},]');
string s = dollarPattern.matcher(i).replaceAll('');
decimal d = decimal.valueof(s);
system.debug('####'+d);

I tried this with £,¥,₪ and $ and got 10000 as consistent output.

I looked at this post and got an idea on the Regex for currency : https://stackoverflow.com/questions/14169820/regular-expression-to-match-all-currency-symbols

Using pattern matcher I replaced all with ''.

To test with multiple currencies use http://currencies.typeit.org/ if you did not know how to type the currencies like me.

UPDATE:

Do you think this works ?

string i= '₪100,000,003';
if(i.contains(',')){
    i= i.replaceall(',','');}
Pattern dollarPattern = Pattern.compile('[\\p{Sc}]');
string s = dollarPattern.matcher(i).replaceAll('');
decimal d = decimal.valueof(s);
System.debug('####'+d);

Hope this helps.

I would surmise you are using Advanced Multi-Currency in your org

There are two parts in play here

• The decimal precision of the field itself (in your case 0) - this controls rounding done by SFDC when the currency is entered by the UI. See here for more details
• The precision for display of the currency in the Setup | Company |Manage Currencies - most likely 2 for USD in your org

If you really want to eliminate the display of the trailing decimals for this specific field you have some options

• Use a field of type Number and display the currency code separately. If this is an Opportunity, Quote, or Forecast, you will lose the advantages of dated exchange rates though
• Convert your page to a VF page with apex:detail and then use jQuery to suppress the trailing zeroes. Inline edit preserved
• Convert your page to a VF page and use a custom component for each currency outputField that suppresses trailing decimals based on some attribute passed tot he component. You will lose inline edit for the currency fields however