Missing data in csv import when backslash used in the text string containing double quotes

Hi Community, during csv file import from datalake I miss some data if in a column there is text string containing double quotes. Values with this quotes use backslash as an indicator. Example str...

Need Help

spinfuzer

2 years ago

Replace the backslash \ with a " then you can use the Csv.Document

Csv.Document(
    Text.Replace(
        Text.FromBinary(File.Contents("C:\path\to.csv"))
        , "\",""""),
    [Delimiter=",", Columns=2, Encoding=1252, QuoteStyle=QuoteStyle.Csv]
)

spinfuzer

Solution Sage

2 years ago

Replace the backslash \ with a " then you can use the Csv.Document

Csv.Document(
    Text.Replace(
        Text.FromBinary(File.Contents("C:\path\to.csv"))
        , "\",""""),
    [Delimiter=",", Columns=2, Encoding=1252, QuoteStyle=QuoteStyle.Csv]
)

Kamil_edv
New Member
2 years ago
Hello Spinfuzer, that's resolving my issue - thank you!

Forum Discussion

Missing data in csv import when backslash used in the text string containing double quotes