Forum Discussion

joxe's avatar
joxe
Regular Visitor
5 years ago
Solved

How to divide a column keeping the delimiter?

Hello, When I divide a column by delimiter in the result the delimiter is lost. How can I keep it? Thanks.
Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    You could use ReplaceValues and replace "<h3" with "<h3,", and then split using "," as the delimiter.
    --Nate

joxe's avatar
joxe
Regular Visitor
5 years ago

Hi Anonymous 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,