Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

How to replace/remove text between delimiters when there are multiple delimiters ?

Hello,    How to replace/remove text between delimiters when there are multiple delimiters ?   Case :    value on the cell :    aaa bbb ccc eee aaa bbb ccc eee aaa bbb ccc xxx eee...
Need Help
wdx223_Daniel's avatar
wdx223_Daniel
Community Champion
3 years ago

NewStep= Table.TransformColumns(Source,{"Colonne 1",each let a=Table.FromList(Splitter.SplitTextByWhitespace()(_),each {_}) in Text.Combine(Table.Combine(Table.Group(a,"Column1",{"n",each Table.RemoveLastN(_,each [Column1]<>"bbb")},0,(x,y)=>Byte.From(y="xxx"))[n])[Column1],"#(lf)")})

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hello Daniel,

 

I tested but only the first occurrence is removed, and in the next pattern it's the end delimiter that is removed.

 

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    rather, everything after the start delimiter is removed with the second occurence.