Archives of the TeradataForum

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

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

<-- 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>>