Jan-Philipp Igla jpigla

Excel Tipps & Tricks

=RECHTS(A2;LÄNGE(A2)-FINDEN("@";WECHSELN(A2;"/";"@";LÄNGE(A2)-LÄNGE(WECHSELN(A2;"/";"")));1))

=DATUM(1970;1;1)+(LINKS([ZELLE];10)/86400)

Update & Upgrade system/server
sudo apt -y update && sudo apt -y upgrade && sudo apt -y dist-upgrade

Reboot server
sudo shutdown -r now

Extract a domain name
^(?:.*:\/\/)?(?:www\.)?([^:\/]*).*$

Look for a specific domain name
\"(https?:\/\/(w{3}\.)?example.com\/?.*?)\"

Extract CID from URL (CoBi/AuBi)
.*[\-|\_](\d.*)\.html

pd.options.display.max_rows = 4000

Service	URL
Amazon	https://completion.amazon.co.uk/search/complete?method=completion&mkt=4&l=de_DE&client=amazon-search-ui&search-alias=aps&q=[KEYWORD]
Bing	https://www.bing.com/AS/Suggestions?mkt=de-de&cvid=100&qry=[KEYWORD]
eBay	https://autosug.ebaystatic.com/autosug?sId=77&callback=c&kwd=[KEYWORD]
Google	https://www.google.com/complete/search?client=psy-ab&hl=de&q=[KEYWORD], https://suggestqueries.google.com/complete/search?client=psy-ab&hl=de&q=[KEYWORD]
Google-Shopping	https://www.google.com/complete/search?client=psy-ab&hl=de&ds=sh&q=[KEYWORD]
Google-News/Videos/Images	https://www.google.com/complete/search?client=psy-ab&hl=de&ds=i&q=[KEYWORD]
Youtube	https://clients1.google.com/complete/search?client=youtube&hl=de&ds=yt&q=[KEYWORD]

	STATUS_CODES: {
	'100': 'Continue',
	'101': 'Switching Protocols',
	'102': 'Processing',
	'103': 'Early Hints',
	'200': 'OK',
	'201': 'Created',
	'202': 'Accepted',
	'203': 'Non-Authoritative Information',
	'204': 'No Content',

	# Chrome Browser

	## Delete all Other Search Engines in Chrome Settings (chrome://settings/searchEngines -> use Console)
	settings.SearchEnginesBrowserProxyImpl.prototype.getSearchEnginesList()
	.then(function(val) {
	val.others.sort(function(a, b) { return b.modelIndex - a.modelIndex; });
	val.others.forEach(function(engine) {
	settings.SearchEnginesBrowserProxyImpl.prototype.removeSearchEngine(engine.modelIndex);
	});
	});