My data (one row) looks like this:
'19','user','user','0','0'

try:


sed 's/'/"/g' mydata.dat > mydata_corrected.dat

and:

SET COMPRESSED '/"/,/'
//
DATALOAD TABLE PM_USER
INSTREAM FILE 'mydata_corrected.dat' COMPRESSED

Arne

--
Institute of Shipping Economics and Logistics    http://www.isl.org/
Arne Gehlhaar                                mailto:[EMAIL PROTECTED]
Universitaetsallee GW1 Block A                phone:+49.421.22096.49
D-28359 Bremen, Germany                         fax:+49.421.22096.55

_______________________________________________
sapdb.general mailing list
[EMAIL PROTECTED]
http://listserv.sap.com/mailman/listinfo/sapdb.general

Reply via email to