Sawtooth Software: The Survey Software of Choice

Add Thousands Separator to Numeric Input

I would like to add a thousands separator to a numeric field as people type in an answer.

In SSI Web this can be done with some custom JavaScript, but there are couple of tricky aspects to implementing it. The first is that numeric questions cannot save a number containing commas—only numbers are allowed. So the question will need to be a text question. Another thing to consider is that inserted commas will get saved to the database, which may make data processing/analysis trickier if a number is needed or expected.

To be safe, this example uses a free format question that adds commas to input and saves two answers: one with commas and one without commas.

To begin, create a free format question and add two variables: a text variable and a numeric hidden variable. (Note: Numeric fields are limited to 999999999 (nine nines), so if more digits are need then make the hidden variable text instead of numeric) Place the required HTML on the page for the variables to display and save correctly. An easy way to make sure the HTML is correct is to make SSI Web to it. Click the pencil icon next to the HTML box on the Variables/Question HTML tab of the free format question to bring up the text editor. Click the hammer and wrench icon at the top of the page and select the variable you want to insert.

Now the JavaScript. Click the Advanced button from the free format question and place the following JavaScript in the HTML <head> tab.

<script type="text/javascript">
$(document).ready(function() {
  var textbox = '#ThousandSeperator_commas';
  var hidden = '#ThousandSeperator_num';
  $(textbox).keyup(function () {
  var num = $(textbox).val();
    var comma = /,/g;
    num = num.replace(comma,'');
    $(hidden).val(num);
    var numCommas = addCommas(num);
    $(textbox).val(numCommas);
  });
});

function addCommas(nStr) {
  nStr += '';
  var comma = /,/g;
  nStr = nStr.replace(comma,'');
  x = nStr.split('.');
  x1 = x[0];
  x2 = x.length > 1 ? '.' + x[1] : '';
  var rgx = /(\d+)(\d{3})/;
  while (rgx.test(x1)) {
    x1 = x1.replace(rgx, '$1' + ',' + '$2');
  }
  return x1 + x2;
}
</script>

Explanation of code

  1. Tells the browser to interpret everything that follows this line as JavaScript code.
  2. Contains a jQuery anonymous function that run the code once all of the content on the page has been loaded and the document is ready for further interaction.
  3. Saves the name of the text free format variable to a JavaScript variable called textbox. jQuery will use this to manipulate the text typed into the input box. In the above example the name of the free format question is ThousandSeparator and the name of the text free format variable is ThousandSeperator_commas. This name will need to change to whatever free format variable name the current study is using.
  4. Does the same thing as Line 3, but for the free format hidden variable. #ThousandSeperator_num will also need to change to match whatever is in the current study (the format is: #QuestionName_VariableName).
  5. Will make sure that lines 6 through 11 are run every time a number is typed into the text input field.
  6. Grabs the current value of the text input box and saves it to a variable called num.
  7. Sets up a regular expression that will find commas in the number pulled from the text input box.
  8. Removes any commas currently in the number. Without doing this 1,000 becomes 1,0,000 instead of 10,000 when a fourth zero is entered.
  9. Saves the number to the hidden variable.
  10. Adds commas back in to the number.
  11. Puts the number, containing thousands separators in the correct places, back in the text input box.
  12. Ends the function started in line 5.
  13. Ends the function started in line 2.
  14. Blank line for readability.
  15. This is the function that inserts commas into a number.

Note: If only a number with commas needs to be stored in respondent data than this can be done with just a text question instead of a free format question. If that is the case then textbox will be equal to the name of the question, and lines 4, 7, 8, and 9 (dealing with the hidden free format variable) can be deleted.

Sawtooth Software

6:30 AM to 5:30 PM Mountain Time
(GMT-6; GMT-7 Autumn/Winter)
Monday through Friday

Phone: +1 801 477 4700
Fax: +1 801 434 5493
Email: support@sawtoothsoftware.com

We are open!

SKIM Software

9:00 AM to 5:30 PM Central European
(GMT+2; GMT+1 Autumn/Winter)
Monday through Friday

Phone: +31 10 282 3500
Fax: +31 10 282 3560
Email: software@skimgroup.com
Online: www.skimgroup.com

Lighthouse Studio

Lighthouse Studio is our flagship software for producing and analyzing online and offline surveys. It contains modules for general interviewing, choice-based conjoint, adaptive choice-based conjoint, adaptive choice analysis, choice-value analysis, and maxdiff exercises.

Try Lighthouse Studio

  Buy Lighthouse Studio