Well I thought I would give it a shot using Coldfusion, and loe and behold, it
is quick enough. 1515ms for the largest file where the applications just hang
and run for about 17 minutes, so there you go that is my answer I guess.
Thanks for reading.
cheers
Martin
>Hello. I know it is a bit off topic but you guys seem to know
>everything.
>
>
>
>I have a bunch of CSV text files created with Oracle SQL*Plus from the
>command line. I now need to import these into the database but SQL*Plus
>seems to be notorious at creating white space between the columns of
>data. I have 12 files totalling 9 mb. What I need to do is replace the
>white spaces with a simple reg ex |[ ]{1,50} .
>
>
>
>Now I have tried two applications that do the job and that I can
>eventually run from the command line, but they just timeout and hang,
>take too long to process.
>
>
>
>Anyone know of a good application, super fast, that can do this sort of
>thing. And no I do not have a Perl server that I can use if this is an
>option.
>
>
>
>Thanks for reading.
>
>
>
>Cheers
>
>Martin
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:235940
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
