Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.
Say, for example that I have a cell with the following text: "[A] ; [B] ; [C] ; [D]"
I would like to add line breaks so that the final loaded output shows each value on separate lines in the same cell. I.e. Adding line breaks in place of the semi-colons. Does anyone have an idea how to achieve this? I've played around with the "Split Column by Delimiter" function but haven't managed to achieve what I want.
"[A]
[B]
[C]
[D]"
Thanks in advance!
Thanks. Adding "#(If)" as the text separator within the Text.Combine Function seems to have done the trick!
Text.Combine( ................. , "#(lf)")
Weird that it doesn't work if I added & "#(If)" as a text string in the Add Column --> Custom Column option.
e.g. [A] & "#(If)" & [B] & "#(If)" & [C] & "#(If)" & [D]
Do you try "Split Column by Delimiter into Rows"?
https://www.excelcampus.com/powerquery/split-into-rows/
Check out the November 2023 Power BI update to learn about new features.
Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.