Help with formating numbers with comma's

I can use some help. I am trying to make a function that lets you input a number (123456789.1234) and it will output the formatted number (123,456,789.1234).

I found some older post here about it and used them and made some updates to it. But I am running into a problem when it is running. it's seems to be some kind of rounding error.

in the cap i will post you will see. i made a loop that adds 10000.33 each loop. but it starts to output numbers with 8+ decimal places. and I am not sure why.

So if anyone can take a look and see what the problem is. That would be a great help to me.

I would like to try to make this a more universal function. so that you could call it with the raw number and it would update the the text string you want.

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

Or if you know a better way to format the number I'd like to hear about it.

Thanks for your help

Maxum

the extra digits in the decimals is just how computers handle precision. To fix that you will have to Round(NumInput*100) / 100 (or however many digits you want.

then you can format the number with one line by using RegexReplace...

set the textbox to: RegexReplace(str(NumInput),"\d{1,3}(?=(\d{3})+(?!\d))","g","$&,")

Edit: the only problem with the Regex code above is if there are more than 2 digits to the right of the decimal point, then commas will be inserted there as well.

In that case, you can use: RegexReplace(str(NumInput),"\d{1,3}(?=(\d{3})+(?=\.))","g","$&,")

but this version requires a decimal point, otherwise it wont work!

This would take some more work if you want to zero pad the decimals so there is a consistent number of digits after the decimal point.

Thanks for the help. I tried it out in this cap

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

I need to find out more about the RegexReplace command.

Thanks

AllanR You seem very comfartable with regex expressions. Point me to a place to learn them ?

99Instances2Go

I have played around with Regex a few times - and it does come in extremely handy in many situations...

but I really understand very little of the actual syntax or how to build an expression. I usually just google what I am looking for and then copy and paste.

the trick is usually adapting the code you find to work in C2. A google search for "regex format number" will find javascript code like this:

function formatNumber (num) {
    return num.toString().replace(/(\d)(?=(\d{3})+(?!\d))/g, "$&,")
}
[/code:dm8cb1vx]

to make that work with C2 you need to take the portion between the forward slashes to be the expression:  "(\d)(?=(\d{3})+(?!\d))"
(but don't include the forward slashes).
anything after the second forward slash are the flags (in this case just "g")
(which means global or look for all occurrences - which is the most common flag).
then the part at the end is the replace string ("$&,")
(in this case it means insert the matched string and insert a comma).

so you end up with an action in C2 like this:

Set text to RegexReplace( str(num), "(\d)(?=(\d{3})+(?!\d))", "g", "$&,")

That gives me a solid direction. TyvM.

Sweet, thank you. Worked great.