Re: why>?

UPDATE XLS_FORMULAS
SET FormulaText = replace(formulatext, 'TRIM', 'LTRIM')
WHERE Worksheet = ''sheet1' and row = 'A' AND formulatext like NOT LIKE
'LTRIM'

you see harlan?

my formulas are infinitely customizable.

your silly little baby formulas??

you can't do jack *** with them.
Excel isn't just a presentation tool; you jackasses use it for ETL all
the time.

Excel should have a real ETL toolset; and a real presentation toolset.
Excel isn't as powerful as Access is when it comes to ETL.
First and Foremost; Excel can't ETL as well as Access can.

END OF STORY.

Excel isn't as powerful as Access is when it comes to printing.
First and Foremost; Excel can't print as well as Access can.

END OF STORY.

Excel isn't as powerful as Access is when it comes to sharing.
First and Foremost; Excel can't share as well as Access can.

END OF STORY.

Excel isn't as powerful as Access is when it comes to import / export.
First and Foremost; Excel can't import / export as well as Access can.

END OF STORY.

Excel isn't as powerful as Access is when it comes to portability.
First and Foremost; Excel can't do portability as well as Access can.

END OF STORY.

Excel isn't as powerful as Access is when it comes to performance.
First and Foremost; Excel can't perform as well as Access can.

END OF STORY.

Excel isn't as powerful as Access is when it comes to scalability.
First and Foremost; Excel can't SCALE as well as Access can.





Harlan Grove wrote:
aaron.kempf@xxxxxxxxx wrote...
...
you are missing the point.

what choices do you have to update formulas?? find and replace?
what if you need a subquery in order to find out what the formula
should be?

Unlike you, I recognize the advantage of using VBA at least for
building and using development tools. I have a search & replace macro
that uses WSH regular expressions, which means I can tokenize formulas
OR text constants with no ambiguity to whatever detail I need. Using
regular expressions, I don't need 'subqueries', whatever they'd be in a
spread*** context.

You'd need to be familiar with either EMACS or vi to understand what I
mean.

TSQL is just flat out more powerful.
...

For editing formulas?

with databases; you dont need to have duplicate copies of the whole
data in order to sort in 2 different directions

You don't *need* them in any language, even Excel, *IF* you know what
you're doing. But that excludes you.

i can right-click anything in the db world and go 'sort' or 'sort
descending'
...

Fine. And when would this be useful in spreadsheets not being misused
as databases?

.

Loading