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 workaround for this?

 

Thanks in Advance

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

     

     

     

3 Replies

  • 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.