Using multi-field tool to convert from French to English

[YeahMan]

Hi,

I'm trying to use the multi-field tool to convert French data to English data. Below is a simplified example:

I need to be able to do this for 47 columns/fields and 30 phrases so a simple Find/Replace won't work here.

Thanks for the help!

--sue

[binuacs]

@YeahMan One option is to transpose your data then apply the above formula in a formula tool then cross tab the result

[Luke_C]

@binuacs took the words right out of my mouth

Transpose > Find and Replace > Cross tab 

That should get you where you need to be. 

[Felipe_Ribeir0 · Accepted solution]

I would do something like this

[YeahMan]

@Felipe_Ribeir0(and @binuacs and @Luke_C) thank you very much! Now to push 54,000 records through then do a bunch of stats. Can any of you speak to why the multi-field solution I tried didn't work?

[Luke_C]

Hi @YeahMan 

I think it would work, but you'd have to write a very big replace formula to accommodate all the phrases. Making updates to a table feeding a find and replace tool is much easier than trying to dissect a large nested replace statement.