Forum Discussion

Raph's avatar
Raph
Helper III
3 years ago
Solved

European number format

Hello    I have this measure in a card :    Text invoice = "Please send your invoice of " & FORMAT([Total royalties], "###,###.00") & " € to [email protected]". This measure displays the ...
Help
  • puneetvijwani's avatar
    puneetvijwani
    3 years ago

    Raph 
    Try below workaround measure and let me know if that works

    Text invoice =
    VAR USFormatted = FORMAT([Total royalties], "###,###.00")
    VAR Step1 = SUBSTITUTE(USFormatted, ",", "|") -- Replace ',' with a temporary character ('|')
    VAR Step2 = SUBSTITUTE(Step1, ".", ",") -- Replace '.' with ','
    VAR EuroFormatted = SUBSTITUTE(Step2, "|", ".") -- Replace the temporary character ('|') with '.'
    RETURN
        "Please send your invoice of " & EuroFormatted & " € to [email protected]"

    -------------------------------------------------------------------------------------------------------------------------------

     

    Good day, amigo! Have I provided the solution? If so, please let me know by adding the lovely, sweet "solution" tag to my post. And hey, if you're feeling very kind, give me a Kudos; after all, who doesn't enjoy a little digital gratitude?

    -------------------------------------------------------------------------------------------------------------------------------
puneetvijwani's avatar
puneetvijwani
Resolver IV
3 years ago

Raph 
Try below workaround measure and let me know if that works

Text invoice =
VAR USFormatted = FORMAT([Total royalties], "###,###.00")
VAR Step1 = SUBSTITUTE(USFormatted, ",", "|") -- Replace ',' with a temporary character ('|')
VAR Step2 = SUBSTITUTE(Step1, ".", ",") -- Replace '.' with ','
VAR EuroFormatted = SUBSTITUTE(Step2, "|", ".") -- Replace the temporary character ('|') with '.'
RETURN
    "Please send your invoice of " & EuroFormatted & " € to [email protected]"

-------------------------------------------------------------------------------------------------------------------------------

 

Good day, amigo! Have I provided the solution? If so, please let me know by adding the lovely, sweet "solution" tag to my post. And hey, if you're feeling very kind, give me a Kudos; after all, who doesn't enjoy a little digital gratitude?

-------------------------------------------------------------------------------------------------------------------------------
  • Raph's avatar
    Raph
    Helper III
    3 years ago

    Thank you very much, puneetvijwani  !

    It's smart and it works.

    Raphaël