Forum Discussion
Replace multiple words simultaneously in M Query
Hi there I have a 'Comments' column and I want to remove about 70 words to clean it up. I am loath to use replace, because it creates 70 steps and takes ages. I have found Table.TransformColumn...
Anonymous
Try using add column from example and try to give few examples to train power query to remove respective words ! may be you need to give few examples 4 to 5. Let me know if you are able to do that!
Sorry VijayP no chance. The text is too detailed, example column gets instantly confused and tries to transform the whole sentence.