Forum Discussion

xJake's avatar
xJake
Frequent Visitor
1 year ago
Solved

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

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 worka...
Need Help
  • MarkLaf's avatar
    MarkLaf
    1 year ago

    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

     

     

     

MarkLaf's avatar
MarkLaf
Super User
1 year ago

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's avatar
xJake
Frequent Visitor
1 year ago

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.