Display issue of data with a "double" type | Community
Skip to main content
A
Arthur_LEBRIS
September 27, 2023
Solved

Display issue of data with a "double" type

  • September 27, 2023
  • 3 replies
  • 1609 views

Hello,

I'm working for a french retailer. We have an adobe console installed in french.

We've got some display issue with a "double" type.

 

Here's how it's declared in the schema : 

<attribute desc="Montant Agregé de la Cagnotte" label="Montant Agregé de la Cagnotte"
               name="MontantAggCagnotte" sqlname="montantAggCagnotte" type="double"/>

 When I look at the data inside Adobe Campaign, the separator is a comma (because the console is installed in french).

But when I send a email with that field as a personalisation, it's displayed with a point :

 

From what i've seen in the community, it appears that the data stored is the one from the server. Only the display of it is affected within Adobe Campaign. 

If an attribute Data type defined as ""double" in ... - Adobe Experience League Community - 160591

Résolu : Floating data type - Adobe Experience League Community - 328690

 

Our server is installed in english, that might explain the point, but we would like to display a comma within our HTML sent.

Is there a way to easily display a comma without using JS in the delivery ?

 

Thanks !

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by Marcel_Szimonisz

Hello @arthur_lebris ,

it could be also database settings. As what UI shows you can be saved differenlty in database.

 

 

function numberWithCommas(x) { return x.toString().replace(".", ","); }

 

 

Or you can find any other locale function or library that is working with JS ES5

Marcel Szimonisz

3 replies

Marcel_Szimonisz
Community Advisor
Marcel_SzimoniszCommunity AdvisorAccepted solution
Community Advisor
September 27, 2023

Hello @arthur_lebris ,

it could be also database settings. As what UI shows you can be saved differenlty in database.

 

 

function numberWithCommas(x) { return x.toString().replace(".", ","); }

 

 

Or you can find any other locale function or library that is working with JS ES5

Marcel Szimonisz

    DavidKangni
    Community Advisor
    DavidKangniCommunity Advisor
    Community Advisor
    September 27, 2023

    Hi @arthur_lebris 

     

    First option and maybe easiest is to create a variable in your workflow converting MontantAggCagnotte to string (cons is you can have more than 2 digits after the ',' but you can truncate it)

     

    Second option is more adcanced as you have to use a javascript library (ootb one dataTypes.js or custom one currency.js)

     

    Thanks,

    David

    David Kangni
    A
    Arthur_LEBRISAuthor
    October 11, 2023

    Hi @davidkangni,

    I've looked a little bit about your second option. It may be what we are looking for.

    Do you have any documentation about it ?

    Thanks,

    Arthur

    Sukrity_Wadhwa
    Community Manager
    Sukrity_WadhwaCommunity Manager
    Community Manager
    October 5, 2023

    Hi @arthur_lebris,

    Were you able to resolve this query with the help of the given solutions or do you still need more help here? Do let us know. In case the given solutions were helpful, then kindly choose the one that helped you the most as the 'Correct Reply'.

    Thanks!

    Sukrity Wadhwa
    A
    Arthur_LEBRISAuthor
    October 5, 2023

    Hi @sukrity_wadhwa,

    I'm trying to evaluate the given solutions but at first sight it doesn't seem to be what i need.

     

    I'm discussing about the solution presented by @marcel_szimonisz with my data officer.

     

    The solution presented (create a variable in your workflow) by @davidkangni will work, but it will not be easy to industrialize it in many workflows. It needs a specific work for every data with a "double type", it would be easier if I just can use data from the schema without modifying it.

     

    Arthur

    Sukrity_Wadhwa
    Community Manager
    Sukrity_WadhwaCommunity Manager
    Community Manager
    October 9, 2023

    Hi @arthur_lebris,

    Sure! Thanks for sharing this update from your end. Let us know if @marcel_szimonisz's solution works for you. 

    Regards,

    Sukrity Wadhwa
    Terms & ConditionsAccessibility statement

    Loading footer...