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.
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:
Source = Binary.FromText( "SSwid2FudCINClUsICJ3YW50Ig==" ),
[ CsvStyle = CsvStyle.QuoteAfterDelimiter ]
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
Other related enumerations are:
Here’s a list of functions that work with CsvStyle.Type: