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

That's true. So back to the question of parsing the csv file, which do you think is better or faster? The way I am doing it now with Text::ParseWords or DBI::CSV or Text::csv?

Thanks,
Sam

Replies are listed 'Best First'.
Re^6: Best method to load a csv file.
by dragonchild (Archbishop) on Dec 17, 2004 at 17:23 UTC
    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.

[reply]
      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