[SOLVED] Format a field as currency

Thanks, that would be great, if this improvement could be added soon!

Yes, I am on the way and found:

Currency numbers with optional dollar sign and thousand separators and optional 2 decimals ($1,000,00.00, 10000.12, 0.00):
^$?\-?([1-9]{1}[0-9]{0,2}(\,\d{3})*(\.\d{0,2})?|[1-9]{1}\d{0,}(\.\d{0,2})?|0(\.\d{0,2})?|(\.\d{1,2}))$|^\-?$?([1-9]{1}\d{0,2}(\,\d{3})*(\.\d{0,2})?|[1-9]{1}\d{0,}(\.\d{0,2})?|0(\.\d{0,2})?|(\.\d{1,2}))$|^\($?([1-9]{1}\d{0,2}(\,\d{3})*(\.\d{0,2})?|[1-9]{1}\d{0,}(\.\d{0,2})?|0(\.\d{0,2})?|(\.\d{1,2}))\)$

I would like to change it into (1.000.000, 10.000, 0)

If I add the string in the perl field in the back of the field with / at start and end it shows "false regular expression".

Or do you have a information, how I can quickly add the perl expression for (1.000.000, 10.000, 0) ?

Thanks, best regards
Eric

add:

at regexr.com I tried /^[1-9]{1,3}\.\d{3}\.\d{3}|[1-9]{1,3}\.\d{3}/ with success, but if I add this in CB, it doesn't work well:

OK should be
100.000.000
10.000.000
1.000.000
and so on
Not OK
100.00.000
etc.

This works in regexr.com , but in CB it is possible to add
435.43543543
2.324zzz

Sorry for having this problem, i hope, I make it right here, but so far I think at regexr.com my string is working.

Do you have a hint?

add

The same at /^[1-9]{1,3}\.\d{3},\d{2}/
here it should be ok with: 1.000,00, but it is also ok with 1.000.0000, or 1.000,92e4

The REGEXP needs to be PHP and JS valid if you want it to work in the browser and server side at the same time. I've ran your supplied REGEXP through RegexBuddy and checked it against PHP 7 and JS (Edge) with the following results.

^$?\-?([1-9]{1}[0-9]{0,2}(\,\d{3})*(\.\d{0,2})?|[1-9]{1}\d{0,}(\.\d{0,2})?|0(\.\d{0,2})?|(\.\d{1,2}))$|^\-?$?([1-9]{1}\d{0,2}(\,\d{3})*(\.\d{0,2})?|[1-9]{1}\d{0,}(\.\d{0,2})?|0(\.\d{0,2})?|(\.\d{1,2}))$|^\($?([1-9]{1}\d{0,2}(\,\d{3})*(\.\d{0,2})?|[1-9]{1}\d{0,}(\.\d{0,2})?|0(\.\d{0,2})?|(\.\d{1,2}))\)$

This errors with "Quantifiers can only be used after a token that can be repeated" for PHP and JS. It's not valid. Whatever language it was written for won't work in PHP or JS.

at regexr.com I tried /^[1-9]{1,3}\.\d{3}\.\d{3}|[1-9]{1,3}\.\d{3}/ with success, but if I add this in CB, it doesn't work well:

This will only match your following example in PHP and JS.

1.000.000

It does not match the following.

100.000.000
10.000.000
100.00.000

This works in regexr.com , but in CB it is possible to add
435.43543543
2.324zzz

That's because the REGEXP isn't strict enough. The below will prevent that.


You were missing the trailing $.

The same at /^[1-9]{1,3}\.\d{3},\d{2}/
here it should be ok with: 1.000,00, but it is also ok with 1.000.0000, or 1.000,92e4

Same issue as above. You're missing the trailing $. The below should work fine to prevent such issues.


Please keep in mind we do not assist with custom coding. CB just passes the supplied REGEXP through the respective language functions. I recommend looking into purchasing RegexBuddy where you can live test and validate your REGEXP against multiple languages and is what I've used for years. I find the free online tools to be inaccurate.

Thanks for your help! I bought the recommended software, found there an example and adjusted it, so here are now the right strings for

1) German Currency without Cents
1.000.000 =
2) German Currency with Cents
1.000.000,00 =
I am writing this here to have this info for all users. I hope, that all users share their code also here in this forum. That would help much.

Another idea is that Joomlapolis creates a collection of such strings and codes to help customers / users to more easily use of CB.

Thanks again for your good and quick help. I appreciate this much.