in reply to Re^5: Best method to load a csv file.
in thread Best method to load a csv file.

Use Text::xSV or Text::CSV_XS. The other modules tend to have subtle bugs in them.

My question is why aren't you loading the data into temp tables, then using PL/SQL to clean the data up later? That's what I did when I had to do something similar on a daily basis and it was quite fast ...

Being right, does not endow the right to be rude; politeness costs nothing.
Being unknowing, is not the same as being stupid.
Expressing a contrary opinion, whether to the individual or the group, is more often a sign of deeper thought than of cantankerous belligerence.
Do not mistake your goals as the only goals; your opinion as the only opinion; your confidence as correctness. Saying you know better is not the same as explaining you know better.

Replies are listed 'Best First'.
Re^7: Best method to load a csv file.
by samgold (Scribe) on Dec 17, 2004 at 19:31 UTC
    I needed a fast way to load the data. By fast I mean something developed quickly. Now I have some time to go back and look for a better way of doing it. I may just do that, my PL/SQL skill are bit better now and I am more comfortable using it.

    Thanks,
    Sam
[reply]

In Section Seekers of Perl Wisdom