Archives of the TeradataForum

Message Posted: Tue, 20 Jul 2004 @ 21:49:18 GMT

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

How do I set the format of the input data as ",". The txt file contains data separated by comma but it also contains double quotes for each data value of each column.

SET RECORD VARTEXT ","; This statement does work but the records in the loaded table comes with double-quotes as explained.

     0008 SET RECORD VARTEXT """,""";

     **** 14:38:11 Now set to read 'Variable-Length Text' records
     **** 14:38:11 Delimiter character is set to '"'
     **** 14:38:11 Command completed successfully

Any help greatly appreciated.

Joseph

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