I'm glad you figured it out, but I wanted to comment on your Perl
comment. I don't see why you'd need a 'Perl server' if you wanted to
use Perl for this. Perl is very small, and it plays nicely with others.
So you could put it on any PC/Server and just run it from the command
line. This is all assuming you know Perl, or are willing to spend some
time learning. :)
> -----Original Message-----
> From: Martin Thorpe
> Sent: Wednesday, March 22, 2006 2:09 AM
>
> 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.
>
> >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.
This transmission may contain information that is privileged, confidential
and/or exempt from disclosure under applicable law. If you are not the intended
recipient, you are hereby notified that any disclosure, copying, distribution,
or use of the information contained herein (including any reliance thereon) is
STRICTLY PROHIBITED. If you received this transmission in error, please
immediately contact the sender and destroy the material in its entirety,
whether in electronic or hard copy format. Thank you. A1.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:235975
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
