View topic - How to add commas to big numbers for separating thousandths? • AutoHotkey Community

View unanswered posts | View active topics

Board index » AutoHotkey » Support

All times are UTC [ DST ]

How to add commas to big numbers for separating thousandths?

Page 1 of 1

[ 5 posts ]

Print view | E-mail friend

Previous topic | Next topic

Author

Message

EveOnline001

Post subject: How to add commas to big numbers for separating thousandths?

Posted: April 25th, 2009, 9:16 pm

Joined: March 23rd, 2009, 12:27 pm
Posts: 27

I have: 8500250

I want: 8,500,250

How?

Thanks

Top

Guest

Post subject:

Posted: April 26th, 2009, 1:23 am

in the manual, look at stringright and stringtrimright.

Top

animeaime

Post subject:

Posted: April 26th, 2009, 1:50 am

Joined: November 4th, 2008, 9:23 am
Posts: 1045

You can use this RegEx - works for both integer and float values.

Code:

value := "8500250"
value := RegExReplace(value, "(\d)(?=(?:\d{3})+(?:\.|$))", "$1,")

;outputs 8,500,250
MsgBox, % value


value := "8500250.123"
value := RegExReplace(value, "(\d)(?=(?:\d{3})+(?:\.|$))", "$1,")

;outputs 8,500,250.123
MsgBox, % value

_________________
As always, if you have any further questions, don't hesitate to ask.

Add OOP to your scripts via the Class Library. Check out my scripts.

Top

Guest

Post subject:

Posted: April 26th, 2009, 5:37 am

Here are two links that show how to do it.
1st using regex (by Laszlo)http://www.autohotkey.com/forum/viewtopic.php?t=29596#184296

2nd using winapi (by SKAN) - it does it the same way windows does http://www.autohotkey.com/forum/topic35545.html#219023

Top

[VxE]

Post subject:

Posted: April 26th, 2009, 10:22 am

Joined: October 7th, 2006, 8:45 am
Posts: 3329
Location: Simi Valley, CA

And here's a normal AHK way to add commas to a number.

Code:

AddCommas(n)
{
   StringSplit, d, n, .
   Loop, % StrLen(d1)
      x := SubStr(d1, 1-A_Index, 1), c := x . (A_Index>1 && !Mod(A_Index-1,3) ? "," : "") . c
   return c . (d0=2 ? "." d2 : "")
}

_________________
Ternary (a ? b : c) guide TSV Table Manipulation Library
Post code inside [code][/code] tags!

Top

Page 1 of 1

[ 5 posts ]

Board index » AutoHotkey » Support

All times are UTC [ DST ]

Who is online

Users browsing this forum: batto, BrandonHotkey, G. Sperotto, gamax92, Google Feedfetcher, Miguel, notsoobvious, rbrtryn and 69 guests

You can post new topics in this forum
You can reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum