HI ,

Im using LOAD FROM command to load a unl(pipe delimited) file to table.

The operation fails bcoz of a backslash symbol (\) in a data field. It works fine when i remove the backslash and load the data.

So, how can i make it work with the backslash, as i have to load the original data without making any changes manually.

Thanks

Try two backslashes instead of one.

That works fine, but is it possible to inactivate these kind of symbols during the load process? Bcoz, my primary aim is not to manipulate the unl file.

Thanks

I think thats not possible!

Here you can find more informations about load and backslash: LOAD statement