Lines.FromText

 

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 text value to a list of text values split at lines breaks.

Lines.FromText(text as text,  optional quoteStyle as nullable number,  optional includeLineSeparators as nullable logical) as list  

ArgumentDescription
textThe text to parse.
optional quoteStyleStyle of quote.
optional includeLineSeparatorsIf includeLineSeparators is true, then the line break characters are included in the text. If a delimiter is specified, then line breaks may appear within quotes
Show: