Skip to content

Instantly share code, notes, and snippets.

View iRoberto83's full-sized avatar

Roberto iRoberto83

View GitHub Profile
@pedro-victor
pedro-victor / slug-for-spreadsheet.md
Last active February 29, 2024 10:55
Slugify text (remove diacritics from it) with "simple" spreadsheet formula (Google, Excel, ...)

(Faster) Lowers string

=SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(LOWER(A1),"š","s"),"ž","z"),"à","a"),"á","a"),"â","a"),"ã","a"),"ä","a"),"å","a"),"ç","c"),"è","e"),"é","e"),"ê","e"),"ë","e"),"ì","i"),"í","i"),"î","i"),"ï","i"),"ð","d"),"ñ","n"),"ò","o"),"ó","o"),"ô","o"),"õ","o"),"ö","o"),"ù","u"),"ú","u"),"û","u"),"ü","u"),"ý","y"),"ÿ","y")

(Also fast) Lower string and replace " " for "-"

=SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBS
@karlhillx
karlhillx / macos_high_sierra_apache_php_brew_2018.md
Last active August 1, 2024 16:18
macOS High Sierra Setup: Homebrew + Apache + PHP + MariaDB + SSL

macOS High Sierra Setup: Homebrew + Apache + PHP + MariaDB + SSL

Homebrew Installation

First let's install Homebrew.

$ /bin/bash -c "$(curl -fsSL https://raw.githubusercontent.com/Homebrew/install/master/install.sh)"

@heiswayi
heiswayi / repo-reset.md
Created February 5, 2017 01:32
GitHub - Delete commits history with git commands

First Method

Deleting the .git folder may cause problems in our git repository. If we want to delete all of our commits history, but keep the code in its current state, try this:

# Check out to a temporary branch:
git checkout --orphan TEMP_BRANCH

# Add all the files:
git add -A
@odan
odan / xampp_php7_xdebug.md
Last active August 28, 2024 13:49
Installing Xdebug for XAMPP
@adamdb
adamdb / NERDTree Commands
Last active July 16, 2024 01:54
A list of useful NERDTree commands.
Use the natural Vim navigation keys hjkl to navigate the files.
Press o to open the file in a new buffer or open/close directory.
Press t to open the file in a new tab.
Press i to open the file in a new horizontal split.
Press s to open the file in a new vertical split.
Press p to go to parent directory.
Press r to refresh the current directory.
Press m to launch NERDTree menu inside Vim.
@LucaRosaldi
LucaRosaldi / Elenco Province Italiane
Last active August 6, 2024 15:37
Elenco Province Italiane in vari formati: HTML, PHP, JSON, TXT, Pipe notation (es. Elementor).
# Fonte: Wikipedia
# URL: https://it.wikipedia.org/wiki/Province_d%27Italia
# Aggiornato al: 2022
Agrigento
Alessandria
Ancona
Aosta
Arezzo
Ascoli Piceno