I need to replace multiple fields within the same column

[Birdman1971]

Hi 

 I have used the formula tool and can replace any field with e.g the word hello the goodbye 

I use replace (column name) "hello" "goodbye" 

But i also want to replace other words in the same column - such as "wave" to be replaced by "clap"

I am stuck as to how and i have tried several options 

Thank you in advance 

[jrlindem · Accepted solution]

Within one field, you can simply sequence REPLACE() functions on the same field:

You could also nest the REPLACE() functions into itself, but that's more messy.  If you need to do the same replacements across many fields, you can use the Multi-Field Formula, but then you will need to use the nesting approach.

Hope that helps, -Jay

[Birdman1971]

Thanks Jay I have tried that option but for whatever reason , maybe as i have other things going on with fields adding together , it only seems to take the last one on the list as it were 

[jrlindem]

@Birdman1971 Can you attach your workflow with some dummy data as an example so I can see what you're experiencing?

[Birdman1971]

Thanks Jay , will have to be tomorrow as i have to head off now - appreciate your help 

[Birdman1971]

HI Jay , looking back i probably wasnt clear with my question. I have a column full of data and i need to change mutiple filelds in the column 

So as an example , the word Deduction will appear 7 times in multiple rows , and i need to change it to insurance. But also in that column , the word Employer appears 15 times in rows , and i need to change that to Director . Thanks again 

[Birdman1971]

I have nested and have got it working ! 

[dataminex]

Hi Birdman,

You may use Multi-Field Formula tool to do few changes on some columns simultaneously. 

For example, you want to replace any "hello" to "__a__" in columns 'c1', 'c2', and 'c3':
replace(_CurrentField__, "hello", "__a__") and you have to check the columns you wanted.

In addition, by adding another Multi-Field Formula tool you can replace any "goodbye" to "__b__".

Read more in this link:
https://help.alteryx.com/current/en/designer/tools/preparation/multi-field-formula-tool.html#id55508...

[jrlindem · Accepted solution]

@Birdman1971 Great!  Glad you got it working and that I could help.  Cheers, -Jay