round off currency using regular exp

Multi tool use
Multi tool useThe name of the pictureThe name of the pictureThe name of the pictureClash Royale CLAN TAG#URR8PPP


round off currency using regular exp



I have multiple currency inputs i.e $1,869.96. I need to round up my currency into $1,870 as a whole number without any decimal places.



The regular expression I used is


"$"+ a.toFixed(0).replace(/(d)(?=(ddd)+(?!d))/g, "$1,");



Can anybody help me in modifying the existing one to round up the value as a whole number without decimal places.Thank you.





What do you mean. I don't get any decimal places using your regex.
– chevybow
yesterday





I don't get why aren't you using Math.round().
– Dez
yesterday


Math.round()





Do you really have commas in your number? You'll need to remove them before you use any math operations.
– Barmar
yesterday





You need to convert the string to float and then round it with Math.round
– Nerdvoso
yesterday




1 Answer
1



Try this:




function formatVal(a){
var c = '';
if(a.toString().indexOf('$') !== -1){
a = Math.round(Number(a.toString().replace(/[^0-9.-]+/g,"")));
if (isNaN(a)){
c=a;
}else {
c ="$"+a.toFixed(0).replace(/B(?=(d{3})+(?!d))/g, '$&,');
if(c == '$0'){ c = "";}
}
}
return c;
}

console.log(formatVal('$1,869.96'));
console.log(formatVal('$1,869'));
console.log(formatVal('sssss'));
console.log(formatVal(42));





toFixed(2) should be toFixed(0)
– Barmar
yesterday


toFixed(2)


toFixed(0)





Actually my mistake, I have updated
– Nerdvoso
yesterday





Changing from toFixed(2) to toFixed(0) seems to break comma insertion. Something like return '$' + number.toFixed(0).replace(/d(?=(d{3})+$)/g, '$&,'); seems to work...
– ggorlen
yesterday




toFixed(2)


toFixed(0)


return '$' + number.toFixed(0).replace(/d(?=(d{3})+$)/g, '$&,');





Nice, this equal return '$' + number.toFixed(0).replace(/B(?=(d{3})+(?!d))/g, '$&,');
– Nerdvoso
yesterday


return '$' + number.toFixed(0).replace(/B(?=(d{3})+(?!d))/g, '$&,');





Hey Nerdvoso, can you please modify the same in my existing code and see my rounding function. It will be a great help, Here is how my code looks like function formatVal(a){ a=parseInt(a); //return value based on numeric /non-numeric if (isNaN(a)){ c=a; }else { c ="$"+a.toFixed(0).replace(/(d)(?=(ddd)+(?!d))/g, "$1,"); } return c; }
– JainP
19 hours ago






By clicking "Post Your Answer", you acknowledge that you have read our updated terms of service, privacy policy and cookie policy, and that your continued use of the website is subject to these policies.

9xX4TlGXTS7,uYug,TOobeUN6 hfW2t0zPfN qdXi,uVSu4nhYbj,2zMp
-
Av3,6db,QHo6nkqaXc oc2dMrMGpqfL67G ZssCS5 zaxrUMwT4b7EyqQEHqchR

Popular posts from this blog

Keycloak server returning user_not_found error when user is already imported with LDAP

Keycloak server returning user_not_found error when user is already imported with LDAP I am currently running a keycloak server as a service in a kubernetes cluster. I can access it perfectly with the initial keycloak admin account and used it to setup a new realm using LDAP for User Federation. The connection and queries seem to work fine as a I can search for Users and they pop up with their correct username, first name, last name and e-mail so all seemed fine. When I then log out and try to log in with a normal user account that exists in the AD and has been imported I just find get the following error: WARN [org.keycloak.events] (default task-8) type=LOGIN_ERROR, realmId=master, clientId=security-admin-console, userId=null, ipAddress=<my ip>, error=user_not_found, auth_method=openid-connect, auth_type=code, redirect_uri=http://myserver.com/auth/admin/master/console/#/realms/MyRealm, code_id=a8ca7f06-dfec-4e6e-8f6b-74eb871f71da, username=myUser So it seems that in some way wh...
Read more

PHP parse/syntax errors; and how to solve them?

Image
PHP parse/syntax errors; and how to solve them? Everyone runs into syntax errors. Even experienced programmers make typos. For newcomers it's just part of the learning process. However, it's often easy to interpret error messages such as: PHP Parse error: syntax error, unexpected '{' in index.php on line 20 The unexpected symbol isn't always the real culprit. But the line number gives a rough idea where to start looking. Always look at the code context . The syntax mistake often hides in the mentioned or in previous code lines . Compare your code against syntax examples from the manual. While not every case matches the other. Yet there are some general steps to solve syntax mistakes . This references summarized the common pitfalls: Unexpected T_STRING Unexpected T_VARIABLE Unexpected '$varname' (T_VARIABLE) Unexpected T_CONSTANT_ENCAPSED_STRING Unexpected T_ENCAPSED_AND_WHITESPACE Unexpected $end Unexpected T_FUNCTION… Unexpected { { Unexpected } } Unexpe...
Read more

Using generate_series in ecto and passing a value

Using generate_series in ecto and passing a value I am trying to use generate_series in this query to get the number of sales in a time period even with the days that have no sales. I got it working with a hard-coded value but now I need to get all the sales since the contract was created. What I have so far: query = from( c in Contract, join: v in Voucher, on: v.contract_id == c.id, join: s in Sale, on: s.voucher_id == v.id and c.id == ^contract_id, right_join: day in fragment( "select generate_series(current_date - interval '60 day', current_date, '1 day')::date AS d" ), on: day.d == fragment("date(?)", s.date), group_by: day.d, select: %{ number_sales: count(s.id), total_value: sum(s.value), date: day.d }, order_by: [asc: day.d] ) Repo.all(query) |> Enum.map(fn entry -> Map.put(entry, :date, Date.from_erl!(entry.date)) end) With this query I get all the s...
Read more