CsvStyle.QuoteAfterDelimiter

CsvStyle.QuoteAfterDelimiter (0) 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 significant immediately following the delimiter.

Examples

Imagine a CSV file that looks as follows:

Consider you have imported that file in a step called Source. You can use CsvStyle.QuoteAfterDelimiter 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 treats it differently compared to when you don’t have a space after the delimiter. This behavior is different from how CsvStyle.QuoteAlways 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.QuoteAfterDelimiter ]
        )
in
    MyCSV

Related articles

Learn more about CsvStyle.QuoteAfterDelimiter 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.QuoteAlways

Applies to

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

• Csv.Document

Contribute » | Contributors: Rick de Groot