</br> tag in CSV file

Hi, in the CSV file, the list of items selected by a "checkbox group" appears separated by the </br> tag.
Is it possible to export this data separated for example by comma, but without the </br> tag?

Thanks for your help

Hello NuovaFolati,

The values of checkbox groups are stored comma-separated in the database and I don't know that this is changed anywhere in the CSV export.
So the br tags cannot be the value separators.

Can you provide me with an excerpt from the export file where the br tags can be seen?

Kind regards, Ingmar

I send you a jpg file because CSV file is not allowed, tell me if there is another method to send you CSV file.

Hello NuovaFolati,

the image shows the export file opened in Excel.
How Excel displays a CSV file exactly depends on the configuration in Excel for the specific CSV file.
This usually happens when you open the file in Excel.
However, it is also possible to change the settings in Excel for the file that has already been opened.
Excel does not show what the export file looks like exactly, but rather how Excel interprets the export file.

But first we're talking about the original text file in CSV format, as generated by Visforms' CSV export.
To do this, you have to open the export file in a text editor and look at the lines.

There are now 2 alternative options for you.

1. Open the export file in a simple text editor.
Copy some example lines from the file.
Simply paste the text directly into your post.

2. Upload the export file to your web server so that it can be opened in a browser with a direct link.
Copy the link to the file into your post.

Kind regards, Ingmar

Hello NuovaFolati,

Here is the content of a just exported CSV file with the selected data separator 'Semicolon':


The specific data separator can be set:
Form configuration, tab 'Separator', options 'Comma' and 'Semicolon'.

The field names are separated by semicolons in the first line.
Then come the data lines, in which the data is separated by semicolons.
There are 4 fields included with the following types in the following order:
- Number,
- text,
- first checkbox group,
- second checkbox group.

The selected options of a checkbox group are separated by commas:


Data separator 'Semicolon' is best suited for importing into Excel.
Without making any further changes to the configuration in Excel, the file above opens as follows:
vi-solutions.de/forum-uploads/csv-export_excel-view.png

HTML-tags, especially a br-tag, are not involved here.
However, HTML-tags can certainly appear in the field data.

Kind regards, Ingmar

sorry, see my next message