PLEASE NOTE: These forums are no longer utilized and are provided as an archive for informational purposes only. All support issues will be handled via email using our support ticket system. For more detailed information on this change, please see this blog post.

Problem with CSV export and comma

Gravity Support Forums » Plugin Support » Gravity Forms

  1. jopweb
    Member

    Hi,

    we're using Gravity Forms for a contest: users are asked to send a short text. Since in the short text that we receive there are many commas, when we export the CSV file, the commas in the short text are seen by XL as columns separators, so we get a very messy XL file. Is there any solution for this: as an example, is it possible to ask Gravity Forms to use a field separation different from the comma?

    Thanks for help

    Paolo

    Posted 12 years ago on Thursday January 12, 2012 | Permalink

  2. steph219
    Member

    Hi Paolo

    could you solve the issue with fields containing commas?

    I have the same problem when exporting a CSV file with entries.

    thanks for any hints

    Posted 12 years ago on Thursday January 26, 2012 | Permalink

  3. jopweb
    Member

    Hi Steph, No I have not. I'm still looking for a solution.
    Very strange that nobody has given support on this issue.
    I'm still in need of help on this.

    Paolo

    Posted 12 years ago on Friday January 27, 2012 | Permalink

  4. frc2
    Member

    There is a filter to change the field separator. Here is the code to replace the comma by a semicolon:

    add_filter( 'gform_export_separator', 'my_gform_export_separator', 10, 2);
    function my_gform_export_separator($separator, $formId) {
    return ";";
    }

    Posted 12 years ago on Wednesday April 18, 2012 | Permalink