Hi there,

Has anybody managed to handle new line characters in data file (csv) while loading using the load data command ?

My data file has some, and each time one is encountered, the load is aborted. :(

One way is to handle possible newline characters on the source side, and the other way is to handle them during the load. Since its going to be a much bigger effort on source side, I am looking for ways to handle it on loading time.

any ideas ? anybody came through this earlier ??

pls share…

Hi !

What about LOAD .... FIELDS ENCLOSED BY ‘“’ ...

Surely, the load file must be prepared in such a way, that the strings are enclosed in ” (or any other character of your choice). Loading new line characters has been practiced since early days of IB in this way. Be aware, that the enclosing character must not appear as a part of the string (unless escaped).

I knew about this option.. but somehow didnt think of it.
worked perfectly. thanks for the tip.