rmeekers

Straight quotes are the generic vertical quotation marks which are inserted via the quotes button on a keyboard. There are two variants:

1. the straight single quote (') and 2 .the straight double quote (").

Curly quotes are the quotation marks used in good typography. There are two sets of curly quote characters:

1. Single quotes: the opening single quote (‘) and the closing single quote (’)
2. Double quotes: the opening double quote (“) and the closing double quote (”).

How to use these quotes in a text editor?

rmeekers

Assumptions:

• value to look for is in cell C2
• array to search in: 'email domains'!A:Y
• value to retrieve is in column no 26 (Z)

=ArrayFormula(if(countif('email domains'!A:Y;C2)=0;"";index('email domains'!A:Z;sum(if('email domains'!A:Y=C2;row('email domains'!A:Y))); sum(if('email domains'!A:Y=C2;26)))))

rmeekers

^(\w[\s\w\-\'.]+?)\s?((?:\d+(?:\s?-\s?\d+)?)\s?[a-zA-Z]?)(?:\s?-?\s?)?((?:\/|bus|Bus)\s?.+)?$

rmeekers

[
  {
    "id": "76106b40e1ce3c2f",
    "type": "tab",
    "label": "Toadi to MQTT",
    "disabled": false,
    "info": "",
    "env": []
  },
  {

rmeekers

{
    "author": "Enter Digital – www.enterdigital.coop",
    "description": "The official brand colours of Enter Digital.",
    "palette": [
        {
            "name": "Base Brand Colours",
            "description": "",
            "colors": [
                "#E0F378",
                "#F5F5F5",