regex
zorg dat de letter A of B altijd gevolgd wordt door een spatie wanneer het direct gevolgd wordt door een cijfer.
re.sub(r"(A|B)(\d)", r"\1 \2", input_string)
swap values of lat/lon coordinate in Google Sheets
from: 5.11699542 52.09363001
to: 52.09363001, 5.11699542
=REGEXREPLACE(A1,"(\-?\d+\.\d+)\s+(\-?\d+\.\d+)","$2, $1")
get domain
domain = re.findall(r"^.+?[^\/:](?=[?\/]|$)",link)
#ie. http://dspace.library.uu.nl
fuzzy regex
see python
non greedy match in python
matches = re.findall(r'(geboren op )(.*?)( te)(.*?)(,)',text) # non greedy
nice visual regex debugger
non greedy img src url's in textfile in SublimeText
" was escaped in textfile by \". In regex you need to escape the \ as well
src=\\".*?\\"
only the middle group:
(?<=src=\\")(.*?)(?=\\")
everything before the first digit
result = re.findall(r'^[^\d]*',address)
replace all non-alphanumeric characters by spaces
=trim(regexreplace(REGEXREPLACE(join(" ",B2,D2,E2,F2),"[^a-zA-Z0-9\-]"," "),"\s+"," "))
in sublimetext middelste groep van 3 groepen vinden
dit vind dus alleen B in (A)(B)(C)
(?<=lastname%2Fp%2Fvalue%2F)(.*)(?=%2Fq%2F)
(?<=birthdate%2Fp%2Fvalue%2F)(.*)(?=%2Fr)
Alles na de laatste slash (filename)
[^/]+$)
Alles voor de laatste slash (pad)
.*\/
zoek alle GUID's in een tekst
[\da-z]{32}
good introduction
find date(s) in a string
str.match(/\d{2}(\D)\d{2}\1\d{4}/g)
//finds one or more instances of dates in this format: 03-04-2018
add brackets around auto links in md files in SublimeText
Find: http://.*
Replace: <$0>
javascript math id= parameter in querystring
var link = "http://aap.com?nav_id=3-1&id=138622&index=14";
var matches = link.match(/&id=([^&]*)/);
var id = matches ? matches[1] : null;
//result: 138622
regexp pal
javascript parse whitespace
let wc = " 7 1312";
wc.split(/,?\s+/).filter(Boolean);
Shiffman about regex
http://shiffman.net/a2z/regex/
Find all URLs starting with http and ending with .html
this works in the SublimeText search function:
(http).*(.html)
Online tools
expr
expr "ok T:83.4 /0.0 B:0.0 /0.0 @:0" : 'ok T:\([0-9]*\.[0-9]*\)'
sed & cut
grep -o '\(T:\)\([0-9]*\.[0-9]*\)' /tmp/UltiFi/ttyACM0/ temp.out | cut -c 3-
grep "spotify:track:" spotify.json | cut -c 16-51
grep "spotify:track:" spotify.json | head -n 1 | cut -c 16-51 # only first result
awk
see [[awk]]