This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
Is there any tool to do a find replace data cleanse using a list of word pairs that can be applied to mutiple columns in a single step?
Similar to the data cleanse tool but a list of word/character pair values can be applied to multiple columns in your data set?
There's a couple of ways you could do this. You could create a Standard Macro to do it, but it might be easier to use a Multi Field Formula instead.
I was hoping someone would have a built a widget for this, seems like a very common use case.
20 word pairs along 50 columns would take some time in the formula tool, excel might be actually better for this.
Hi @StephenF You can transpose your data, then find and replace it, and then cross tab it back, like here
Here's a really quick and dirty example of how you could do it.
You could create a more complicated module that would change more than one Find / Replace pair, but this one works for a single pair.