title: Replace multiple strings in Google Spreadsheet with script
body: <p>I want to make an script for Google Spreadsheet, in order to replace automatically a series of strings (actually, for translating strings from one language to the other). The thing is that I have to do this everyday, and a Script would allow me to save a lot of time. </p>
  
  <p>I found this script made by <a href="https://productforums.google.com/forum/#!topic/docs/7IlOotksJ4I" rel="nofollow">Bannager Bong</a>. and it works for one single string, but I would want to make it work for an array of elements:</p>
  
  <pre><code>function fandr() {
     var r=SpreadsheetApp.getActiveSheet().getDataRange();
     var rws=r.getNumRows();
     var cls=r.getNumColumns();
     var i,j,a,find,repl;
  
     find="abc";
     repl="xyz";
  
     for (i=1;i&lt;=rws;i++) {
        for (j=1;j&lt;=cls;j++) {
           a=r.getCell(i, j).getValue();
           if (r.getCell(i,j).getFormula()) {continue;}
           try {
              a=a.replace(find,repl);
              r.getCell(i, j).setValue(a);
           }
           catch (err) {continue;}
        }
     }
  }
  </code></pre>
  
  <p>so for instance I would like to loop the variables from <code>find=["abc","aaa","ooo"];</code> and changing those strings to  <code>repl=["xyz","UUU","aAa"];</code></p>
  
  <p>However given my poor skills in programming, I don't know how to procede.</p>
  
  <p>Could you please help me?</p>
  
  <p>Thanks in advance,</p>