Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

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 REP...
Need Help
  • v-xulin-mstf's avatar
    v-xulin-mstf
    5 years ago

    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's avatar
Anonymous
Not applicable
5 years ago

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