cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Regular Visitor

Query Editor - Transformation - Replace values: use of wildcard

Hi,

 

is there a way to use wildcards in the "Replace Value" modal-window?

 

I am using a german version of Power BI, and therefore I don't really know which is the english text for the "Replace Value" function. But what I am trying to do is to delete all html link tags from one of my columns.

 

  1. Query Editor
  2. Transformation
  3. Replace Values
    • Search Text = <a href=*>
    • Replace with = <empty>

Thanks!

1 ACCEPTED SOLUTION

If there are more different HTML-signs there, check out this post, where you'll find many links to HTML-cleanup-codes:

https://social.technet.microsoft.com/Forums/en-US/afe68023-2d06-4270-ac4d-4416a60fdf49/i-have-a-colu...

Imke Feldmann (The BIccountant)

If you liked my solution, please give it a thumbs up. And if I did answer your question, please mark this post as a solution. Thanks!

How to integrate M-code into your solution -- How to get your questions answered quickly -- How to provide sample data -- Check out more PBI- learning resources here -- Performance Tipps for M-queries

View solution in original post

4 REPLIES 4
Resident Rockstar
Resident Rockstar

Cool dude.

 

pls look this screen shot it will help to solve your problem.

Sample DatasetSample Dataset

 

 

Add Condition ColumnAdd Condition Column

 

 

Final resultFinal result

 

 

 

Finally remove the old column. 

 

let me know if any help

Hi Baskar,

 

thanks for the effort, but the problem is that the  column never starts with an <a> tag.

If there are more different HTML-signs there, check out this post, where you'll find many links to HTML-cleanup-codes:

https://social.technet.microsoft.com/Forums/en-US/afe68023-2d06-4270-ac4d-4416a60fdf49/i-have-a-colu...

Imke Feldmann (The BIccountant)

If you liked my solution, please give it a thumbs up. And if I did answer your question, please mark this post as a solution. Thanks!

How to integrate M-code into your solution -- How to get your questions answered quickly -- How to provide sample data -- Check out more PBI- learning resources here -- Performance Tipps for M-queries

View solution in original post

Thanks ImkeF,

 

this is what I needed!

Helpful resources

Announcements
secondImage

Congratulations!

We are excited to announce the Power BI Super Users!

Wave Release 2

Check out the updates in Power BI.

Overview of Power BI 2020 release wave 2!

Microsoft Ignite

Microsoft Ignite

Join digitally, March 2–4, 2021 to explore new tech that's ready to implement. Experience the keynote in mixed reality through AltspaceVR!

secondImage

The largest Power BI virtual conference

100+ sessions, 100+ speakers, Product managers, MVPs, and experts. All about Power BI. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors