QuoteStyle.Csv

QuoteStyle.Csv (1) is an enumeration that specifies the quote style. It is a member of the QuoteStyle.Type and indicates that quote characters signify the start of a quoted string, with nested quotes indicated by two quote characters.

Examples

The Lines.FromText function supports the QuoteStyle type. You can clearly see its behavior when providing a text value that has a line-break within the double-quoted text.

//  Results in a single item in a list, including a linebreak
//  Returns: { "This is a ""string,#(lf)string""" }

= Lines.FromText( 
    "This is a ""string, 
in quotes""", 
     QuoteStyle.Csv  )

//  Results in a 2 items list
//  Returns: { "This is a ""string,", "string""" }

= Lines.FromText( 
    "This is a ""string, 
in quotes""", 
     QuoteStyle.None  )

Related articles

Learn more about QuoteStyle.Csv 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:

• QuoteStyle.None

Applies to

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

• Combiner.CombineTextByDelimiter
• Combiner.CombineTextByEachDelimiter
• Csv.Document
• Lines.FromBinary
• Lines.FromText
• Splitter.SplitTextByAnyDelimiter
• Splitter.SplitTextByDelimiter
• Splitter.SplitTextByEachDelimiter
• Splitter.SplitTextByWhitespace
• Table.CombineColumns

Contribute » | Contributors: Rick de Groot