Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Compete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.

Reply
WillianFLopes
New Member

Splitter.SplitTextByDelimiter using ENTER as the delimiter character

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?

1 ACCEPTED SOLUTION
AlexisOlson
Super User
Super User

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

View solution in original post

3 REPLIES 3
WillianFLopes
New Member

#(lf) worked fine to me! 

 

Thank you everyone for your help

Vijay_A_Verma
Super User
Super User

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

 

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

AlexisOlson
Super User
Super User

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

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

Check out the August 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.

Top Solution Authors