CSV Export – line breaks in row

  • canberraschwarz

    (@canberraschwarz)


    8 years, 4 months ago

    I need help to find a solution for a Problem, using the Export Function.
    After the setting of the filter, the exported csv file doesn’t show me the form entries in one row (one dataset). The problem is, that all line breaks within a filled form-text field, are exported into the csv. The csv file is unuseable for me.
    How can i fix the problem, to become one dataset in a row.
    php is updated to Version 5.6

    In an earlier Version of the exported csv-file i found “\r\n” for each line-break.

    Thank You
    Kind regards

Viewing 2 replies - 1 through 2 (of 2 total)
  • Plugin Author Takayuki Miyoshi

    (@takayukister)

    8 years, 4 months ago

    In fact, there are a variety of CSV formats used in the wild.

    Comma-separated values – Wikipedia

    So, no wonder that one format doesn’t work in some environment. Flamingo provides flamingo_csv_quotation and flamingo_csv_value_separator filter hooks to adjust the gap. They are found in flamingo/includes/csv.php.

    velsargo

    (@velsargo)

    8 years, 4 months ago

    Thanks for the answer.

    I change the delimiter character for this ( | ) and part of the problem is fixed.

    But, how I remove line-breaks in the CSV file?

    Is pissible that Flamingo export SCV file without line-breaks. ?

    Thanks for helpfull.

Viewing 2 replies - 1 through 2 (of 2 total)

The topic ‘CSV Export – line breaks in row’ is closed to new replies.