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?

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

Line Break if text contains ;;;;; | Microsoft Fabric Community

Ahmedx
Super User
3 years ago
try like this
Text.Combine( Text.Split([Column1],";;;;"),"#(lf)")
- StoryofData
  Helper III
  3 years ago
  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
    Super User
    3 years ago
    Text.Combine( Text.Split([Столбец1],";;;;"),"#(lf)"&Character.FromNumber(13))
StoryofData
Helper III
3 years ago
Thank you sooooooo much! I thought this was impossible 🙂