Newline handling

[lnicola]

I have this slightly cursed CSV which I've minimized to:

a,"\
\"official\"\
OSGeo"

Based on the other records, I'd expect this to be a single record with two columns, the second of which containing three lines. But csv interprets it as two records (the first one ends at \"official\"), one with two, one with a single column. Is this intended, and can it be tweaked?

[BurntSushi]

Please provide an MRE (minimal reproducible example).

[lnicola]

# Cargo.toml

[package]
name = "csv-test"
version = "0.1.0"
edition = "2024"

[dependencies]
csv = "1.3.1"

// main.rs

use std::error::Error;

fn main() -> Result<(), Box<dyn Error>> {
    let rdr = csv::ReaderBuilder::new()
        .has_headers(false)
        .flexible(true)
        .from_path("test.csv")?;
    for result in rdr.into_records() {
        let record = result?;
        println!("{:?}", record);
    }
    Ok(())
}

# test.csv

a,"official\"\
OSGeo"

Actual result:

StringRecord(["a", "\\\n\\official\\\"\\"])
StringRecord(["OSGeo\""])

Expected result:

Not sure, but whoever wrote this file (MariaDB) meant that to be a single record.

[BurntSushi]

That sort of escaping is non-standard. You need to opt into it. It's unclear why you aren't using ReaderBuilder::escape.

This why MREs are important when asking questions. I couldn't tell whether you were correctly setting the escape option or not.

[lnicola]

Thanks, I actually skimmed the docs and saw escape, but thought it was enabled by default.