How to convert double to currency format

xiaomieya · October 6, 2019, 12:26am

Client SDK (REST / Android / Objective-C / Swift / JS )

Codeless

Application ID

5B75038B-CF13-4B09-AB38-4BCF5E7002BC

hello team backendless,
iam use dopsource
how to convert double to currency format? Thanks

vladimir-upirov · October 6, 2019, 11:07am

Hello @xiaomieya

please provide example values, what you’ve got and what you want to get at the end

Regards, Vlad

xiaomieya · October 6, 2019, 4:24pm

hello @vladimir-upirov thanks for your respone.

I have a data table with double data types. like this.

when api call on dropsource the result is 2000.0 I want to get is 2,000 .

dropsource does not support currency format. DropSource technical support recommends doing this from the server side. can you help me?

Thanks @vladimir-upirov

mark-piller · October 6, 2019, 4:40pm

When you put comma to separate digits in a number, it technically becomes a string. So while 2000 is an Double, "2,000" is already a string. To do this, you’d need to write logic either in codeless or on the Dropsource side to format the value that way.

xiaomieya · October 6, 2019, 4:46pm

hello @mark-piller

can you give me an example of how to convert double to string using codeless? thanks

mark-piller · October 7, 2019, 12:12am

Hi Xia,

Unfortunately, I cannot, this would be something our professional services team can do. This would be rather straight-forward - convert the number to a string and put a comma every 3 characters.

Mark

vladimir-upirov · October 7, 2019, 7:34am

try to create a Codeless Custom Function:

and as result you will have the following:

0 => "$ 0"
2000 => "$ 2,000"
12330 => "$ 12,330"
89033 => "$ 89,033"
780 => "$ 780"
78 => "$ 78"
123456789 => "$ 123,456,789"

Regards, Vlad

vladimir-upirov · October 7, 2019, 10:49am

oops, just noticed, there is a bug, the first char comes twice and there is no the last char in the result, let me fix

vladimir-upirov · October 7, 2019, 10:58am

I’ve updated screen with logic and results

xiaomieya · October 7, 2019, 11:57pm

thanks @vladimir-upirov and @mark-piller its work.

KLoic · February 17, 2021, 5:14pm

Hi @vladimir-upirov, since this post is kind of old. Is this function above still the fastest way to format an INT into currency today? Please advise.

Thank you.

KLoic · February 23, 2021, 12:14am

Hi @vladimir-upirov , hope you are well. Did you get the chance to look at my previous question above? Thanks

vladimir-upirov · February 23, 2021, 8:04am

Hello @KLoic

Sorry for the delay

I’m not sure about the speed but using RegExp it definitely looks simpler

(\d)(?=(\d{3})+(?!\d))

You can try it out at the following link https://backendlessappcontent.com/7E25B48A-05FA-0B5D-FFAE-63CC0AC26C00/E9920D04-8F81-D6EC-FFBB-4D4D78486100/files/ui-builder/containers/currency/index.html?page=landing

Regards, Vlad

KLoic · February 23, 2021, 8:46am

Thank you @vladimir-upirov . I appreciate your help!

Michel_Loriaux · August 6, 2021, 5:37pm

Hi @vladimir-upirov ,

Can you show me a RegExp codeless block for changing a string from 1000 to € 1.000,00?

Jorg_Beyer · September 9, 2022, 8:53am

@KLoic @Michel_Loriaux
Maybe there is even an easier way to solve this, but here is my solution with a Javascript Snippet in a Custom Function.

And here is the Javascript in the Custom Code:

It is just covering one currency format, but it should be easy to add other formats as well.
Please let me know if there is an easier way. I found the RegEx solution to complicated in a multi-currency environment.