Is it possible to change delimiter in exports of multiple-choice lists?

  • Profile Image
    jfleischauer_wesley
    Asked on September 20, 2017 at 12:07 PM

    Is there any way to change the delimiter of answers in multiple-choice fields such as checkboxes? A system I frequently import to requires multiple selections be separated by a |, where as JotForm only seems to do ;

  • Profile Image
    Nik_C
    Answered on September 20, 2017 at 01:09 PM

    I will have to check this with our backend team if it is possible to do such change.

    But before that, could you please let us know are you using the CSV as an export file?

    Also, maybe a substitute option in Excel could work since you could replace ; with |.

    We'll wait for your response.

    Thank you!

  • Profile Image
    jfleischauer_wesley
    Answered on September 20, 2017 at 11:43 PM
    That’s correct, I’m trying to export as a CSV.
    As far as the Excel option, that does work but just adds an extra step to
    the process I’d like to avoid.
    --
    *Rev. John Fleischauer*
    *Executive Pastor*
    *Bama Wesley*
    john@bamawesley.org
    (256) 606-1388
    www.bamawesley.org
    To schedule a meeting, please visit
    www.bamawesley.org/administration-appointment
    ...
  • Profile Image
    jonathan
    Answered on September 21, 2017 at 12:05 AM

    Thank you for providing us with more details about using the Excel method.

    As mentioned already by our colleague Nik_C, the option to change the delimiter for multiple entry field data is not yet possible/available when downloading submission data to CSV file format.

    I will submit a ticket report to our higher team support and inquire if they have suggestion/workaround that can address your requirement.

    We will notify you here for any updates when available.


    Best