Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Fri, 15 Apr 2005 @ 14:36:23 GMT


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


Subj:   Fastloading delimited file
 
From:   Anomy Anom

<-- Anonymously Posted: Friday, April 15, 2005 09:59 -->

Has anyone any suggestions as how to define a fastload script for the following delimited file.

File is comma delimited. Text fields are also delimited by double quotes to allow for embedded commas within a name field.

This give a file content of :

     "AAA","BBBBBBB","","","CCCCCCCC","SURNAME, FIRSTNAME","ZZZ XXX
     ","0000010","","","","",,,,9305000,"D",,"","Y","",""

I've tried stripping out the double quotes and replace with a pipe delimiter but I always seem to be left with the commas.


Any help would be appreicated

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