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
  • 306 views
N

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
    • rondev
    • Level 6 ●●●●●●
    • September 11, 2020

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

    Ron Dev (DM for any request. XM Technology Consultant, surveysolution.in)
    N
    • Niranjan
    • 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
    • rondev
    • 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

    Ron Dev (DM for any request. XM Technology Consultant, surveysolution.in)
    N
    • Niranjan
    • 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.

    2 Attachments
    rondev
    Level 6 ●●●●●●
    Forum|alt.badge.img+22
    • rondev
    • 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.

    Ron Dev (DM for any request. XM Technology Consultant, surveysolution.in)
      N
      • Niranjan
      • Author
      • October 7, 2020

      Thank you for the reply. It worked

      Terms & ConditionsAccessibility statement