How do I round numbers to 1.1K, 2.5M, etc.?

I'm currently using the following to put commas in my numbers larger than 999:

RegexReplace(RapperDictionary.Get("RapFans") & "", "(\d)(?=(\d{3})+$)", "g", "$&,")

This is great, but in being a very novice student of Regular Expressions and programming in general, I'm trying to understand how I can flip what I have to make a number like 1123 turn into 1.1K. None of the tutorials I've read on Scirra.com or elsewhere really explain this, but attempt to explain RegEx as a whole system.

Obviously it's not just the number, but also the lettered value at the end of the string that needs to be dependent upon how many digits in the original string there are to properly kick out a K, M, B, etc.

Is this not a RegEx issue and perhaps something deeper like a Function?

something like this should work:

value is less than a million and equal to or greater than 1000 >>> set text: round(Variable1/100)/10&"K"

off hand i'm not sure how to switch between k, m, b, ect without another event for each.

I once did something similar. It used a function and an array to store abbreviation values. You can expand it as you like, the system will stop using abbreviation when there aren't any to represent the number with less than 3 digits and fallback to something like 324e75. Construct's expression editor can't handle large numbers so I had to get creative, you'll see what I'm talking about.

I also had to squeeze in an ExecJs somewhere so I could check for infinity, C2 simply lack this feature.

https://www.dropbox.com/s/ry1ry2wbxmycd ... .capx?dl=0

Thanks all. I think I'm going to go with celstrider 's recommendation; it seems the easiest for my system.

—

Check my answer in this thread:

what answer, and where the thread? XD

i need help too

Thanks all. I think I'm going to go with celstrider 's recommendation; it seems the easiest for my system.

Hi, how u do to show K, M etc?

Can u give me some light? or show me the way XD

> > —

> >

> > Check my answer in this thread:

>

> what answer, and where the thread? XD

> i need help too

Change to new forum most have removed the link.

Found it here: construct.net/en/forum/construct-2/how-do-i-18/how-do-i-add-letter-m-when-num-118349

Thank you =)