Apex Code Development You need to sign in to do that
Don't have an account?
SAHG-SFDC Syntax error with Apex Number formatting - Regex
Hi,
I am trying to use REGEX in Apex for achieving to format a number with commas
Number stored as -->11111
Should look like --> 11,111
There is no scenario to use decimal, so need positive ineteger REGEX , I tried various combinations and always get the error while saving
Currently trying the option3 , It shows an error on saving "Invalid string Literal" or the '/' character is not allowed
How should be use / character?
I am trying to use REGEX in Apex for achieving to format a number with commas
Number stored as -->11111
Should look like --> 11,111
There is no scenario to use decimal, so need positive ineteger REGEX , I tried various combinations and always get the error while saving
string strHeader = String.valueOf(tiers.StartValue__c.intvalue());
string StrHeaderValue;
// First Option
//StrHeaderValue =strHeader.split('/'(?=(?:\d{3})+(?:'\.'|$))/g).join(',');
//Second Option
//StrHeaderValue =strHeader.split(('//')(?=(?:\d{3})+(?:('//.')|$))/g).join(',');
//Third Option
StrHeaderValue=strHeader.replace('/(\d)(?=(\d\d\d)+(?!\d))/g', '$1,');
//Fourth Option
//StrHeaderValue = strHeader.replace('//'('\\'d{3})(?=\d)'//'g, '$1,');
so.put(field, String.valueOf(tiers.StartValue__c.intvalue() + '+'));
so.put(field, StrHeaderValue );
Currently trying the option3 , It shows an error on saving "Invalid string Literal" or the '/' character is not allowed
How should be use / character?
With replaceAll ( instead of replace )
integer[] tiers = new integer[]{11,111,22111,222111,3222111,333222111}; string val1; string val2; for (integer tier:tiers) { val1 = String.valueOf(tier); val2 =val1.replaceAll('(\\d{3})??(\\d{3})??(\\d{3})$','$1,$2,$3').replace(',,',',').replaceAll('^,+',''); system.debug('test:'+val1+'='+val2); }Limit here: 999,999,999 (three groups).
With split, there is probably another solution.
Regards