Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello,
When I divide a column by delimiter in the result the delimiter is lost. How can I keep it?
Thanks.
Solved! Go to Solution.
You could use ReplaceValues and replace "<h3" with "<h3,", and then split using "," as the delimiter.
--Nate
You could use ReplaceValues and replace "<h3" with "<h3,", and then split using "," as the delimiter.
--Nate
Very easy and very effective solution. Thank you very much!
Hi @Vera_33 again,
In my answer I did not show the formula, which maybe helps:
= Table.ExpandListColumn(Table.TransformColumns(#"Converted to Table", {{"Column1", Splitter.SplitTextByDelimiter("<h3", QuoteStyle.None), let itemType = (type nullable text) meta [Serialized.Text = true] in type {itemType}}}), "Column1")
I compare it with the formula of your image, and I can't figure out how to adapt it.
Best regards,
Hi @joxe
Can you provide some sample data and expected result? Not sure what exactly you want...split it by delimiter then add it back?
Hi Vera,
I am working with the code of a web page. I need to split a column into rows each time the <h3 text appears, which usually goes in a sequence: <h3 class = "article__title">. Therefore:
But after the step I lose the delimiter and, as you can see, each row starts with class = "article__title", and not wiht <h3 class = "article__title">, as I need:
Do you know how to keep the delimiter?
Thank you very much.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.