I'm not sure I understand. Are you saying they are providing you data that has
delimiters within the data, but the data is not quoted? Like:
[EMAIL PROTECTED],Joe,Smith,Joe, John Sons Inc.
If so there is nothing you can do about that, they need to be properly quoting
(with double quotes or
yes, you need to either change your export routine to enclose all
'fields' in double quotes, or change your export format to, say,
tab-delimited file instead of comma-delimited.
most databases have built-in routines and functions to automate import
of data from text files, in which you can usually
2 matches
Mail list logo