davestewart

Environment

Business

• location
• likelihood of going bust

Ambience

• quietness

davestewart

Sub Prepare_CSV()
    '
    ' Prepare Barclays bank CSV export
    '
    ' - formats number, date and amount columns
    ' - splits memo column
    ' - trims resulting cells
    ' - consolidates amazon payees
    ' - copies data to clipboard
    '

davestewart

Type Region
    src As Range
    col As Long
End Type

Sub Copy_Columns()
    '
    ' This Excel macro copies columns from a <source> sheet to a <target> sheet:
    '
    ' - by default, sheets 1 and 2 will be used as <source> and <target>

davestewart

group	name	emojis
positive
	winning	🥳😎🤩🤑🤓🤠😇🫡
	cheeky	😏😉😋😛😝😜🤪
	happy	🙂🙃😀😃😁😄😆😅😂🤣
	content	😌☺️😊🤗🥰
	amorous	😗😙😚😘😍
neutral
	shy	🫢🤭

davestewart

let values = []
let scores = []

function prepare (length = 10_000_000) {
  values = (new Array(length)).fill(1).map((e, i) => i)
}

function forIn () {
  const output = []
  for (let i = 0; i < values.length; i++) {

davestewart

javascript: document.querySelectorAll('*').forEach(e => {
  if (e.childNodes.length === 1 && e.childNodes[0].nodeType === Element.TEXT_NODE) {
    if (e.innerText && e.innerText === e.innerText.toUpperCase()) {
      e.innerText = e.innerText.toLowerCase()
        .replace(/^\w|\.\s+\w/gm, t => t.toUpperCase())
        .replace(/\si\s/, ' I ');
    }
  }
});

davestewart

const CSP = require('./csp')

// ---------------------------------------------------------------------------------------------------------------------
// variables
// ---------------------------------------------------------------------------------------------------------------------

const csp = `script-src 'self' *; img-src data: *`

const isDev = true

davestewart

/*
 * Typora GitHub user theme
 *
 * Makes markdown docs look *exactly* like they do on GitHub
 *
 * To install, drop in your Typora themes folder and open a new window
 */
body {
  font-family: BlinkMacSystemFont, "Segoe UI", "Noto Sans", Helvetica, Arial, sans-serif, "Apple Color Emoji", "Segoe UI Emoji";
  font-size: 16px;

davestewart

// modules/content-indexer.ts
import Fs from 'fs'
import Path from 'path'
import { defineNuxtModule, extendPages, extendRouteRules } from '@nuxt/kit'
import { ModuleOptions, Nuxt } from '@nuxt/schema'
import { MountOptions } from '@nuxt/content'

const name = 'content-indexer'

export default defineNuxtModule({

davestewart

export function isObject (value?: unknown): boolean {
  return !!value && typeof value === 'object'
}

export function isPlainObject (value?: unknown): boolean {
  return isObject(value) && !Array.isArray(value)
}

export function isEmpty (value?: unknown): boolean {
  if (value === null || value === undefined) {