doofusdavid/gist:6072257

Created July 24, 2013 16:42

Star () You must be signed in to star a gist
Fork () You must be signed in to fork a gist

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/doofusdavid/6072257.js"></script>
Save doofusdavid/6072257 to your computer and use it in GitHub Desktop.

Download ZIP

quick and dirty wordpress slug generator in excel for data import from an existing database.

Raw

gistfile1.txt

=LOWER(CLEAN(SUBSTITUTE(TRIM(C2)," ","-")))

ChrisCinelli commented Aug 7, 2015

It obviously depend on your slug algorithm. However in google spreadsheet you can use

=LOWER(SUBSTITUTE(REGEXREPLACE(REGEXREPLACE(TRIM(C2),"[^a-zA-Z0-9\s]",""),"\s{2,}"," ")," ","-"))

In Excel you will have to implement REGEXREPLACE as a macro (it should not be too difficult)

cpescott commented Sep 20, 2017

My gawd I need this - thank you!

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment