Skip to content

Instantly share code, notes, and snippets.

@jeffsmonteiro
Created April 4, 2019 22:41
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save jeffsmonteiro/fcd068d74567ef7602ff24b18a99d431 to your computer and use it in GitHub Desktop.
Save jeffsmonteiro/fcd068d74567ef7602ff24b18a99d431 to your computer and use it in GitHub Desktop.
Use this gist in Google Sheets Script Editor, after save use the function slugify into a cell
function slugify(str) {
str = str.replace(/^\s+|\s+$/g, ''); // trim
str = str.toLowerCase();
// remove accents, swap ñ for n, etc
var from = "ãàáäâẽèéëêìíïîõòóöôùúüûñç·/_,:;";
var to = "aaaaaeeeeeiiiiooooouuuunc------";
for (var i=0, l=from.length ; i<l ; i++) {
str = str.replace(new RegExp(from.charAt(i), 'g'), to.charAt(i));
}
str = str.replace(/[^a-z0-9 -]/g, '') // remove invalid chars
.replace(/\s+/g, '-') // collapse whitespace and replace by -
.replace(/-+/g, '-'); // collapse dashes
return str;
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment