Forum Discussion

Jamieneedshelp's avatar
Jamieneedshelp
Frequent Visitor
2 years ago
Solved

Keep text between 2 deliminators- kind of!

Hi All   When importing termstore data to power bi we get lots of unwanted text. Is there any way to just keep Oranges and Apples from the below and remove the rest?   [{"Label":"Oranges","Ter...
Need Help
  • Vijay_A_Verma's avatar
    Vijay_A_Verma
    2 years ago

    Use the below formula in a custom column (here Text is your column name which you will need to change)

    Text.Combine(List.Transform(Text.Split([Text], "},{"), (x)=> Text.Trim(Text.BetweenDelimiters(x, """Label"":", ",""TermID""" ), """")), ", ")
Vijay_A_Verma's avatar
Vijay_A_Verma
Icon for Most Valuable Professional rankMost Valuable Professional
2 years ago

Use the below formula in a custom column (here Text is your column name which you will need to change)

Text.Combine(List.Transform(Text.Split([Text], "},{"), (x)=> Text.Trim(Text.BetweenDelimiters(x, """Label"":", ",""TermID""" ), """")), ", ")