Text formatting support

[Ruben_Cornil]

I get a value from Stripe and I need to send this value to Salesforce.
Sounds easy. but im new to Make.com.

This situation im stuck on is because Stripe return me a value without a , or . seperator.
So an example of Stripe’s response is:
224233
OR
72356

Now for the Salesforce API I need to parse these example values correcly to this format.
2242,33
OR
723,56

I Javascript I would be able to do this in no time. But which function in make can help me solve my problem. Thanks!

[samliew]

You can use the built-in function formatNumber

e.g.:

{{formatNumber(224233 / 100; 2; ","; emptystring)}}

Output

For more information, see the function documentation in the Help Center.

Here are some useful links and guides you can use to learn more on how to use the Make platform, apps, and app modules. I found these useful when I was learning Make, and hope they might benefit you too —

General

• Help Center | Tutorials
• Make Academy – learn Make and get your certificate
• Discord Server – join us in live chat for fans of Make!

Help Center Basics

• Mapping – What is mapping? What can I map?
• Mapping with arrays – How to map items in an array
• Aggregate an array for mapping complex fields
• Tokens for parseDate | Tokens for formatDate
• HTTP modules – Make a request, Get (download) a file
• Webhooks – Error Handling, Responding to webhooks

Articles & Videos

• Router Magic Formula - YouTube
• Error Handlers in Make - YouTube playlist
• Getting started with OpenAI
• How to use Regex in Make

samliew – request private consultation

Join the unofficial Make Discord server to chat with other makers!