Configurable List: Ability to change comma delimiter of data exported to Excel

  • Profile Image
    agilo
    Asked on June 30, 2016 at 07:15 AM

    We're using the configurable list to gather info from users. In a configurable list textarea a user might write text using commas. In the downloadable Excel or CSV-file this creates problems for other programs to split this field, because there is no way of telling what commas are field separators and what commas are included in the text.

    Is there a way to change the CSV-separator from comma to semicolon? Any other tricks?

    Commas marked red in enclosed image are the field separators.

  • Profile Image
    Boris
    Answered on June 30, 2016 at 08:42 AM

    I understand what you are referring to with the Excel output of responses from Configurable List widget. Since fields of the Configurable List widget are separated by a comma, if any of them also contain a comma, it confuses your software about where one field's answer ends and another begins.

    Essentially, entering data that contains commas, such as this:

    Results in Excel output such as this:

    Field One: This, is, text, in, field, one, Field Two: This, is, text, in, field. two

    Unfortunately, we do not have any ways for changing the delimiter of Configurable List data output in Excel to use some other delimiter, such as semicolon. I will forward this as a feature enhancement request to our developers, but we cannot give you any estimates on when or if such a feature will be implemented.

    As soon as such a feature becomes available, we will make sure to let you know through means of this support thread.

    If this is a critical functionality for you to have, and until such a time when this might be implemented for Excel output on our side, you may want to use our API to programmatically fetch data of your submissions:

    http://api.jotform.com/docs/

    Our API returns data of a Configurable List widget as a JSON string, so answers from each of the fields inside the Configurable List widget will be correctly separated for you to further process in your program.

    Thank you.

  • Profile Image
    derickdavis
    Answered on August 16, 2016 at 09:22 AM

    Can you include me on the solution to this too?  I have the need to change the delimiter value to something like "||" to prevent a data collision when separating it.   Is there a way to restrict the user from inputting a "comm" in the fields in the meantime?

  • Profile Image
    Kiran
    Answered on August 16, 2016 at 10:40 AM

    @derickdavis,

    With the response you posted here in this thread, you are now subscribed to the thread and you'll also be receiving any updates on this. At the moment, the feature is still in our wish list. We cannot provide any ETA at the moment for this feature implementation. However, if there is any update in this regard you'll be posted on this thread.

    Thank you!