Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Thu, 12 Apr 2012 @ 09:57:58 GMT


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


Subj:   String extraction in teradata
 
From:   abhishek.gupta

Hi All,

I have following scenario.

Col1 contains values such as

     Col1
     -------
     ABC-123-VAL1
     XAYZ-12-VAL2
     SK-1234-VAL3

Now I want the data as following:

     Col1 Col2
     Col3 Col4
     ABC-123-VAL1 ABC
     123 VAL1
     XAYZ-12-VAL2 XAYZ
     12 VAL2
     SK-1234-VAL3 SK
     1234 VAL3

Basically I want to extract values from one column based on the positioning of hyphen and put that data in separate columns. Does Teradata have any standard function to achieve this?


Regards

Abhishek



     
  <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