Hello,
When exporting records from DB is it possible to change the csv delimiter: "," and "
This doesnt make sense to use "," where textfields are present.
Any recommendation regarding this?
Greetings
Hi mdma,
There's a Delimited box in the CSV Export action that lets you change the delimiter.
I have a beta version of a CSV Export [GH] action for CFv5 that will let you change the Enclosure character as well. Please PM me if you want to test it.
Note that the comma shouldn't be a problem in the text - un-escaped double quotes can be.
Bob
Hello Bob!
I need to change it in the connected database export...
the export of csv i dont need with every form-submission, only perhaps every 2 month...
btw if i should test your beta-action i can do that also.
Hi mdma,
I need to change it in the connected database export... Sorry, I don't know what you mean here?
To do occasional exports I set up a separate form with just a submit button and limit access to admins only. Link it to an admin menu and you are good to go. (You can also set it up so that it will only export 'new' records.)
Bob
1.)forms->connected tables->select the connected table
2.)Backup table
this csv is messy because of delimeters/enclosures when i open it in excel ...
your advice, is a very good idea, very usable and helpful, i will try that out...thank you!!
Hi mdma,
You need to remove any carriage returns and/or line-breaks from the data to get it to load cleanly in Excel. The CSV file needs to have one record per line.
Bob