Home Page for the TeradataForum

Archives of the TeradataForum

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

  <Prev Next>  
Next> Last>>  

Subj:   String extraction in teradata
From:   abhishek.gupta

Hi All,

I have following scenario.

Col1 contains values such as


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?



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