Erik Bleske erik4github

If you're reading the Magento 2 devdocs for custom attributes, you'll probably notice they give an example of creating a new custom attribute like so:

<?php

namespace Magento\Customer\Setup\Patch\Data;

use Magento\Customer\Model\Customer;
use Magento\Customer\Setup\CustomerSetupFactory;

Fix symlinks (2.3)

In vendor\magento\framework\View\Element\Template\File\Validator.php

    protected function isPathInDirectories($path, $directories)
    {
        if (!is_array($directories)) {
            $directories = (array)$directories;
 }

Works for landing pages & pages like /this-is-how-a-url-shows-up-in-the-report/

^\/?(\[?.+\=.*)

VLOOKUP, XLOOKUP, and INDEX/MATCH

Example: Looking up a SKU to return a price.

Note that C is the the column where the SKU is located in, and H is the end of the column. The price is located in column G, so 5 columns away from C.

' Where A2 is the SKU you're looking up in the current sheet and SKU_Price_Table is a Table in another sheet '
=VLOOKUP(A2, SKU_Prices_Table!C:H, 5, FALSE)

Note that if you have numbers and text mixed together, VLOOKUP will only return the matching text columns (e.g. a SKU that is just 123 and a SKU that is F-123, VLOOKUP will return N/A for 123 even if there is a match).

Does Not Contain Question Marks (?) - Useful for Excluding Query Parameters in Reports

^[^\?]*$

Filter By Excluding Matching Regex:

^[^?]+(?.*)

	const fs = require('fs');
	const { once } = require('events');
	const readline = require('readline');

	const zip = (keys, vals) =>
	keys.reduce((currentObj, prop, idx) => {
	currentObj[prop] = vals[idx];
	return currentObj;
	}, {});

	javascript:(function(window){
	var selection = window.getSelection();
	selection.baseNode.parentElement.innerText = selection.baseNode.textContent.toLowerCase();
	})(window);

	example_dict = {
	'hello': {
	'world': {
	'nest': 'end'
	}
	}
	}

	def find_key(d, value):
	for k,v in d.items():

	// if needed
	const flat = arr => [].concat(...arr);

	const swapArrow = arr => arr.map(v => ([v[0], v[1]] = [v[1], v[0]]));

	const swapWithReverse = arr => arr.map(v => v.reverse());

	function swap(arr) {
	let swapped = [];
	for (let i = 0; i < arr.length; i++) {

	// use history.replaceState() instead of history.pushState() in order to not spam browser history

	var f = ['🌑', '🌒', '🌓', '🌔', '🌝', '🌖', '🌗', '🌘'];

	function loop() {
	location.hash = f[Math.floor((Date.now()/100)%f.length)];

	setTimeout(loop, 50);
	}