How to deal with multiple quotes when loading CSV in power query?

Question

How can I deal with multiple quotes while loading CSV in Power query,How can I do that?

Answer 1

Use the following measures:

let
    Source = Csv.Document(File.Contents("filepath\file.csv"),[Delimiter="#(tab)"]),
    ReplaceQuotes = Table.ReplaceValue(Source,"""""","""",Replacer.ReplaceText,{"Column1"}),
    SplitIntoColumns = Table.SplitColumn(ReplaceQuotes, "Column1", Splitter.SplitTextByDelimiter(",", QuoteStyle.Csv)),
    #"Promoted Headers" = Table.PromoteHeaders(SplitIntoColumns, [PromoteAllScalars=true])
in
    #"Promoted Headers"

If u want to learn the tool in-depth, then come to us and sign up for this Power BI Certification