title: How to get rid of special character in Netezza columns
body: <p>I am transferring data from one Netezza database to another using Talend, an ETL tool. When I pull data from a varchar(30) field and try to put it in the new database's varchar(30) field, it gives an error saying it's too long. Logs show the field has whitespace at the end followed by a square, representing some character I can't figure out. I attached a screenshot of the logs below. I have tried writing SQL to pull this field and replace what I thought was a CRLF, but no luck. When I do a select on the field and get the length, it has a few extra characters than what you see, so something is there and I want to get rid of it. Trimming does not do anything.</p>
  
  <p>This SQL does not return a length shorter than simply doing length() on the column itself. Does anyone know what else it could be?</p>
  
  <pre><code> SELECT   LENGTH(trim(translate(TRANSLATE(&lt;column&gt;, chr(13), ''), chr(10), ''))) as len_modified
  </code></pre>
  
  <p><a href="https://i.stack.imgur.com/C7NMl.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/C7NMl.png" alt="Snapshot of the logs"></a></p>
  
  <p>Note that the last column in the logs, where you see a square in brackets, is supposed to show the last character examined.</p>