Lines.ToText

 

This topic applies to the Power Query Formula Language which can be used with Power Query and Power BI Desktop to build queries that mashup data. See the list of function categories.

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.

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

ArgumentDescription
linesThe list of lines to convert.
optional lineSeparatorDetermines whether the line break characters are included in the line. This is useful when the actual line break is significant and needs to be preserved. If not specified, then it defaults to false.If includeLineSeparators is true, then the line break characters are included in the text.
Lines.FromText("A,""B#(cr)C""#(cr)#(lf)1,2", true, null)  
{  
"A,""B#(cr)",  
"C""#(cr)#(lf)",  
"1,2"  
}  

Lines.FromText("A,""B#(cr)C""#(cr)#(lf)1,2")  
{  
"A,""B",  
"C""",  
"1,2"  
}  

Lines.FromText("A,""B#(cr)C""#(cr)#(lf)1,2", null, ",")  
{  
"A,""B#(cr)C""",  
"1,2"  
}  

Show: