Archives of the TeradataForum
Message Posted: Tue, 20 Jul 2004 @ 21:49:18 GMT
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.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|