Forum Discussion
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...
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
