title: Delete special character in from word in spark - scala
body: <p>I have a csv file on <code>French</code>, that contain a special character like <code>(é, à, è, ç)</code>. I put this csv file in hdfs via <code>spark 2 - scala 2.11</code>.
  I did the transformation of data, then a transfert my dataframe to Elasticsearch 5.6.</p>
  
  <p>These special character appears like a bizarre character in the Dashboard kibana.</p>
  
  <p>I want replace these spacial character by there normal letter, like:</p>
  
  <pre><code>é = e
  è = e
  à = a
  </code></pre>
  
  <p>I did it, using two possible:</p>
  
  <pre><code>val urlCleaner = (joined_df2:String) =&gt; {
     if (s == null) null else s.replaceAll("é","e")
  }
  </code></pre>
  
  <p>And</p>
  
  <pre><code>val newsjoined_df2=My_Dataframe.withColumn('nom_equipe', when(col('nom_equipe').equalTo('é'), 'e').otherwise(col('nom_equipe'))
  </code></pre>
  
  <p>But, it do not work.
  Someone please can suggest me a solution ?</p>