How to replace multiple string values

[Anonymous]

Hi All,

I have the following REPLACE function , which works fine, but my column has different values, for example the other value is "Bagels for Life", how can i change both or more values using REPLACE? Please advice.

DEFINE
VAR Val = "Donuts for Life"
VAR Replacement = "DFL"
EVALUATE
{
( "Original", Val ),
( "Replaced", REPLACE ( Val, 1, 15, Replacement ) )
}

Thanks

[v-xulin-mstf · Accepted solution]

Hi @Anonymous

You can create a custom column as:

Text.Select([Column1],{"A","B","C","D","E","F","L"})

You need to add all relevant capital letters in the red underlined part, you can also just add 'A-Z'.

If you still have some question, please don't hesitate to let me known.‌‌

Best Regards,

Link

Is that the answer you're looking for? If this post helps, then please consider Accept it as the solution. Really appreciate!

[Anonymous]

hi @Anonymous 

Are the values such as "Donuts for Life" par of a larger string "Donuts for Life is Good"? If Not, then can we add custom column in power query and replace the values?

Thanks,

alekh

[Anonymous]

Any idea if i can replace multiple values in a column? Please.

Thanks

[amitchandak]

@Anonymous , You want replace or substitute ?

https://docs.microsoft.com/en-us/dax/substitute-function-dax

[Anonymous]

@amitchandak thanks , all i want is where ever in my column is see values  "Donuts for Life", "Bagels for Life" , "Fries for Life", need to see DFL,BFL,FLF respectively. I do not know if using REPLACE or SUBSTITUTE is good.