Skip to content

Instantly share code, notes, and snippets.

View quickstep25's full-sized avatar
🖥️

Doug Hill quickstep25

🖥️
View GitHub Profile
@quickstep25
quickstep25 / strftime.txt
Created June 19, 2024 00:29 — forked from altamic/strftime.txt
STRFTIME
STRFTIME(3) BSD Library Functions Manual STRFTIME(3)
NAME
strftime, strftime_l -- format date and time
The conversion specifications are copied to the buffer after expansion as
follows:
%A is replaced by national representation of the full weekday name.
Sub WordCount()
Dim Rng As Range, Dn As Range
Dim oMax As Double
Dim K As Variant
Dim Msg As String
Dim vWords As Variant
Dim myWord As Variant
Dim counter As Integer, WordCount As Integer
Set Rng = Range(Range("A1"), Range("A" & Rows.Count).End(xlUp))
@quickstep25
quickstep25 / excel-delete-grouped-rows
Last active June 25, 2021 05:18
When exporting data from another source, such as SSRS, the groups will be maintained when opened up in Excel. This poses a problem when you have total and subtotal lines that were not created by Excel natively. So when you ungroup the rows in Excel,
_
@quickstep25
quickstep25 / vscode-snippets.json
Created August 12, 2020 08:26
Install these snippets into Visual Studio Code and then just copy & paste into the Wiki.
{
"Example Wrapper": {
"prefix": "bsmd",
"body": [
"<div style=\"padding: 1.5rem; margin: 0; border: 0.2rem solid #F8F9FA;\">",
"",
"$TM_SELECTED_TEXT",
"",
"</div>"
],
@quickstep25
quickstep25 / quicken_import.csv
Last active August 14, 2020 11:56
# Mapping - Date = Date - Description = - Notes = Memo - Labels = Tags - Transaction Type = Debit or Credit (don't use negative amounts) - Amount = Amount - Category = Category - Account Name = Reference - Original Description = Unknown ![](https
Date Description Original Description Amount Transaction Type Category Account Name Labels Notes
mixin with(val)
<!-- ko with: !{val} -->
block
<!-- /ko -->
mixin if(val)
<!-- ko if: !{val} -->
block
<!-- /ko -->
@quickstep25
quickstep25 / IMW_UnHide_Sheets.vb
Last active May 4, 2024 22:08
Code to unhide all Excel worksheets within a workbook.
' PASTE INTO IMMEDIATE WINDOW
for each sh in worksheets: sh.visible=true: next sh
@quickstep25
quickstep25 / git_setup_useful_commands.txt
Last active June 2, 2020 17:09
Git Setup and Useful Commands
Setup
-----
git clone <repo>
clone the repository specified by <repo>; this is similar to "checkout" in
some other version control systems such as Subversion and CVS
Add colors to your ~/.gitconfig file:
[color]
@quickstep25
quickstep25 / pgl_dev_ops_basic_pipeline.yml
Last active June 2, 2020 17:09
Azure DevOps Build / Release / Deploy Stage Pipeline
stages:
- stage: Build
jobs:
- job: Build
pool:
vmImage: 'Ubuntu-16.04'
continueOnError: true
steps:
- script: echo my first build job
- stage: Deploy
@quickstep25
quickstep25 / last_login_access.txt
Last active June 2, 2020 17:09
MacOS Login Attempts
-- Show Last Login(s)
last -10
-- Show Successful Logins
grep -i login /var/log/system.log
-- Show Failed Attempts
grep -i authe /var/log/system.log