What is JotForm?
JotForm is a free online form builder which helps you create online forms without writing a single line of code. No sign-up required.

At JotForm, we want to make sure that you’re getting the online form builder help that you need. Our friendly customer support team is available 24/7.

We believe that if one user has a question, there could be more users who may have the same question. This is why many of our support forum threads are public and available to be searched and viewed. If you’d like help immediately, feel free to search for a similar question, or submit your question or concern.


  • Profile Image

    How can I change the Configurable list field delimiter ?

    Asked by bksullivan on November 05, 2015 at 11:02 PM

    The current delimiter is a comma, which is also a common element within the fields.  I need to export the records for subsequent processing, and it would greatly simplify my I could specify a chararacter or pattern to be used as a delimiter between all fields in the tows of the configurable list.

     

     

     

    configurable list configurable comma delimiter
  • Profile Image
    JotForm Support

    Answered by jonathan on November 06, 2015 at 01:30 AM

    Since the delimiter assigned was being done on the backend source code, there is no means for you to modify it using only the Form Builder.

    But what I think you can do to change the delimiter set on the resulting data, is to regenerate the data again using another application i.e. Excel or Spreadsheet.

    I am thinking like this:

    #1 Export/Download the Submission data by creating CSV Report

    user guide: http://www.jotform.com/help/103-How-to-create-a-CSV-Report

    #2 Open the CSV data in using Text Editor or Excel/Spreadsheet.

    #3 The data of Configurable List will be using comma delimiter. Using the Text Editor or Spreadsheet, you can manually change all the comma of Configurable list data to another sign you prefer (I usually use pipe sign "|" as it is seldom used)

    #4 Save the file after modification/updates.

    The CSV data and Configurable list data will now have a different delimiter sign.

    Hope this help. Let us know if there is more we can assist you with.