Archives of the TeradataForum

Message Posted: Fri, 24 Jan 2003 @ 22:43:17 GMT

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

If you have commas within your fields, you have to use a different delimiter. Can you re-export the data with a different delimiter, such as pipe "|"? If not, I could share with you a Perl script that will update the comma delimiters only in your text file to another delimiter.

You will also have to remove the double quotes from your files so that they are not loaded as part of your fields.

--Jason

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