Using the table element in TYPO3 11, and pasting a CSV file into the 'Show Table Code' box results in the table data anized in editable rows and columns.
However it ignores the "Text Enclosure" setting, which means if there is a comma within a cell "foo, bar" it breaks it into two cells and messes up the entire table in the backend.
(The frontend table displays correctly, unless the backend is edited which saves the incorrect formatting)
Is there a way I can force TYPO3 to treat the CSV data correctly in the backend?
Using the table element in TYPO3 11, and pasting a CSV file into the 'Show Table Code' box results in the table data anized in editable rows and columns.
However it ignores the "Text Enclosure" setting, which means if there is a comma within a cell "foo, bar" it breaks it into two cells and messes up the entire table in the backend.
(The frontend table displays correctly, unless the backend is edited which saves the incorrect formatting)
Is there a way I can force TYPO3 to treat the CSV data correctly in the backend?
Share Improve this question edited Feb 17 at 10:43 Peter Kraume 3,7772 gold badges25 silver badges43 bronze badges asked Feb 16 at 20:37 user500665user500665 1,3621 gold badge13 silver badges44 bronze badges1 Answer
Reset to default 0Did you choose the right settings in the table content element for text enclosure?
What I do most of the time is using the pipe as delimiter to avoid problems with the comma.