Hi Derek, Derek Hamilton [mailto:[EMAIL PROTECTED] wrote: > > > When importing csv files, if *any* field is delimited by > double quotes then > *all* fields need to be delimited by double quotes. Is my > understanding > correct? For instance, exporting from SQL Server will put > double quotes > around varchar fields while not double quoting int, datetime, > etc. fields. > I then have to transform the data somehow in order to be able > to import with > the loadercli tool if I don't want to write an app to insert the rows > one-by-one, correct? > To make it short: correct.
> The app I'm developing needs to do an import at least once a > week of over > 1GB of data from separate csv files that come to us with > certain fields > delimited by double quotes and others not. I have no control > over how the > data is exported so I just want to be sure I have the correct > understanding. > Uuuh, 1GB of data every week. That's a lot to convert every time. And you surely have no control? Seems like we should think again about using RE to make these delimited/undelimited 'mix' possible. But it won't be out within a few days! Regards, Steffen -- Steffen Schildberg SAP DB Team SAP Labs Berlin _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
