Hi Albert, [Albert Steckenborn wrote]
> Subject: Problem with DATALOAD and partial double quouted DELIMITER > > i'm trying to load data into a table with the following script: > > DATALOAD TABLE "HOTELS" > INFILE 'test.data' ASCII SEPARATOR ';' DELIMITER '"' > > > The Data at the infile looks like this: > > test;test;test;"test,test,test,test";test > > With and without the delimiter i will get an Error on load. > How can I load this data into the table. > Thanks a lot for your help!!!! > Well, the problem is the partially used delimiter. You may either use delimiters or not. There is nothing in between. So your data - that would fit to your command - should look like: "test";"test";"test";"test,test,test,test";"test" Or in case you don't want to use delimiters you need the following command and data: DATALOAD TABLE "HOTELS" INFILE 'test.data' ASCII SEPARATOR ';' DELIMITER '' test;test;test;test,test,test,test;test Regards, Steffen -- Steffen Schildberg SAP DB Team SAP Labs Berlin _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
