Lines.FromBinary
Lines.FromBinary(binary as binary, optional quoteStyle as any, optional includeLineSeparators as nullable logical, optional encoding as nullable number) as list
Converts a binary value to a list of text values split at line breaks.
binary
: The binary value to convert to the list.quoteStyle
: Specifies how line breaks are handled. The value ofquoteStyle
can benull
. The default value is QuoteStyle.None.includeLineSeparators
: Specifies whether to include the line break characters in the text. The value ofincludeLineSeparators
can benull
. The default value isfalse
.encoding
: Specifies the text encoding of the binary value. The value ofencoding
can benull
. The default value is65001
(UTF-8).
If a record is specified for quoteStyle
(and includeLineSeparators
and encoding
are null
), the following record fields can be provided:
QuoteStyle
: Specifies how quoted line breaks are handled.- QuoteStyle.Csv: Quoted line breaks are treated as part of the data, not as the end of the current row.
- QuoteStyle.None: All line breaks are treated as the end of the current row, even when they occur inside a quoted value. This value is the default if the
CsvStyle
option isn't specified.
CsvStyle
: Specifies how quotes are handled. Should not be used withQuoteStyle.None
.- CsvStyle.QuoteAfterDelimiter: Quotes in a field are only significant immediately following the `Delimiter.
- CsvStyle.QuoteAlways: Quotes in a field are always significant, regardless of where they appear.
Delimiter
: A single character delimiter. Should be used only withCsvStyle.QuoteAfterDelimiter
.IncludeLineSeparators
: Specifies whether to include the line break characters in the text. The default value isfalse
.Encoding
: The text encoding of the binary value. The default value is65001
(UTF-8).