Line Break if text contains ;;;;;

[StoryofData]

Hi, 

My data is fed from SQL Server, I have a column with free text, no formatting. I do have ";;;;;" where the line break used to exist in the system before data was ingested by SQL Server. What I need to do is to create line breaks in that text so it is easier to read. Here is an example, black text is unformatted, text in blue is how I'd like it to appear in a table for example. Is this a solvable issue?

[StoryofData]

Thank you sooooooo much! I thought this was impossible 🙂

[Ahmedx · Accepted solution]

try like this

Text.Combine(
Text.Split([Column1],";;;;"),"#(lf)")

[StoryofData]

Is there a way to insert a bigger break?

Right now it's doing this:

"Power BI is a collection of software services, apps, and connectors that work together to turn your unrelated sources of data into coherent, visually immersive, and interactive insights. BREAK

Your data might be an Excel spreadsheet, or a collection of cloud-based and on-premises hybrid data warehouses. Power BI lets you easily connect to your data sources, visualize and discover what's important, and share that with anyone or everyone you want."

and i'd like it to be this:

"Power BI is a collection of software services, apps, and connectors that work together to turn your unrelated sources of data into coherent, visually immersive, and interactive insights.

BREAK

Your data might be an Excel spreadsheet, or a collection of cloud-based and on-premises hybrid data warehouses. Power BI lets you easily connect to your data sources, visualize and discover what's important, and share that with anyone or everyone you want."

[Ahmedx]

Text.Combine(
Text.Split([Столбец1],";;;;"),"#(lf)"&Character.FromNumber(13))