Re: loadfile with quotation marks

try_and_err wrote: > Hi, > > is there a chance to load such a line in a loadfile without scripting, > like "load from ... insert into ... ? > 123|"abc"| Easiest just to edit your load file. Otherwise, load your table and then: update mytable set mycolumn = trim(both '"' from trim(mycolumn)) where 1=1; > > The problem is, that the quotations marks were inserted too, but i > would only have the letters. In the documentation i found the > description of DELIMIDENT: > DELIMIDENT causes the database server to interpret double quoted > (") text as identifiers rather than strings. > I have tried with DELIMIDENT=1 and DELIMIDENT=Y - no success. Forget about DELIMIDENT, it's not what you need. > Informixversion is 9.30.UC5. > Any suggestions ? > > Regards, > try_and_err -- rh