CsvStyle.QuoteAfterDelimiter

Updated on

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:

CSV data for CsvStyle Type

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

CsvStyle.QuoteAfterDelimiter-for-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.

CsvStyle.QuoteAlways for Csv.Document function

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

Learn more about CsvStyle.QuoteAfterDelimiter in the following articles:

Other related enumerations are:

Applies to

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

Contribute » | Contributors: Rick de Groot