Query Editor - Transformation - Replace values: use of wildcard

[agustinsuarez]

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!

[Baskar]

Cool dude.

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

Sample Dataset

Add Condition Column

Final result

Finally remove the old column. 

let me know if any help

[agustinsuarez]

Hi Baskar,

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

[ImkeF · 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...

[agustinsuarez]

Thanks ImkeF,

this is what I needed!