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.
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
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
Other related enumerations are:
Here’s a list of functions that work with CsvStyle.Type: