How can I change the Configurable list field delimiter ?

  • Profile Image
    bksullivan
    Asked 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.

     

     

     

  • Profile Image
    jonathan
    Answered 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.