Lines.ToText

Lines.ToText is a Power Query M function that converts a list of text into a single text using a specified lineSeparator. The function returns a single text with the specified lineSeparator appended to each line.

Compatible with: Power BI Service Power BI Desktop Excel Microsoft 365

Syntax

Lines.ToText(
   lines as list,
   optional lineSeparator as nullable text,
) as text

Description

Converts 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.

Related functions

Other functions related to Lines.ToText are:

• Lines.FromBinary
• Lines.FromText
• Lines.ToBinary

Last update: August 17, 2023 | Contribute » | Contributors: Rick de Groot
Microsoft documentation: https://learn.microsoft.com/en-us/powerquery-m/lines-totext
© 2023 BI Gorilla. All rights reserved. Content derived from Microsoft documentation is property of Microsoft Corp.