Guess it depends on what you're trying to do. awk/sed/another CLI
utility for a quick fix. Perl if you're looking for a learning
exercise. :-)
On 3/22/06, Munson, Jacob <[EMAIL PROTECTED]> wrote:
> 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:235978
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
