Forum Discussion

raymondpocher's avatar
raymondpocher
Advocate III
4 years ago
Solved

PowerQuery: remove text string between custom delimiters

Hi community,   I want to achieve something simple but in power query I feel as if I am making way too compley. So after not finding anything on google I turn to you 🙂   Suppose I have loaded UR...
Need Help
  • CNENFRNL's avatar
    CNENFRNL
    4 years ago
    #"REMOVE" = Table.TransformColumns(#"PREVIOUS_STEP", {{"COLUMN_TO_REPLACE", each Text.Replace(_, Text.BetweenDelimiters(_, "t=", "&"), ""), type text}})
CNENFRNL's avatar
CNENFRNL
Community Champion
4 years ago
#"REMOVE" = Table.TransformColumns(#"PREVIOUS_STEP", {{"COLUMN_TO_REPLACE", each Text.Replace(_, Text.BetweenDelimiters(_, "t=", "&"), ""), type text}})
GiuseppeSan's avatar
GiuseppeSan
New Member
2 years ago

Hi, I am using this function to replace elements within html tags in a text.

It seems that the function does not replace the text for all occurrences, but only for the first one it finds.

Is it my mistake on how I am applying it or should some modification be applied?

    #"Rimosso contenuto span" = Table.TransformColumns(#"Rinominate colonne4", {{"Descrizione", each Text.Replace(_, Text.BetweenDelimiters(_, "<span", ">"), ""), type text}}),