Remove double quotes from column value in exported csv

  • Resolved László

    (@erdoslaszlo)


    9 months, 2 weeks ago

    Dear Support,

    I would like to remove the double quotes from the column values in the exported csv file .

    Let me show you in an example:

    I have this:

    “column1″;”column2″;”column3”
    “value1″;”value2″;”value3”

    I want to this

    column1;column2;column3
    value1;value2;value3

    Thank you in advance for your help.

    Br, Laszlo

Viewing 2 replies - 1 through 2 (of 2 total)
  • Plugin Author Doeke Norg

    (@doekenorg)

    Hy @erdoslaszlo,

    You can remove the enclosure by adding the following snippet to your theme’s functions.php or using a snippet plugin:

    add_filter( 'gfexcel_renderer_csv_enclosure', '__return_null' );

    However, please be careful with this; as any other comma’s that do end up in the output will be seen as delimiters; making for weird output.

    To change the delimiter you can use the gfexcel_renderer_csv_delimiter-hook. To change it to a semi-colon for example, you would need the following code:

    add_filter( 'gfexcel_renderer_csv_delimiter', function() { return ';'; } );

    I hope this helps you out.

    Kind regards,

    Doeke

    Thread Starter László

    (@erdoslaszlo)

    Hi Doeke

    I greatly appreciate your quick help.

    It’s working perfectly and I just realized today your reply for my topic 2 years before…. Sorry somehow I forgot to react to it, but it was also fine ??

    Have a great weekend!
    Br, Laszlo

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘Remove double quotes from column value in exported csv’ is closed to new replies.