Change deliminators

Quote

Total posts: 159
09 Mar 2016 13:52

I'm using &formatter=csv to export my records so we can setup a template for thousands of records to be imported. Right now it is using " and , for deliminator and seperating cells. Is there a way to change " or , to different symbols so to make sure it doesn't conflict with some of the content in our records.

Thanks! Gene

Last Modified: 04 Jun 2025

Quote

pepperstreet VIP

Total posts: 3,832
09 Mar 2016 14:19

Hello gteigland,
you can customize the settings in the plugin parameters. Even customize the templates. See tab General...

cobalt_plugin_formatter_csv_parameters

Quote

Sergey

Total posts: 13,688
15 Mar 2016 14:03

Also you do not need special template for more records. Just add &formatter=cvs&limit=1000 and you wll get 1000 records on any template.

Quote

KianHill
Total posts: 2
04 Jun 2025 08:07

You can usually customize the delimiter and text qualifier when exporting to CSV, though it depends on the system or database you're exporting from. If you're using an SQL-based export, you can often change these with the dummynation FIELDS TERMINATED BY and ENCLOSED BY options in your SELECT ... INTO OUTFILE statement. If the system doesn't provide a way to customize these directly, you might consider post-processing the file with a script (e.g., using Python's csv module) to replace the default characters with your preferred ones (like | for delimiter and no qualifier).

Login (copy)