Lines functions

 

The Power Query Formula Language is a powerful query language optimized for building queries that mashup data. It's a functional, case sensitive language similar to F#, which can be used with Power Query in Excel, Get & Transform in Excel 2016, and Power BI Desktop. To learn more, see the PowerQueryName reference.

FunctionDescription
Lines.FromBinaryConverts a binary value to a list of text values split at lines breaks.
Lines.FromTextConverts a text value to a list of text values split at lines breaks.
Lines.ToBinaryConverts a list of text into a binary value using the specified encoding and lineSeparator.The specified lineSeparator is appended to each line. If not specified then the carriage return and line feed characters are used.
Lines.ToTextConverts a list of text into a single text. The specified lineSeparator is appended to each line. If not specified then the carriage return and line feed characters are used.
Show: