Instituto de la Felicidad

Donate

Links

💠

Shortcuts: * = search all results § = search results + timeline

Notes w/ Search

Search Type

Name

Wiki URL

Wiki Links

Search Box

Title

special:random

Search Box

Fall of the Roman Empire

§Roman Empire

(...)

(George Washington)'s Presidency

Formulas

Format Search Formula


if(prop("Search Type") == "(...)", replaceAll(replace(replace(replaceAll(replaceAll(prop("Name"), "[!@#$%^&*']", ""), " ", "_"), "[^(]*", ""), "[^)]*$", ""), "[()]", ""), if(prop("Search Type") == "Search Box", replaceAll(replaceAll(replaceAll(prop("Search Box"), "[!@#$%^&*'§]", ""), " ", "_"), "[()]", ""), replaceAll(replaceAll(replaceAll(prop("Name"), "[!@#$%^&*'§]", ""), " ", "_"), "[()]", "")))

Breakdown

Line 1


/* If 'Search Type' is "(...)", then ...
remove all special characters in title, 
replace all spaces with underscores(_), 
remove characters before "(",' 
remove characters after ")",' 
and remove all "()" */

if(prop("Search Type") == "(...)", replaceAll(replace(replace(replaceAll(replaceAll(prop("Name"), "[!@#$%^&*']", ""), " ", "_"), "[^(]*", ""), "[^)]*$", ""), "[()]", "")

Line 2


/* If 'Search Type' is "Search Box", then ... 
remove all special characters in search box,
replace all spaces with underscores(_),
and remove all "()" */

if(prop("Search Type") == "Search Box", replaceAll(replaceAll(replaceAll(prop("Search Box"), "[!@#$%^&*'§]", ""), " ", "_"), "[()]", "")

False condition


/* if line 1 and 2 do not apply ...
remove all special characters in title,
replace all spaces with underscores(_),
and replace all "()" with 'empty space.' */

replaceAll(replaceAll(replaceAll(prop("Name"), "[!@#$%^&*'§]", ""), " ", "_"), "[()]", "")))

Wiki URL Formula


if(prop("Search Type") == "Search Box" and contains(prop("Search Box"), "§"), "https://en.wikipedia.org/w/index.php?search=" + replaceAll(prop("format search"), "_", " ") + "+timeline" + "&title=Special%3ASearch&fulltext=1&ns0=1", if(prop("Search Type") == "Search Box" and contains(prop("Search Box"), "*"), "https://en.wikipedia.org/w/index.php?search=" + replaceAll(prop("format search"), "_", " ") + "&title=Special%3ASearch&fulltext=1&ns0=1", if(empty(prop("Name")), "", "https://en.wikipedia.org/wiki/" + prop("format search"))))

Breakdown

Line 1


/* if 'Search Type' is "Search Box" and contained with property 'Search Box' is "§", then combine ...
"https://en.wikipedia.org/w/index.php?search="
property 'format search' 
the word "timline"
and "&title=Special%3ASearch&fulltext=1&ns0=1" */

if(prop("Search Type") == "Search Box" and contains(prop("Search Box"), "§"), "https://en.wikipedia.org/w/index.php?search=" + replaceAll(prop("format search"), "_", " ") + "+timeline" + "&title=Special%3ASearch&fulltext=1&ns0=1"

Line 2


/* if 'Search Type' is "Search Box" and contained with property 'Search Box' is "*", then combine ...
"https://en.wikipedia.org/w/index.php?search="
property 'format search' 
and "&title=Special%3ASearch&fulltext=1&ns0=1" */

if(prop("Search Type") == "Search Box" and contains(prop("Search Box"), "*"), "https://en.wikipedia.org/w/index.php?search=" + replaceAll(prop("format search"), "_", " ") + "&title=Special%3ASearch&fulltext=1&ns0=1"

Line 3


/* if Title is empty, leave cell empty */

if(empty(prop("Name")), ""

False condtion


/* If lines 1-3 do not apply, combine ...
"https://en.wikipedia.org/wiki/"
and property 'format search' */

"https://en.wikipedia.org/wiki/" + prop("format search"))))

Search Wikipedia

Donate