If you're going to go that path, awk or sed is probably ideal. A bit
more work on Windows since it will require the installation of Cygwin
(or a similar tool, if there are others). And, if you do go that
route, you get a thousand other very useful Unix tools to help in
other areas.
On 3/22/06, Munson, Jacob <[EMAIL PROTECTED]> wrote:
> 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:235976
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=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
