CsvStyle.QuoteAlways

CsvStyle.QuoteAlways (1) is an enumeration that specifies the significance of quotes in Csv documents. It is a member of the CsvStyle.Type and specifies that quotes in a field are always significant regardless of where they appear.

Examples

Imagine a CSV file that looks as follows:

Consider you have imported that file in a step called Source. You can use CsvStyle.QuoteAlways in the Csv.Document function.

In this example a comma is used as separator. And as the above results shows, when you provide a text after a space, Power Query ignores the space. This behavior is different from how CsvStyle.QuoteAfterDelimiter treats spaces in text.

To see the entire code in action you can paste below in the advanced editor:

let
    Source = Binary.FromText( "SSwid2FudCINClUsICJ3YW50Ig==" ),
    MyCSV = 
        Csv.Document( 
            Source, 
            [ CsvStyle = CsvStyle.QuoteAlways ]
        )
in
    MyCSV

Related articles

Learn more about CsvStyle.QuoteAlways in the following articles:

• An In-Depth Look At The Csv.Document M Function
  The article presents a comprehensive examination of the Csv.Document M function. Topics covered include parameters such as Source, Delimiter, Encoding, Columns, QuoteStyle, CsvStyle, and more. » Read more

Related enumerations

Other related enumerations are:

• CsvStyle.QuoteAfterDelimiter

Applies to

Here’s a list of functions that work with CsvStyle.Type:

• Csv.Document

Contribute » | Contributors: Rick de Groot