Skip to content

Instantly share code, notes, and snippets.

View estevecastells's full-sized avatar
🎯

Esteve Castells estevecastells

🎯
17 followers · 9 following
View GitHub Profile
@estevecastells
estevecastells / Sort string alphabetically in Excel VBA
Created December 20, 2019 14:00
Function fncSortStr(strPassed As String) As String
Dim Temp As String
Dim I As Integer
While Len(strPassed)
Temp = Left(strPassed, 1)
For I = 2 To Len(strPassed)
If Mid(strPassed, I, 1) < Temp Then
Temp = Mid(strPassed, I, 1)
@estevecastells
estevecastells / Open two instances of Screaming Frog
Created February 12, 2020 13:35
### Open terminal, paste this
open -n /Applications/Screaming\ Frog\ SEO\ Spider.app/
@estevecastells
estevecastells / List of Stopwords (English)
Created February 20, 2020 09:11
i
me
my
myself
we
our
ours
ourselves
you
your
@estevecastells
estevecastells / Blacklist in English
Created February 20, 2020 13:16
2 girls 1 cup
2g1c
4r5e
5h1t
5hit
5ht
666
@$$
a s s
a s shole
@estevecastells
estevecastells / Regex blacklist of words
Created February 20, 2020 13:24
2 girls 1 cup|2g1c|4r5e|5h1t|5hit|5ht|666|@$$|a s s|a s shole|a55|a55hole|a_s_s|abbo|abeed|abuse|acrotomophilia|addicts|aeolus|africoon|ahole|alabama hot pocket|alaskan pipeline|alligator bait|alligatorbait|amcik|anal|analannie|analprobe|analsex|andskota|anilingus|anus|apeshit|ar5e|arabush|arabushs|areola|areole|argie|arian|armo|armos|aroused|arrse|arschloch|arse|arsehole|aryan|ash0le|ash0les|asholes|ass monkey|ass|ass-fucker|ass-hat|ass-pirate|assbag|assbagger|assbandit|assbang|assbanged|assbanger|assbangs|assbite|assblaster|assclown|asscock|asscowboy|asscracker|asses|assface|assfuck|assfucker|assfukka|assgoblin|assh0le|assh0lez|asshat|asshead|assho1e|asshole|assholes|assholz|asshopper|asshore|assjacker|assjockey|asskiss|asskisser|assklown|asslick|asslicker|asslover|assman|assmaster|assmonkey|assmunch|assmuncher|assnigger|asspacker|asspirate|asspuppies|assrammer|assranger|assshit|assshole|asssucker|asswad|asswhole|asswhore|asswipe|asswipes|auto erotic|autoerotic|ayir|azazel|azz|azzhole|b a s t a r d|b i t c
@estevecastells
estevecastells / VBA Regex to find special chars in Excel
Last active April 15, 2020 12:17
Function RegExCheck(objCell As Range, strPattern As String)
Dim RegEx As Object
Set RegEx = CreateObject("VBScript.RegExp")
RegEx.Global = True
RegEx.Pattern = strPattern
If RegEx.Replace(objCell.Value, "") = objCell.Value Then
RegExCheck = 0
Else
@estevecastells
estevecastells / Migrate domain to another domain's subfolder
Created August 29, 2020 12:58
<IfModule mod_rewrite.c>
RewriteEngine On
RewriteCond %{HTTP_HOST} ^old\.info$ [OR]
RewriteCond %{HTTP_HOST} ^www\.old\.info$
RewriteRule (.*)$ https://new.com/path/$1 [R=301,L]
</IfModule>
@estevecastells
estevecastells / Console function to select all checkboxes in a page
Created March 18, 2022 10:36
Console function to select all checkboxes in a page
(function() {
var aa = document.querySelectorAll("input[type=checkbox]");
for (var i = 0; i < aa.length; i++){
aa[i].click();
}
})()
@estevecastells
estevecastells / Xpath List
Created November 22, 2022 13:38
### Select Submitted sitemaps in GSC with a CSS class to export them without having to manually copy paste - it can be that the class name in itself changes so check since it's dynamic to avoid scraping by GSC
//*[contains(@class, 'XgRaPc AB6Eee RVEMNe XL1mme')]
@estevecastells
estevecastells / 12ft.io bookmark to directly go to read cached article
Created January 16, 2023 11:42
javascript:(function(){ window.location.href='https://12ft.io/proxy?q=%27+encodeURIComponent(location.href); })();