> [Corinne Laborde wrote] > > I try to load data into a data base using the Replication manager. I > want to insert a string with a " inside. > > The file I use contains the values : > 1,"test of "double" quotes" > > > When I insert this data with the sript : > DATALOAD TABLE test > id 1 > description 2 > INFILE '/tmp/test.data' > > > I get no errors but if I look at what I have in my data base, > the field > description contains the string : quotes > > I found nothing on the documentation, > Can somebody please help me ? > > Corinne > Hi Corinne, the only choice you have is to choose another delimiter for your data if you want to load the data compressed. But this means to manipulate the data first the following way: before: 1,"test of "double" quotes" after : 1,%test of "double" quotes% Then the command to load the data looks like DATALOAD TABLE test id 1 description 2 INFILE '/tmp/test.data' delimiter '%'
Ok, this means additionally that you have to choose a delimiter that is not in your data. If you could load your data formatted (that is the positions are not relative but absolute) you could omit the delimiter problem. I know that this is a problem that was mentioned earlier in the list. We'll provide with one of the next releases a partial solution for this problem. The implementation of escape characters for special characters (that would be the real solution) however will take some more time. HTH for the first time Regards, Steffen -- Steffen Schildberg [EMAIL PROTECTED] SAP DB, SAP Labs Berlin
