title: How to Select Only Alphanumeric characters from a string in Datastage?
body: <p>I am facing a problem with my data, in my data other than alphanumeric characters are there in a column field, where for <strong><em>EX</em></strong> in Name column: <strong>Ravicￌhandr￢an (￢ￌ￮`)</strong> like these many characters are there. I need a result like Ravichandran. How can I achieve this? Is there any way to remove in transformer stage. </p>
  
  <p>I tried Convert function in Transformer stage, but problem in using Convert, I am not sure about these unknown characters, I have shown above is just example.</p>
  
  <p>My Requirement is, other than alphanumeric must be removed. And the Balance string should be the same.</p>
  
  <p>How can I get this done?</p>