Cygwin is cool, but I'd recommend using Perl over awk, merely because
it's more useful in the rest of the world. In other words, Perl
programming covers a much larger breadth than awk, so if you learn Perl
you can take that skill a lot more places. But awk /is/ very powerful.
:)
> -----Original Message-----
> From: Rob Wilkerson
> Sent: Wednesday, March 22, 2006 10:48 AM
>
> 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:235977
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
