Categories
Development User Help

“0: Event not found” when using less command in unix

First ill mention my knowledge in unix is less than basic. I see “0: Event not found” when I open a new terminal, I couldn’t find where it happen but it also mess up with the automatic aliases sourcing. The 2nd time I see this message is when I use the less command. I can […]

Categories
Development User Help

How to return the most recent year from a table of data

I have a range of orders and I need to just display the most recent year a person has ordered. I have tried to chain some if functions together but that hasn’t worked. =IF(OR(C3>0,G3>0,P3>0),G2,””)AND(if(OR(D3>0,H3>0,K3>0,Q3>0),H2,””)and(IF(OR(E3>0,I3>0,L3>0,R3>0),I2,””))) I am not sure if there is a simpler way to say if cells xyz>0 then g but if abc>0 then […]

Categories
Development User Help

Restore Thunderbird’s look/interface?

I have two computers running the same version of Thunderbird. One uses an old, 5+ years, installation and looks like TB always did but on the other machine, where I made a new installation a few weeks ago, it looks and behaves completely different. Googling restore Thunderbird interface and similar just returned results about Firefox […]

Categories
Development User Help

How to create keyboard shortcut in Explorer (Win10)

In Windows 10 I have context menu item with which I can search selected file with the Everything app. The command of it is: “C:\Program Files\Everything\Everything.exe” -name-part “%1” so it is passing name of the file to the app. I’m looking for possibility to have exactly the same functionality, but without context menu. I would […]

Categories
Development User Help

High Pitched Noise from Macbook through Headphone Jack when Displayport Connected

I have the following issue with sound on my 2015 Macbook Pro (10.14.6). Every time I plugin my monitor on the Mini-Displayport port (using a MiniDP->HDMI dongle from Club3D), and I plug in my Logitech 2.1 system (old style Z5’s) using the headphone jack, the speakers play a constant very high pitched sound. As soon […]

Categories
Development User Help

How do I target and close a specific Terminal window in AppleScript?

Background Given the below terminal script, I want to modify the osascript so that instead of targeting the front window I am targeting the specific window that is opened from the AppleScript. terminal: #!/bin/bash # Usage: # terminal [CMD] Open a new terminal window and execute CMD # # Example: # terminal cd “sleep 100” […]

Categories
Development User Help

Count of unique values in part of column only when matching multiple criteria

I am trying to learn to use SUMPRODUCT to count unique values based on multiple criteria and can’t quit get it right. Wildcard does not work on sumproduct. And some cells may be blank. (I am on Mac Excel v 16.33, if that makes a difference.) I need to count the unique date values in […]

Categories
Development User Help

Escape Ampersand in path variable

In my PATH environment variable, there’s C:\Program Files (x86)\MySQL\MySQL Fabric 1.5 & MySQL Utilities 1.5 This screws up the whole PATH — the entries that come afterwards are not taken into account, and my shell does weird things: C:\Users\bowi>echo %PATH% C:\other;C:\path;C:\entries;C:\Program Files (x86)\MySQL\MySQL Fabric 1.5 Der Befehl “MySQL” ist entweder falsch geschrieben oder konnte nicht […]

Categories
Development User Help

How to close a Terminal window using bash and AppleScript without using SystemEvents?

Background I am trying to create a script that when executed, opens a new Terminal.app window executes the desired commands and closes the window when complete. One solution was to use SystemEvents in the AppleScript in order to send CMD+w to the opened terminal window when the process was complete, however, with the new security […]

Categories
Development User Help

How to remove or hide folding line in Notepad++?

How do you remove a black horizontal line that always appears after you fold a block? I have followed one of tips that said to use Settings > Style Configurator > Global Styles > Default Style > Colour Style > Foreground Color and set it to white, but, together with the line, it made the […]