Formatting Embedded Data with comma separators?
There is an embedded data that I am outputting in a Text/Graphic box and in the question. For ease of reading, I would like to format this as a currency - or at the very least with thousand comma separators.
What would be the best way of handling this? I've looked around and couldn't find any code samples on this (most of the code samples involved formatting input fields, not embedded data).
```
<span id="mynumber">mynumber</span>
```
Use JS to format the number and replace the span contents:
```
Qualtrics.SurveyEngine.addOnload(function() {
jQuery("#mynumber").text("$"+parseFloat("${e://Field/mynumber}").toFixed(2).toLocaleString());
});
```
bansalpeeyush29: That's a good point - I had issues at first since this suggestion wouldn't work at all with a CSV - but then I realized Qualtrics uses TSV for importing as well.
TomG
Found this and loved your coding...BUT, I get the $ and the Decimal point, but not the comma? What am I missing?
https://community.qualtrics.com/XMcommunity/discussion/comment/38803#Comment_38803It depends on the browser and the default locale. See: https://developer.mozilla.org/en-US/docs/Web/JavaScript/Reference/Global_Objects/Number/toLocaleString
TomG Sorry, I went to the article, but I'm still perplexed. I couldn't decipher why I didn't get a comma? I'm in the US, using English as my browser language.
![10 Comments Badge](https://uploads-us-west-2.insided.com/qualtrics-us/attachment/68fc4acc-55e4-4fe9-b7ff-461aaad26bc8_thumb.png)
I think the "toFixed(2)" in the code was making it do decimals instead of commas. I tweaked to this and it worked:
Qualtrics.SurveyEngine.addOnload(function() {
jQuery("#number").text("$"+parseFloat("${e://Field/NameofField}")
.toLocaleString("en-US"));
});
Leave a Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.