Archives of the TeradataForum
Message Posted: Fri, 24 Jan 2003 @ 22:43:17 GMT
| Subj: || || Re: Mload and doble quotes in a comma delimited file |
| From: || || Jason Fortenberry |
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
You will also have to remove the double quotes from your files so that they are not loaded as part of your fields.