BULK REPLACE OF TEXT

[srkase]

Hi ,

I have a table named prod_cable...

In that i have column name - dealer name , district

Instead of going and replacing the certain texts using replace in the query editor [ lots of replacements are there and hence it takes lots of time to apply query] , i need to perform this as a bulk option every time when i refresh my data.

example:

TEXT	TOBEREPLACED
[CANCELLED]
[CANCELED]
[CANCELLED ]
[CENCELLED]
[cancelled]
[CANCELLED]
BANGALORE	BENGALURU
HOSKOTE	HOSOKOTE
PREMIER MARKETING	PREMIER ENGINEERS
THAMMAM PATTY	THAMMAMPATTY
A.D.P ELECTRICALS CHINGLEPET	A.D.P.CO., CHENGALPATTU

Your advise is needed in this case.

Regards

SRK

[mwegener]

Hi @srkase,

create a table with all the necessary replacements and merge this table with your prod_cable... table

[srkase]

I have already created a table and added that ...

But Sir,, what is the query to do this replacement each time when the data is being refreshed ?

But my problem is , the refreshed data every time is to be replaced with the replacement text.  The replacement text will be applicable for the dealer name starting with.  

see my data sample :

https://www.dropbox.com/s/bdm3kd4q92b3utq/sample%20data.xlsx?dl=0

[mwegener · Accepted solution]

Hi @srkase ,

check this out.

https://community.powerbi.com/t5/Desktop/Power-Query-Replace-multiple-substrings-in-one-column/td-p/...