Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Thu, 24 Apr 2008 @ 18:05:03 GMT


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


Subj:   Re: Extract values from field
 
From:   Michael Larkins

Hi Craig:

My first thought is a recursive query to pull out the numeric values, but a few details might be needed, like:

1. is there only one numeric field?

2. is it always the same length?

3. if multiple fields, do they stay separate or become one?

4. anything else you think is worth mentioning?


It would seem that your data source is a bit unhelpful. Could it become a csv file for loading instead of a single long varchar containing multiple pieces of info? It would make your life a lot simpler.


Thanks in advance for providing some details.

Michael Larkins
Certified Teradata Master
Certified Teradata SQL Instructor



     
  <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