I would like to search for a single text string in a cell that contains a long URL and replace that entire URL with a custom value/string.
For example this URL: /Login?ReturnUrl=https://www.company.org/support/articles-and-how-tos/10-steps-for-planning-a-successful-webinar. I would like to search the entire table for URL's containing the text string "articles" then replace that cell with the word "articles" only. The cells that do not contain "articles" to be replaced with "none." How can I do this?
Also, this URL: /posts/how-can-cloud-storage-benefit-my-company-http://blog.company.org/posts/how-can-cloud-storage-benefit-my-company, I would like to search the entire table for URL's containing the text string "blog" then replace that cell with the word "blog" only.
Solved! Go to Solution.
Check the documentation
You will notice that the replacer is a function. This means you can use whatever custom function you want in that step, including the checks that you describe. You could even have a reference table with keywords that should be searched for, and that should replace the entire cell contents if found.
In a calculated column formula, you may use the IF() and SEARCH() functions.
This will be a conference that you do not want to miss!
Don't miss the Power BI Dev Camp this week!
Check out a full recap of the month!
Check out the winners of the recent 'Can You Solve These?' community challenge!
Join us for an in-depth look at the new Power BI features and capabilities at the free Microsoft Business Applications Launch Event.