How to pipe the number which is input as comma separated? | XM Community
Skip to main content
Solved

How to pipe the number which is input as comma separated?

  • September 10, 2020
  • 6 replies
  • 305 views

Hi i am having a problem with comma separated number input and use as a embedded data. For example a respondent inputs 1,352 in a text entry and i want to pipe it and display 1352/2 somewhere in the survey. How can i do that because if some one inputs 1,352 it will be string and the value will be zero. The text entry type is single choice with text entry and custom validation is should be greater than zero.

Best answer by rondev

https://www.qualtrics.com/community/discussion/comment/30231#Comment_30231Sorry for not implementing it and directly posting it, I too observed the same and it is expected to behave it like that as mentioned on support:
image.pngSo the only option I see is to use custom JS present here.

6 replies

rondev
Level 6 ●●●●●●
Forum|alt.badge.img+22
  • Level 6 ●●●●●●
  • September 11, 2020

Instead of custom validation use content validation -> content type "Numbers" -> and then set range.
image.png


  • Author
  • September 11, 2020

https://www.qualtrics.com/community/discussion/comment/30174#Comment_30174USE_Q.JPGI am sorry if i did not make myself clear.. The question is more like above with Multiple choice (single answer) with text entry in the selected choice. Then the above mentioned answer will not work


rondev
Level 6 ●●●●●●
Forum|alt.badge.img+22
  • Level 6 ●●●●●●
  • September 11, 2020

Follow the path shown in below image to set numerical validation and also keep the custom validation as greater than 0
image.png


  • Author
  • September 13, 2020

https://www.qualtrics.com/community/discussion/comment/30178#Comment_30178Thank you for the reply but with numerical validation too.. i am still able to input 1,000 (comma) and when i pipe this it becomes zero.


rondev
Level 6 ●●●●●●
Forum|alt.badge.img+22
  • Level 6 ●●●●●●
  • Answer
  • September 13, 2020

https://www.qualtrics.com/community/discussion/comment/30231#Comment_30231Sorry for not implementing it and directly posting it, I too observed the same and it is expected to behave it like that as mentioned on support:
image.pngSo the only option I see is to use custom JS present here.


  • Author
  • October 7, 2020

Thank you for the reply. It worked