Splitter.SplitTextByDelimiter using ENTER as the delimiter character

[WillianFLopes]

Hey guys.

I want to use Splitter.SplitTextByDelimiter using ENTER as the delimiter character.

Using the Power Query interface I was able to do this using the comma and in particular it was useful because it gives the option of separating values ​​into ROWS and not just columns.

I need this but using ENTER as a limiting character.

Any ideas?

[WillianFLopes]

#(lf) worked fine to me! 

Thank you everyone for your help

[Vijay_A_Verma]

"#(cr)" is the code for this.  Example below

Splitter.SplitTextByDelimiter("#(cr)")([Column1])

[AlexisOlson · Accepted solution]

Try using "#(lf)" or "#(cr)" as the delimiter. These stand for "Line Feed" and "Carriage Return" and are the typical new line characters.