Export content of a textbox

I'm facing difficulties with exporting the contant to a CSV file.

As son as a nwe line /row/sentence is in the content, an "enter" of when eg a ; or : is used in the content, the export to the CSV file is not correct.

The content than breaks up to different parts of content.

And thus inpossible to get the data to a proper Excel file

HI SPABO,

The simplest solution is probably to use my CSV EXport v2 [GH] action which includes a setting to replace line-breaks.

Bob

Hi Bob,
As far I can see, the CSV file be downloaded onze people press the On Submit button,

But I like to do it in the BE of the website.

Any ideas on this???

Hi Bob,
I will use the option "Frontend view" in the formsmanager.
This will be fine for me.

Note:
Why not incororate this great to in the standard CSV Export as we find in the "Table Data Viewer" ???

Hi Bob,
Still struggling with the following:

I'm using a ; as delimiter and put this in , for teh Enclosure part I have ##none##

But, as soon as a ; in the textbox, the textoutput breaks into two cells in the csv...

Pls advise

Hi SPABO,

That sounds as though it is working correctly.The whole purpose of using enclosures is so that the lines don't break on; inside the strings.

Bob

Nope, as soon as any characters are used in the "enclosure" part AND in the textbox, it goes wrong...

Could be :, ; # @ ! ? etc..

Hi SPABO,

Do you still have the enclosure set to ##none##? If so please change it.

Bob

Hi Bob,
Change it back to ##none## does not help.

As soon a the textbox contains the same character as used in the "demiiter"part, it goes wrong

Hi SPABO,

Then I can only suggest that you choose a delimiter character that isn't included in the rest of the file text.

BOB