Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Thu, 23 Oct 2008 @ 14:53:20 GMT


     
  <Prev Next>  
<<First
<Prev
Next> Last>>  


Subj:   Replacing unprintable text
 
From:   Anomy Anom

<-- Anonymously Posted: Thu, 23 Oct 2008 09:39 -->

I need to replace all characters in a string where the character value is between '1A'XC and '1F'XC, with a different value, say '#'. In other words, find all characters in this string 'ABCD|~ JKL', where the character value is between '1A'XC and '1F'XC and replace it with a '#'.

Normally, I'd use a UDF TRANSLATE or REPLACE function for this, but the value range of '1A'XC to '1F'XC does not translate into chracters, which makes this difficult to do (for me!). I've considered using the CHAR2HEXINT function, combined with an INDEX function, but that only allows the detection of the first instance of an unprintable character, and only for one of these unpritable values, not the full range.

Any advice much appreciated - thanks!



     
  <Prev Next>  
<<First
<Prev
Next> Last>>  
 
 
 
 
 
 
 
 
  
  Top Home Privacy Feedback  
 
 
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 27 Dec 2016