RegEx Pattern Matching - Revision history

40166222 at 19:55, 21 June 2018

2018-06-21T19:55:36Z

← Older revision		Revision as of 19:55, 21 June 2018
Line 6:		Line 6:
	You can use <code>'$regex': "^B"</code> to get all the countries that start with B.		You can use <code>'$regex': "^B"</code> to get all the countries that start with B.
	<p class="strong">Find the countries that start with Y</p>		<p class="strong">Find the countries that start with Y</p>
	<pre class="def"><nowiki>db.world.find({"name": {'$regex': "^Y"}}, {"name": 1, "_id": 0}).pretty()</nowiki></pre>		<pre class="def"><nowiki>db.world.find({"name": {'$regex': "^Y"}}, {"name": 1, "_id": 0}).pretty();</nowiki></pre>
	</div>		</div>

Line 12:		Line 12:
	You can use <code>'$regex':"a$"</code> to get all the countries that end with a.		You can use <code>'$regex':"a$"</code> to get all the countries that end with a.
	<p class="strong">Find the countries that end with y</p>		<p class="strong">Find the countries that end with y</p>
	<pre class="def"><nowiki>db.world.find({"name": {'$regex': "y$"}}, {"name": 1, "_id": 0}).pretty()</nowiki></pre>		<pre class="def"><nowiki>db.world.find({"name": {'$regex': "y$"}}, {"name": 1, "_id": 0}).pretty();</nowiki></pre>
	</div>		</div>

Line 18:		Line 18:
	Luxembourg has an <b>x</b>, so does one other country, list them both		Luxembourg has an <b>x</b>, so does one other country, list them both
	<p class="strong">Find the countries that contain the letter x</p>		<p class="strong">Find the countries that contain the letter x</p>
	<pre class="def"><nowiki>db.world.find({"name": {'$regex': "x"}}, {"name": 1, "_id": 0}).pretty()</nowiki></pre>		<pre class="def"><nowiki>db.world.find({"name": {'$regex': "x"}}, {"name": 1, "_id": 0}).pretty();</nowiki></pre>
	</div>		</div>

Line 24:		Line 24:
	Iceland and Switzerland end with <b>land</b> but where are the others?		Iceland and Switzerland end with <b>land</b> but where are the others?
	<p class="strong">Find the countries that end with land</p>		<p class="strong">Find the countries that end with land</p>
	<pre class="def"><nowiki>db.world.find({"name": {'$regex': "land$"}}, {"name": 1,"_id": 0}).pretty()</nowiki></pre>		<pre class="def"><nowiki>db.world.find({"name": {'$regex': "land$"}}, {"name": 1,"_id": 0}).pretty();</nowiki></pre>
	</div>		</div>

Line 31:		Line 31:
	You can use <code>.*</code> to match any amount of any characters except newlines.		You can use <code>.*</code> to match any amount of any characters except newlines.
	<p class="strong">Find the countries that start with C and end with ia</p>		<p class="strong">Find the countries that start with C and end with ia</p>
	<pre class="def"><nowiki>db.world.find({"name": {'$regex': "^C.*ia$"}},{"name": 1, "_id": 0}).pretty()</nowiki></pre>		<pre class="def"><nowiki>db.world.find({"name": {'$regex': "^C.*ia$"}},{"name": 1, "_id": 0}).pretty();</nowiki></pre>
	</div>		</div>

Line 37:		Line 37:
	Greece has a double <b>e</b>, who has a double <b>o</b>?<br/>		Greece has a double <b>e</b>, who has a double <b>o</b>?<br/>
	<p class="strong">Find the country that has oo in its name</p>		<p class="strong">Find the country that has oo in its name</p>
	<pre class="def"><nowiki>db.world.find({"name": {'$regex': "oo"}},{"name": 1, "_id": 0}).pretty()</nowiki></pre>		<pre class="def"><nowiki>db.world.find({"name": {'$regex': "oo"}},{"name": 1, "_id": 0}).pretty();</nowiki></pre>
	</div>		</div>

Line 44:		Line 44:
	<p class="strong">Find the countries that have three or more letter a.</p>		<p class="strong">Find the countries that have three or more letter a.</p>
	<code>[Aa] matches both capital and lowercase A.</code>		<code>[Aa] matches both capital and lowercase A.</code>
	<pre class="def"><nowiki>db.world.find({"name": {'$regex': "(.[aA].){3}"}}, {"name": 1, "_id": 0}).pretty()</nowiki></pre>		<pre class="def"><nowiki>db.world.find({"name": {'$regex': "(.[aA].){3}"}}, {"name": 1, "_id": 0}).pretty();</nowiki></pre>
	</div>		</div>

Line 51:		Line 51:
	<code>.*</code> Indicates zero or more characters, <code>.</code> indicates just one.		<code>.*</code> Indicates zero or more characters, <code>.</code> indicates just one.
	<p class="strong">Find the countries that have "t" as the second character.</p>		<p class="strong">Find the countries that have "t" as the second character.</p>
	<pre class="def"><nowiki>db.world.find({"name": {'$regex': "^.t"}}, {"name": 1, "_id": 0}).pretty()</nowiki></pre>		<pre class="def"><nowiki>db.world.find({"name": {'$regex': "^.t"}}, {"name": 1, "_id": 0}).pretty();</nowiki></pre>
	</div>		</div>

Line 57:		Line 57:
	Les<b>o</b>th<b>o</b> and M<b>o</b>ld<b>o</b>va both have two o characters seperated by two other characters.		Les<b>o</b>th<b>o</b> and M<b>o</b>ld<b>o</b>va both have two o characters seperated by two other characters.
	<p class="strong">Find the countries that have two "o" characters separated by two others.</p>		<p class="strong">Find the countries that have two "o" characters separated by two others.</p>
	<pre class="def"><nowiki>db.world.find({"name": {'$regex': "o..o"}}, {"name": 1, "_id": 0}).pretty()</nowiki></pre>		<pre class="def"><nowiki>db.world.find({"name": {'$regex': "o..o"}}, {"name": 1, "_id": 0}).pretty();</nowiki></pre>
	</div>		</div>

Line 63:		Line 63:
	Cuba and Togo have four character names.		Cuba and Togo have four character names.
	<p class="strong">Find the countries that have exactly four characters</p>		<p class="strong">Find the countries that have exactly four characters</p>
	<pre class="def"><nowiki>db.world.find({"name": {'$regex': "^.{4}$"}}, {"name": 1, "_id": 0}).pretty()</nowiki></pre>		<pre class="def"><nowiki>db.world.find({"name": {'$regex': "^.{4}$"}}, {"name": 1, "_id": 0}).pretty();</nowiki></pre>
	</div>		</div>

Line 74:		Line 74:
	</div>		</div>
	<p class="strong">Find the country where the name is the capital city.</p>		<p class="strong">Find the country where the name is the capital city.</p>
	<pre class="def"><nowiki>db.world.find({"$where":"this.name === this.capital"}, {"name": 1, "capital": 1, "_id": 0}).pretty()</nowiki></pre>		<pre class="def"><nowiki>db.world.find({"$where":"this.name === this.capital"}, {"name": 1, "capital": 1, "_id": 0}).pretty();</nowiki></pre>
	</div>		</div>

Line 80:		Line 80:
	The capital of <b>Mexico</b> is <b>Mexico City</b>. Show all the countries where the capital has the country together with the word "City".		The capital of <b>Mexico</b> is <b>Mexico City</b>. Show all the countries where the capital has the country together with the word "City".
	<p class="strong">Find the country where the capital is the country plus "City".</p>		<p class="strong">Find the country where the capital is the country plus "City".</p>
	<pre class="def"><nowiki>db.world.find({"$where": "this.capital === this.name + ' City'"},{"name": 1, "capital": 1, "_id": 0}).pretty()</nowiki></pre>		<pre class="def"><nowiki>db.world.find({"$where": "this.capital === this.name + ' City'"},{"name": 1, "capital": 1, "_id": 0}).pretty();</nowiki></pre>
	</div>		</div>

Line 86:		Line 86:
	<p class="strong">Find the capital and the name where the capital includes the name of the country.</p>		<p class="strong">Find the capital and the name where the capital includes the name of the country.</p>
	You should include countries like <b>Luxembourg</b> where the capital is <b>Luxembourg</b>, and countries like <b>Mexico</b> where the capital is <b>Mexico City</b>		You should include countries like <b>Luxembourg</b> where the capital is <b>Luxembourg</b>, and countries like <b>Mexico</b> where the capital is <b>Mexico City</b>
	<pre class="def"><nowiki>db.world.find({"$where": "this.capital.match(this.name)"}, {"name": 1, "capital": 1, "_id": 0}).pretty()</nowiki></pre>		<pre class="def"><nowiki>db.world.find({"$where": "this.capital.match(this.name)"}, {"name": 1, "capital": 1, "_id": 0}).pretty();</nowiki></pre>
	</div>		</div>

Line 98:		Line 98:
	<code>.*</code> is the same as '0 or more characters' and <code>.+</code> is the same as "at least one character"		<code>.*</code> is the same as '0 or more characters' and <code>.+</code> is the same as "at least one character"
	</div>		</div>
	<pre class="def"><nowiki>db.world.find({"$where": "this.capital.match(new RegExp('^' + this.name + '.+$$'))"}, {"name": 1, "capital": 1, "_id": 0}).pretty()</nowiki></pre>		<pre class="def"><nowiki>db.world.find({"$where": "this.capital.match(new RegExp('^' + this.name + '.+$$'))"}, {"name": 1, "capital": 1, "_id": 0}).pretty();</nowiki></pre>
	</div>		</div>

40166222 at 09:35, 15 June 2018

2018-06-15T09:35:54Z

← Older revision		Revision as of 09:35, 15 June 2018
Line 4:		Line 4:

	<div class="q" data-lang="mongo">		<div class="q" data-lang="mongo">
	You can use <code>'$regex':"^B"</code> to get all the countries that start with B.		You can use <code>'$regex': "^B"</code> to get all the countries that start with B.
	<p class="strong">Find the countries that start with Y</p>		<p class="strong">Find the countries that start with Y</p>
	<pre class="def"><nowiki>db.world.find({"name": {'$regex': "^Y"}},{"name": 1, "_id": 0}).pretty()</nowiki></pre>		<pre class="def"><nowiki>db.world.find({"name": {'$regex': "^Y"}}, {"name": 1, "_id": 0}).pretty()</nowiki></pre>
	</div>		</div>

40166222 at 09:34, 15 June 2018

2018-06-15T09:34:21Z

← Older revision		Revision as of 09:34, 15 June 2018
Line 6:		Line 6:
	You can use <code>'$regex':"^B"</code> to get all the countries that start with B.		You can use <code>'$regex':"^B"</code> to get all the countries that start with B.
	<p class="strong">Find the countries that start with Y</p>		<p class="strong">Find the countries that start with Y</p>
	<pre class="def">db.world.find({"name":{'$regex':"^Y"}},{"name":1,"_id":0}).pretty()</pre>		<pre class="def"><nowiki>db.world.find({"name": {'$regex': "^Y"}},{"name": 1, "_id": 0}).pretty()</nowiki></pre>
	</div>		</div>

Line 12:		Line 12:
	You can use <code>'$regex':"a$"</code> to get all the countries that end with a.		You can use <code>'$regex':"a$"</code> to get all the countries that end with a.
	<p class="strong">Find the countries that end with y</p>		<p class="strong">Find the countries that end with y</p>
	<pre class="def">db.world.find({"name": {'$regex': "y$"}}, {"name": 1, "_id": 0}).pretty()</pre>		<pre class="def"><nowiki>db.world.find({"name": {'$regex': "y$"}}, {"name": 1, "_id": 0}).pretty()</nowiki></pre>
	</div>		</div>

Line 18:		Line 18:
	Luxembourg has an <b>x</b>, so does one other country, list them both		Luxembourg has an <b>x</b>, so does one other country, list them both
	<p class="strong">Find the countries that contain the letter x</p>		<p class="strong">Find the countries that contain the letter x</p>
	<pre class="def">db.world.find({"name": {'$regex': "x"}}, {"name": 1, "_id": 0}).pretty()</pre>		<pre class="def"><nowiki>db.world.find({"name": {'$regex': "x"}}, {"name": 1, "_id": 0}).pretty()</nowiki></pre>
	</div>		</div>

Line 24:		Line 24:
	Iceland and Switzerland end with <b>land</b> but where are the others?		Iceland and Switzerland end with <b>land</b> but where are the others?
	<p class="strong">Find the countries that end with land</p>		<p class="strong">Find the countries that end with land</p>
	<pre class="def">db.world.find({"name": {'$regex': "land$"}}, {"name": 1,"_id": 0}).pretty()</pre>		<pre class="def"><nowiki>db.world.find({"name": {'$regex': "land$"}}, {"name": 1,"_id": 0}).pretty()</nowiki></pre>
	</div>		</div>

Line 31:		Line 31:
	You can use <code>.*</code> to match any amount of any characters except newlines.		You can use <code>.*</code> to match any amount of any characters except newlines.
	<p class="strong">Find the countries that start with C and end with ia</p>		<p class="strong">Find the countries that start with C and end with ia</p>
	<pre class="def">db.world.find({"name": {'$regex': "^C.*ia$"}},{"name": 1, "_id": 0}).pretty()</pre>		<pre class="def"><nowiki>db.world.find({"name": {'$regex': "^C.*ia$"}},{"name": 1, "_id": 0}).pretty()</nowiki></pre>
	</div>		</div>

Line 37:		Line 37:
	Greece has a double <b>e</b>, who has a double <b>o</b>?<br/>		Greece has a double <b>e</b>, who has a double <b>o</b>?<br/>
	<p class="strong">Find the country that has oo in its name</p>		<p class="strong">Find the country that has oo in its name</p>
	<pre class="def">db.world.find({"name": {'$regex': "oo"}},{"name": 1, "_id": 0}).pretty()</pre>		<pre class="def"><nowiki>db.world.find({"name": {'$regex': "oo"}},{"name": 1, "_id": 0}).pretty()</nowiki></pre>
	</div>		</div>

Line 44:		Line 44:
	<p class="strong">Find the countries that have three or more letter a.</p>		<p class="strong">Find the countries that have three or more letter a.</p>
	<code>[Aa] matches both capital and lowercase A.</code>		<code>[Aa] matches both capital and lowercase A.</code>
	<pre class="def">db.world.find({"name": {'$regex': "(.[aA].){3}"}}, {"name": 1, "_id": 0}).pretty()</pre>		<pre class="def"><nowiki>db.world.find({"name": {'$regex': "(.[aA].){3}"}}, {"name": 1, "_id": 0}).pretty()</nowiki></pre>
	</div>		</div>

Line 51:		Line 51:
	<code>.*</code> Indicates zero or more characters, <code>.</code> indicates just one.		<code>.*</code> Indicates zero or more characters, <code>.</code> indicates just one.
	<p class="strong">Find the countries that have "t" as the second character.</p>		<p class="strong">Find the countries that have "t" as the second character.</p>
	<pre class="def">db.world.find({"name": {'$regex': "^.t"}}, {"name": 1, "_id": 0}).pretty()</pre>		<pre class="def"><nowiki>db.world.find({"name": {'$regex': "^.t"}}, {"name": 1, "_id": 0}).pretty()</nowiki></pre>
	</div>		</div>

Line 57:		Line 57:
	Les<b>o</b>th<b>o</b> and M<b>o</b>ld<b>o</b>va both have two o characters seperated by two other characters.		Les<b>o</b>th<b>o</b> and M<b>o</b>ld<b>o</b>va both have two o characters seperated by two other characters.
	<p class="strong">Find the countries that have two "o" characters separated by two others.</p>		<p class="strong">Find the countries that have two "o" characters separated by two others.</p>
	<pre class="def">db.world.find({"name": {'$regex': "o..o"}}, {"name": 1, "_id": 0}).pretty()</pre>		<pre class="def"><nowiki>db.world.find({"name": {'$regex': "o..o"}}, {"name": 1, "_id": 0}).pretty()</nowiki></pre>
	</div>		</div>

Line 63:		Line 63:
	Cuba and Togo have four character names.		Cuba and Togo have four character names.
	<p class="strong">Find the countries that have exactly four characters</p>		<p class="strong">Find the countries that have exactly four characters</p>
	<pre class="def">db.world.find({"name": {'$regex': "^.{4}$"}}, {"name": 1, "_id": 0}).pretty()</pre>		<pre class="def"><nowiki>db.world.find({"name": {'$regex': "^.{4}$"}}, {"name": 1, "_id": 0}).pretty()</nowiki></pre>
	</div>		</div>

Line 74:		Line 74:
	</div>		</div>
	<p class="strong">Find the country where the name is the capital city.</p>		<p class="strong">Find the country where the name is the capital city.</p>
	<pre class="def">db.world.find({"$where":"this.name === this.capital"}, {"name": 1, "capital": 1, "_id": 0}).pretty()</pre>		<pre class="def"><nowiki>db.world.find({"$where":"this.name === this.capital"}, {"name": 1, "capital": 1, "_id": 0}).pretty()</nowiki></pre>
	</div>		</div>

Line 80:		Line 80:
	The capital of <b>Mexico</b> is <b>Mexico City</b>. Show all the countries where the capital has the country together with the word "City".		The capital of <b>Mexico</b> is <b>Mexico City</b>. Show all the countries where the capital has the country together with the word "City".
	<p class="strong">Find the country where the capital is the country plus "City".</p>		<p class="strong">Find the country where the capital is the country plus "City".</p>
	<pre class="def">db.world.find({"$where": "this.capital === this.name + ' City'"},{"name":1, "capital": 1, "_id":0}).pretty()</pre>		<pre class="def"><nowiki>db.world.find({"$where": "this.capital === this.name + ' City'"},{"name": 1, "capital": 1, "_id": 0}).pretty()</nowiki></pre>
	</div>		</div>

Line 86:		Line 86:
	<p class="strong">Find the capital and the name where the capital includes the name of the country.</p>		<p class="strong">Find the capital and the name where the capital includes the name of the country.</p>
	You should include countries like <b>Luxembourg</b> where the capital is <b>Luxembourg</b>, and countries like <b>Mexico</b> where the capital is <b>Mexico City</b>		You should include countries like <b>Luxembourg</b> where the capital is <b>Luxembourg</b>, and countries like <b>Mexico</b> where the capital is <b>Mexico City</b>
	<pre class="def">db.world.find({"$where": "this.capital.match(this.name)"}, {"name": 1, "capital": 1, "_id": 0}).pretty()</pre>		<pre class="def"><nowiki>db.world.find({"$where": "this.capital.match(this.name)"}, {"name": 1, "capital": 1, "_id": 0}).pretty()</nowiki></pre>
	</div>		</div>

Line 98:		Line 98:
	<code>.*</code> is the same as '0 or more characters' and <code>.+</code> is the same as "at least one character"		<code>.*</code> is the same as '0 or more characters' and <code>.+</code> is the same as "at least one character"
	</div>		</div>
	<pre class="def">db.world.find({"$where": "this.capital.match(new RegExp('^' + this.name + '.+$$'))"}, {"name": 1, "capital": 1, "_id": 0}).pretty()</pre>		<pre class="def"><nowiki>db.world.find({"$where": "this.capital.match(new RegExp('^' + this.name + '.+$$'))"}, {"name": 1, "capital": 1, "_id": 0}).pretty()</nowiki></pre>
	</div>		</div>

40166222: Convert to mongo

2018-04-06T05:13:47Z

Convert to mongo

Show changes

Andr3w at 15:05, 5 August 2016

2016-08-05T15:05:01Z

← Older revision		Revision as of 15:05, 5 August 2016
Line 12:		Line 12:
	import pprint		import pprint
	pp = pprint.PrettyPrinter(indent=4)		pp = pprint.PrettyPrinter(indent=4)
	~~QcQ~~
	</pre>		</pre>

Andr3w at 15:03, 5 August 2016

2016-08-05T15:03:07Z

← Older revision		Revision as of 15:03, 5 August 2016
Line 12:		Line 12:
	import pprint		import pprint
	pp = pprint.PrettyPrinter(indent=4)		pp = pprint.PrettyPrinter(indent=4)
			QcQ
	</pre>		</pre>

40166222: 40166222 moved page Pattern Matching (RegEx) to RegEx Pattern Matching without leaving a redirect

2015-07-27T11:26:40Z

40166222 moved page Pattern Matching (RegEx) to RegEx Pattern Matching without leaving a redirect

← Older revision	Revision as of 11:26, 27 July 2015
(No difference)

40166222 at 10:31, 27 July 2015

2015-07-27T10:31:31Z

← Older revision		Revision as of 10:31, 27 July 2015
Line 33:		Line 33:
	<div class=q data-lang="py3">		<div class=q data-lang="py3">
	You can use <code>'$regex':"a$"</code> to get all the countries that end with a.		You can use <code>'$regex':"a$"</code> to get all the countries that end with a.
	<p class=strong>Find the countries that end with Y</p>		<p class=strong>Find the countries that end with y</p>
	<pre class=def>		<pre class=def>
	pp.pprint(list(		pp.pprint(list(
	db.world.find({"name":{'$regex':"$Y"}},{"name":1,"_id":0})		db.world.find({"name":{'$regex':"y$"}},{"name":1,"_id":0})
	))		))
	</pre>		</pre>
	<div class=ans>		<div class=ans>
	pp.pprint(list(db.world.find({"name":{'$regex':"$Y"}},{"name":1,"_id":0})))		pp.pprint(list(db.world.find({"name":{'$regex':"y$"}},{"name":1,"_id":0})))
	</div>		</div>
	</div>		</div>

40166222 at 10:30, 27 July 2015

2015-07-27T10:30:47Z

← Older revision		Revision as of 10:30, 27 July 2015
Line 23:		Line 23:
	<pre class=def>		<pre class=def>
	pp.pprint(list(		pp.pprint(list(
	db.world.find({"name":{'$regex':"^F"}},{"name":1,"_id":0})		db.world.find({"name":{'$regex':"^Y"}},{"name":1,"_id":0})
	))		))
	</pre>		</pre>
Line 36:		Line 36:
	<pre class=def>		<pre class=def>
	pp.pprint(list(		pp.pprint(list(
	db.world.find({"name":{'$regex':"l$"}},{"name":1,"_id":0})		db.world.find({"name":{'$regex':"$Y"}},{"name":1,"_id":0})
	))		))
	</pre>		</pre>
	<div class=ans>		<div class=ans>
	pp.pprint(list(db.world.find({"name":{'$regex':"y$"}},{"name":1,"_id":0})))		pp.pprint(list(db.world.find({"name":{'$regex':"$Y"}},{"name":1,"_id":0})))
	</div>		</div>
	</div>		</div>
Line 49:		Line 49:
	<pre class=def>		<pre class=def>
	pp.pprint(list(		pp.pprint(list(
	db.world.find({"name":{'$regex':"~~ana~~"}},{"name":1,"_id":0})		db.world.find({"name":{'$regex':"x"}},{"name":1,"_id":0})
	))		))
	</pre>		</pre>
Line 62:		Line 62:
	<pre class=def>		<pre class=def>
	pp.pprint(list(		pp.pprint(list(
	db.world.find({"name":{'$regex':"~~stan~~$"}},{"name":1,"_id":0})		db.world.find({"name":{'$regex':"land$"}},{"name":1,"_id":0})
	))		))
	</pre>		</pre>
Line 76:		Line 76:
	<pre class=def>		<pre class=def>
	pp.pprint(list(		pp.pprint(list(
	db.world.find({"name":{'$regex':"^.*$"}},{"name":1,"_id":0})		db.world.find({"name":{'$regex':"^C.*ia$"}},{"name":1,"_id":0})
	))		))
	</pre>		</pre>
Line 89:		Line 89:
	<pre class=def>		<pre class=def>
	pp.pprint(list(		pp.pprint(list(
	db.world.find({"name":{'$regex':"ee"}},{"name":1,"_id":0})		db.world.find({"name":{'$regex':"oo"}},{"name":1,"_id":0})
	))		))
	</pre>		</pre>
Line 100:		Line 100:
	Bahamas has three <b>a</b>, who else?<br/>		Bahamas has three <b>a</b>, who else?<br/>
	<p class=strong>Find the country that has three or more a in the name</p>		<p class=strong>Find the country that has three or more a in the name</p>
	~~<div class="hint" title="Not getting countries that start with A?">~~
	<code>[Aa] matches both capital and lowercase A.</code>		<code>[Aa] matches both capital and lowercase A.</code>
	~~</div>~~
	<pre class=def>		<pre class=def>
	pp.pprint(list(		pp.pprint(list(
	db.world.find({"name":{'$regex':"^T"}},{"name":1,"_id":0})		db.world.find({"name":{'$regex':"(.[aA].){3}"}},{"name":1,"_id":0})
	))		))
	</pre>		</pre>
Line 119:		Line 117:
	<pre class=def>		<pre class=def>
	pp.pprint(list(		pp.pprint(list(
	db.world.find({"name":{'$regex':"^.n"}},{"name":1,"_id":0})		db.world.find({"name":{'$regex':"^.t"}},{"name":1,"_id":0})
	))		))
	</pre>		</pre>
Line 132:		Line 130:
	<pre class=def>		<pre class=def>
	pp.pprint(list(		pp.pprint(list(
	db.world.find({"name":{'$regex':"o.o"}},{"name":1,"_id":0})		db.world.find({"name":{'$regex':"o..o"}},{"name":1,"_id":0})
	))		))
	</pre>		</pre>
Line 145:		Line 143:
	<pre class=def>		<pre class=def>
	pp.pprint(list(		pp.pprint(list(
	db.world.find({"name":{'$regex':"^Cu.*$"}},{"name":1,"_id":0})		db.world.find({"name":{'$regex':"^.{4}$"}},{"name":1,"_id":0})
	))		))
	</pre>		</pre>
Line 152:		Line 150:
	</div>		</div>
	</div>		</div>
	==~~Harder Questions~~==		==Complex Examples==
	~~Well done for getting this far.<br/>~~
	~~Some optional, more complex questions are provided below.~~
	<div class=q data-lang="py3">		<div class=q data-lang="py3">
	The capital of <b>Luxembourg</b> is <b>Luxembourg</b>. Show all the countries where the capital is the same as the name of the country		The capital of <b>Luxembourg</b> is <b>Luxembourg</b>. Show all the countries where the capital is the same as the name of the country
Line 164:		Line 160:
	<pre class=def>		<pre class=def>
	pp.pprint(list(		pp.pprint(list(
	db.world.find({"$where":"this.name == ~~'Mexico'~~"},{"name":1,"_id":0})		db.world.find({"$where":"this.name == this.capital"},{"name":1,"_id":0})
	))		))
	</pre>		</pre>
	<div class=ans>		<div class=ans>
	pp.pprint(list(		pp.pprint(list(db.world.find({"$where":"this.name == this.capital"},{"name":1,"_id":0})))
	db.world.find({"$where":"this.name == this.capital"},{"name":1,"_id":0})
	))
	</div>		</div>
	</div>		</div>
Line 179:		Line 173:
	<pre class=def>		<pre class=def>
	pp.pprint(list(		pp.pprint(list(
	db.world.find({"$where":"this.capital == ~~'Mexico'~~+' City'"},{"name":1,"_id":0})		db.world.find({"$where":"this.capital == this.name+' City'"},{"name":1,"_id":0})
	))		))
	</pre>		</pre>
	<div class=ans>		<div class=ans>
	pp.pprint(list(		pp.pprint(list(db.world.find({"$where":"this.capital == this.name+' City'"},{"name":1,"_id":0})))
	db.world.find({"$where":"this.capital == this.name+' City'"},{"name":1,"_id":0})
	))
	</div>		</div>
	</div>		</div>
Line 194:		Line 186:
	<pre class=def>		<pre class=def>
	pp.pprint(list(		pp.pprint(list(
	db.world.find({"$where":"this.capital.match(~~'Mexico'~~)"},{"name":1,"_id":0})		db.world.find({"$where":"this.capital.match(this.name)"},{"name":1,"_id":0})
	))		))
	</pre>		</pre>
	<div class=ans>		<div class=ans>
	pp.pprint(list(		pp.pprint(list(db.world.find({"$where":"this.capital.match(this.name)"},{"name":1,"_id":0})))
	db.world.find({"$where":"this.capital.match(this.name)"},{"name":1,"_id":0})
	))
	</div>		</div>
	</div>		</div>
Line 215:		Line 205:
	<pre class=def>		<pre class=def>
	pp.pprint(list(		pp.pprint(list(
	db.world.find({"$where":"this.capital.match('^'+this.name+'.*$')"},{"name":1,"capital":1,"_id":0})		db.world.find({"$where":"this.capital.match('^'+this.name+'.+$')"},{"name":1,"capital":1,"_id":0})
	))		))
	</pre>		</pre>
	<div class=ans>		<div class=ans>
	pp.pprint(list(		pp.pprint(list(db.world.find({"$where":"this.capital.match('^'+this.name+'.+$')"},{"name":1,"capital":1,"_id":0})))
	db.world.find({"$where":"this.capital.match('^'+this.name+'.+$')"},{"name":1,"capital":1,"_id":0})
	))
	</div>		</div>
	</div>		</div>

40166222: 40166222 moved page FIND names to Pattern Matching (RegEx)

2015-07-27T10:24:00Z

40166222 moved page FIND names to Pattern Matching (RegEx)

← Older revision	Revision as of 10:24, 27 July 2015
(No difference)