Power Query Ignoring Quotation Characters ("") in Text Field

[xJake]

I need to read a csv file which has text fields that have quotations characters (") but when i upload the file to a dataflow it doesn´t appear anymore.

 

Anyone knows if theres a workaround for this?

Thanks in Advance

[MarkLaf · Accepted solution]

Tested with same csv. For some reason QuoteStyle.None doesn't get the desired result when specifying in Csv.Document but it seems to work with Splitter.SplitTextByDelimiter.

let
    Source = Web.Contents("<csv path>"),
    ToLines = Lines.FromBinary(Source),
    ToRows = List.Transform(ToLines, Splitter.SplitTextByDelimiter(",", QuoteStyle.None)),
    ToTable = Table.FromRows(ToRows)
in
    ToTable

[xJake]

Thanks that should work!, but still it is kinda weird that it doesn´t work with QuoteStyle.None, don´t know if it´s supposed to behave like that.

[xJake]