Forum Discussion
How to replace multiple string values
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
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!
5 Replies
Anonymous , You want replace or substitute ?
https://docs.microsoft.com/en-us/dax/substitute-function-dax
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.
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!
