News for hackers. Stuff that matters.
Re:Ask HN: What is the best enterprise software you use ever... by leokennis on Thursday July 16, 2020 @04:44PM (#23863607)
Two:

- UltraEdit. What Photoshop is to images, UltraEdit is to text. The weird thing is, it’s not a super flashy or even immediately intuitive tool. But once you get the hang of it, it never fails to deliver.

- Excel. It’s insane the breadth of stuff you can do with it. And as a tool, it’s equally handy and “oh my God this will save me so much work” for a school teacher as it is for a data analyst and stock broker. It sort of scales infinitely, there is always one more level of complexity/usefulness to unlock.

Re:Ask HN: What is the best enterprise software you use ever... by perl4ever on Thursday July 16, 2020 @10:54PM (#23866504)
I have very mixed feelings about Excel, having been using it intensively over the last year where I never did before. It has a large number of components with overlapping functionality, apparently designed by separate teams at different times, all missing crucial functionality when I want to make some sort of BI type of solution. You have DAX, you have VBA, you have Power Query, you have the Data Model. And every new area I delve into, after I use it for a few hours, starts giving me weird errors and possibly corrupting my file. The latest is a dialog with a button that says "Send a Frown".

Quote from someone that is not me and not my particular issue, but that expresses the sort of problems endemic to Excel and MS software in general:

"When data is refreshed, I get a message box "Send a Frown" at unpredictable, inconsistent intervals. For example, it will work seamlessly for five or six times then suddenly it will fail, and give this "Send a frown" message.

A normal VBA error handler does not deal with this "Send a frown" message. Not even an "On Error Resume next" deals with it. I can thus not capture or step-over the error (err) and deal with it in my code. When the "Send a frown" message appears, the entire process is on hold until I (the human) clicks on "Send a frown" or "Cancel". This is problematic since this process runs 3am in the morning on our servers for about 200 connection refreshes."

Re:Ask HN: What is the best enterprise software you use ever... by csours on Thursday July 16, 2020 @11:41PM (#23866744)
Excel: Is this a date?
Re:Ask HN: What is the best enterprise software you use ever... by kevindong on Thursday July 16, 2020 @11:52PM (#23866810)
Are you scripting Excel to run at 3am?
Re:Ask HN: What is the best enterprise software you use ever... by perl4ever on Friday July 17, 2020 @12:22PM (#23872205)
Me? No. I pity the person who was trying though.
Re:Ask HN: What is the best enterprise software you use ever... by hnick on Friday July 17, 2020 @02:14AM (#23867637)
I got a personal license for UltraEdit years ago too after using it at work (these fancy Electron editors didn't exist back then).

It definitely isn't fancy but it works well for larger files and things like column mode and perl regex searches are just so nice in certain cases. I'm finding it hard to put down especially since I do a lot of Perl and I haven't found a big benefit for an IDE there.

Re:Ask HN: What is the best enterprise software you use ever... by leokennis on Friday July 17, 2020 @05:22PM (#23875748)
That’s what I love about it too.

Open a 200mb horribly formatted text file. Apply some regex find-replace to remove some cruft. Let UE format it into nice columns. All seamlessly, also for huge files.

Re:Ask HN: What is the best enterprise software you use ever... by jasonv on Friday July 17, 2020 @02:20PM (#23873702)
+1 UltraEdit

I've kept UltraEdit around for more than 20 years now. Column editing, especially back when it was introduced, saved my bacon more than a few times.

Re:Ask HN: What is the best enterprise software you use ever... by enchiridion on Thursday July 16, 2020 @05:21PM (#23863963)
Can you give an example of why UltraEdit is better than emacs? Thanks!
Re:Ask HN: What is the best enterprise software you use ever... by eli on Friday July 17, 2020 @12:10AM (#23866911)
I assume Emacs can be made to do anything under the sun, but UltraEdit comes out of the box with a friendly GUI that exposes some fairly complicated text manipulation tools. On some level it's just personal preference and familiarity.
Re:Ask HN: What is the best enterprise software you use ever... by martinrame on Thursday July 16, 2020 @10:52PM (#23866489)
:%s/emacs/vim/g