"Harry" <> wrote in message
news:
>
> Gee that is really simple. Clever of MS to provide such a powerful
> and user-friendly tool! So simple!
>
Indeed - I totally agree.
In my opinion Excel is one of the reasons that so few businesses will
move away from MS Windows in the foreseeable future, simply because
there is nothing to compare with it's flexibility and power.
Sure, if you just want a flashy calculator, you can use Open Office or
Star Office or something, but they don't come near the power of
Excel's VBA object model / capabilities.
Personally, I am all for the Linux / OSS model - I love that it gives
us so much choice and mostly for free compared to the extortionate
prices for Office.
However, in most business environments Excel and Access rule for the
actual end users who need to use the business data stored in the
enterprise DBs and there is no marginal cash cost to using them since
they are already there.
>
> BTW you can get a copy of gawk.exe, on its own, from nearly
> everywhere on the internet. You could also do the same thing with
> perl.exe, viz:
>
> dir /b/s | perl -ne 'print $_ if length($_) > 255;'
>
Personally, I do not know anyone who would have access to gawk.exe or
Perl.exe outside of software developers etc. I'm sure some people do,
but at the same time I cannot think of anyone at any of my clients who
*doesn't* have excel available.
At the end of the day, the OP needs a solution, and it appears that
this gives them one that they can implement quickly, easily, and
safely.
>
> Doing it in excel is lame.
>
{Shrug}
Took me about 3 mins to do when I tried it and that's *all* that
really matters in the end isn't it?
What would be the benefit of spending 15 mins finding, downloading,
installing (maybe), and working out how to use, say, perl or gawk,
when they can do the above in 5 mins, get the answer they need, and
move on to something else that needs to be done.
The OP wanted a solution that works for them and that does I believe.
Plus, no need to search for and download software that might have
nasties in it either.
Each to his own.
Alan.
--
The views expressed are my own, and not those of my employer or anyone
else associated with me.
My current valid email address is:
This is valid as is. It is not munged, or altered at all.
It will be valid for AT LEAST one month from the date of this post.
If you are trying to contact me after that time,
it MAY still be valid, but may also have been
deactivated due to spam. If so, and you want
to contact me by email, try searching for a
more recent post by me to find my current
email address
Similar Threads
