|
|
That's unusual - normally it's Isopropyl alcohol, not Methyl. And it's much nastier stuff. I have a spray bottle of the stuff for cleaning my 3D printer, and there is no way I'd drink that!
"I have no idea what I did, but I'm taking full credit for it." - ThisOldTony
"Common sense is so rare these days, it should be classified as a super power" - Random T-shirt
AntiTwitter: @DalekDave is now a follower!
|
|
|
|
|
I also keep a bottle of isopropyl for general cleaning purposes (and for sanitizing used covid masks). I will NEVER drink the stuff!
Get me coffee and no one gets hurt!
|
|
|
|
|
I drink to that, cheers!
|
|
|
|
|
Fake news. It just depends the the snacks! I do recommend you try it together wi
"If we don't change direction, we'll end up where we're going"
|
|
|
|
|
A case where last call for alcohol REALLY was last call for alcohol.
"the debugger doesn't tell me anything because this code compiles just fine" - random QA comment
"Facebook is where you tell lies to your friends. Twitter is where you tell the truth to strangers." - chriselst
"I don't drink any more... then again, I don't drink any less." - Mike Mullikins uncle
modified 23-Nov-20 17:35pm.
|
|
|
|
|
This should solve your problems: Thors Hammer 10 L Kanister[^]
I have lived with several Zen masters - all of them were cats.
His last invention was an evil Lasagna. It didn't kill anyone, and it actually tasted pretty good.
|
|
|
|
|
|
True story! 
|
|
|
|
|
Harry Potter was great at installing software – but after all he was a Setup Wizard.
"I have no idea what I did, but I'm taking full credit for it." - ThisOldTony
"Common sense is so rare these days, it should be classified as a super power" - Random T-shirt
AntiTwitter: @DalekDave is now a follower!
|
|
|
|
|
Where did that come from? I wander.
"If we don't change direction, we'll end up where we're going"
|
|
|
|
|
Does he need to Spell it out for you? 
Anything that is unrelated to elephants is irrelephant
Anonymous
-
The problem with quotes on the internet is that you can never tell if they're genuine
Winston Churchill, 1944
-
Never argue with a fool. Onlookers may not be able to tell the difference.
Mark Twain
|
|
|
|
|
Cast in a different light, you post had me Rowling on the floor with laughter.
| Ravings en masse^ |
|---|
| "The difference between genius and stupidity is that genius has its limits." - Albert Einstein | | "If you are searching for perfection in others, then you seek disappointment. If you seek perfection in yourself, then you will find failure." - Balboos HaGadol Mar 2010 |
modified 23-Nov-20 13:56pm.
|
|
|
|
|
... and he had the scar to prove it!
Freedom is the freedom to say that two plus two make four. If that is granted, all else follows.
-- 6079 Smith W.
|
|
|
|
|
He's an install wizard. There has to be a twist.
"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer
|
|
|
|
|
I was updating the queries to generate a monster report (~33k rows, 1400 columns, 46m cells of data) and after seeing the output file wasn't the same size in the new version needed a way to compare them and see where they were different. Since Excel had no problems opening the file, or a file that had both versions of the report pasted into different tabs I figured I'd just do a 3rd tab to compare them. So I wrote my basic formula =tab1!A1=tab2!A1 selected all 46m cells on the 3rd tab and hit Ctrl-V figuring I'd have an searchable diff to look at where my results changed in a few seconds.
It took 50 minutes to complete, and peaked at 14GB of ram consumed and finished out at 12gb (only 2 after a close/reopen). The file with the formulas in it was also laggy as hell, although I managed to solve that by pasting the comparison as values into a 4th tab and deleting the 3rd. But I still need to figure out what actually went wrong with the report itself. 
Proving once again that age old bit of wisdom: I had a problem. I used regular expressions Excel, now I have two problems. 
Did you ever see history portrayed as an old man with a wise brow and pulseless heart, weighing all things in the balance of reason?
Is not rather the genius of history like an eternal, imploring maiden, full of fire, with a burning heart and flaming soul, humanly warm and humanly beautiful?
--Zachris Topelius
Training a telescope on one’s own belly button will only reveal lint. You like that? You go right on staring at it. I prefer looking at galaxies.
-- Sarah Hoyt
|
|
|
|
|
Does a WinMerge or BeyondCompare not help?
I find them quite powerful, at least to find the differences in very similar files.
If a lot of differences, then they can suck as well.
M.D.V. 
If something has a solution... Why do we have to worry about?. If it has no solution... For what reason do we have to worry about?
Help me to understand what I'm saying, and I'll explain it better to you
Rating helpful answers is nice, but saying thanks can be even nicer.
|
|
|
|
|
Do either of those do a good job of showing where within a line things changed? >1400 columns means that just telling me that line 223 is different isn't that helpful; unless they're CSV aware and can tell me what column is different too I'm not sure that any programmers diff tool would be particularly suitable.
Did you ever see history portrayed as an old man with a wise brow and pulseless heart, weighing all things in the balance of reason?
Is not rather the genius of history like an eternal, imploring maiden, full of fire, with a burning heart and flaming soul, humanly warm and humanly beautiful?
--Zachris Topelius
Training a telescope on one’s own belly button will only reveal lint. You like that? You go right on staring at it. I prefer looking at galaxies.
-- Sarah Hoyt
|
|
|
|
|
Does it matter?
If they tell you "lines 234, 567, 1999, and 8812 are different" that knock you down to four lines: extract those to a file (CSV? Text?, XLSX?) as values and compare them - you get the actual differences and you can refer back to the original sheet to find out what the formulae were that generated them.
"I have no idea what I did, but I'm taking full credit for it." - ThisOldTony
"Common sense is so rare these days, it should be classified as a super power" - Random T-shirt
AntiTwitter: @DalekDave is now a follower!
|
|
|
|
|
Compared to being able to see at a glance after finding the first 'FALSE' value that columns EG-EO (among other groups) is immediately useful in a way that getting thousands of changed lines is not (it tells me what went wrong, if not why). If I knew Excel was going to faceplant, and I knew there was going to be a huge number of rows different, I probably could've fumbled around line by line and found what the failure pattern was, likely spending more time at it than it took excel to chug through the comparisons and present the data in a way that made the problem obvious.
Did you ever see history portrayed as an old man with a wise brow and pulseless heart, weighing all things in the balance of reason?
Is not rather the genius of history like an eternal, imploring maiden, full of fire, with a burning heart and flaming soul, humanly warm and humanly beautiful?
--Zachris Topelius
Training a telescope on one’s own belly button will only reveal lint. You like that? You go right on staring at it. I prefer looking at galaxies.
-- Sarah Hoyt
|
|
|
|
|
To be honest... I have never had such long lines.
In what I have done until now, the Beyond Compare (paid product) does all what I need, pretty nicely.
WinMerge is free for home and does a lot, but sometimes is a bit weak.
The biggest problem I see is what I said... if the difference level is small... then they will help.
If the differences number is medium / high... then it will get messed up and probably won't help that much.
M.D.V.
If something has a solution... Why do we have to worry about?. If it has no solution... For what reason do we have to worry about?
Help me to understand what I'm saying, and I'll explain it better to you
Rating helpful answers is nice, but saying thanks can be even nicer.
|
|
|
|
|
yeah, this report's something else.
It's big enough to be the reason why I originally got a copy of MS office despite us mostly being a google docs company at the time. Google wouldn't open the report at all; LibreOffice would but it was too large for it to work well (things like filtering ranged from laggy to timing out and failing all together) with the standard size report; and that was before it grew above Calc's 1024 column limit and it joined Google in noping out.
Did you ever see history portrayed as an old man with a wise brow and pulseless heart, weighing all things in the balance of reason?
Is not rather the genius of history like an eternal, imploring maiden, full of fire, with a burning heart and flaming soul, humanly warm and humanly beautiful?
--Zachris Topelius
Training a telescope on one’s own belly button will only reveal lint. You like that? You go right on staring at it. I prefer looking at galaxies.
-- Sarah Hoyt
|
|
|
|
|
Well... then I would give a shot to the trial version of beyond compare. The trials are 30 days limited but as far as I know they are fully featured.
It does have a left overview panel, and the vertical divided screen where both compared files are. In the main panels the differences in the selected lines are remarked in red.
And there is the option of "only show differences" which would remove all noise (matching parts) from both panels.
What (after the first amount of time to process the differences and so on) I suppose it will reduce the load drastically.
But again... the more differences there are, the messier can get the comparison.
M.D.V.
If something has a solution... Why do we have to worry about?. If it has no solution... For what reason do we have to worry about?
Help me to understand what I'm saying, and I'll explain it better to you
Rating helpful answers is nice, but saying thanks can be even nicer.
|
|
|
|
|
|
It's been long enough since the last time I had to do anything with VBA that I can't get it to run, no.
There's nothing in that code snippet to actually declare a macro for excel to run; and when I slapped a `Sub Macro1() ... End Sub` around all the code before the functions it promptly barfs because something on the `WScript` line is null.
Edit: In any event, I'm 99% sure I fixed the copy/pasto that caused the missing data from the sql queries, and the bug/not finished in the final report generation code that still created sets of columns for all possible X instead of the inadvertently truncated list of Xes actually being sent to the database; and will let Excel whir my fans for an hour over lunch in a bit doublechecking that I actually did fix it all.
Did you ever see history portrayed as an old man with a wise brow and pulseless heart, weighing all things in the balance of reason?
Is not rather the genius of history like an eternal, imploring maiden, full of fire, with a burning heart and flaming soul, humanly warm and humanly beautiful?
--Zachris Topelius
Training a telescope on one’s own belly button will only reveal lint. You like that? You go right on staring at it. I prefer looking at galaxies.
-- Sarah Hoyt
modified 23-Nov-20 11:31am.
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
