Skip to content

Instantly share code, notes, and snippets.

View younes-alouani's full-sized avatar
🎯
Focusing

Youna younes-alouani

🎯
Focusing
  • Rabat
View GitHub Profile
# Install dependencies only when needed
FROM node:14-alpine AS deps
# Check https://github.com/nodejs/docker-node/tree/b4117f9333da4138b03a546ec926ef50a31506c3#nodealpine to understand why libc6-compat might be needed.
RUN apk add --no-cache libc6-compat
WORKDIR /app
# Install dependencies based on the preferred package manager
COPY package.json yarn.lock ./
RUN yarn install --frozen-lockfile
@younes-alouani
younes-alouani / slug-for-spreadsheet.md
Created April 18, 2022 11:30
Slugify text (remove diacritics from it) with "simple" spreadsheet formula (Google, Excel, ...)

Lower string and replace " " for "-", removes : "/" , "(" , ")", "," and replaces "&" with "and"

=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(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(LOWER(B2),"š","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")," ", "-"),",",""),"/","-"),"(",""),")",""),"&","and")