How can I change the Configurable list field delimiter ?

  • bksullivan
    Asked on November 5, 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.

     

     

     

  • jonathan
    Replied on November 6, 2015 at 1: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.