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.
Configurable List: Ability to change comma delimiter of data exported to ExcelAsked by agilo 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.
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:
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.
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?
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.