Regular Expression Cheat Sheet - Revision history

MichelleH: /* Method 2 */

2018-04-17T15:56:56Z

Method 2

MichelleH at 15:54, 17 April 2018

2018-04-17T15:54:56Z

MichelleH at 15:54, 17 April 2018

2018-04-17T15:54:01Z

VeeralShah: /* Useful RegExes */

2017-06-28T17:32:13Z

Useful RegExes

Ed at 22:20, 7 October 2016

2016-10-07T22:20:43Z

Ed at 23:17, 21 September 2016

2016-09-21T23:17:51Z

Albert: /* Steps Taken */

2016-09-21T21:40:06Z

Steps Taken

Albert: Created page with "This is a page for regular expression hacks. Chronicle your exploits so that others can benefit from your ingenuity! ==Lex Machina== ===Task=== Use Patent Portfolio Report..."

2016-09-21T21:39:44Z

Created page with "This is a page for regular expression hacks. Chronicle your exploits so that others can benefit from your ingenuity! ==Lex Machina== ===Task=== Use Patent Portfolio Report..."

New page

This is a page for regular expression hacks. Chronicle your exploits so that others can benefit from your ingenuity!

==Lex Machina==

===Task===

Use Patent Portfolio Report to pull unique patent numbers for patents litigated in 2015

===Steps Taken===

#Filtered Lex Machina until total patents were under 2000.
#Lex Machina ran its Patent Portfolio Report
#Ctrl-A to select all, then pasted into TextPad
*Patent numbers were the first word in every line
#Used replace command (F8) to find "(^.+?)\s.*$" and replace with "\1"
*Make sure "regular expression" is checked off
#That left only the patent numbers
#Repeated above steps until all 2015 patents are in TextPad
#Exported data to Excel and then Removed Duplicates (Data --> Remove Duplicates)

@@ Line 48: / Line 48: @@
 # In the Replace popup, make sure you check off 'Regular Expressions' in the Conditions.
 # Use the regular expressions shown above to remove any not needed information or fix formatting from the cohort information.
-: For instance, if there's a list of cohorts on the TextPad going vertically and we want to move them to be on 1 line separated by a tab, in the Replace popup, we can put \n in the Find What and \t in the Replace With (this mean replace every instance of a newline with a tab).
+# For instance, if there's a list of cohorts on the TextPad going vertically and we want to move them to be on 1 line separated by a tab, in the Replace popup, we can put \n in the Find What and \t in the Replace With (this mean replace every instance of a newline with a tab).
 # After it is formatted correctly, move the Cohort names back to the Excel sheet.
 ===Method 3===

@@ Line 31: / Line 31: @@
 More regular expressions: [https://docs.microsoft.com/en-us/dotnet/standard/base-types/regular-expression-language-quick-reference]
-===Cohort Breakout for Accelerator Project===
+==Cohort Breakout for Accelerator Project==
 There are 3 methods to take to try and breakout cohorts on a website.
@@ Line 43: / Line 42: @@
 For methods 2 and 3, we can use Regular Expressions. However, whichever method you choose depends on what is easiest because certain situations mean that typing out the names by hand will be faster or using regular expressions will be faster.
-====Method 2====
+===Method 2===
 # Copy the entire cohort page information, open RDP and go to TextPad, and paste it into the TextPad.
@@ Line 52: / Line 51: @@
 # After it is formatted correctly, move the Cohort names back to the Excel sheet.
-====Method 3====
+===Method 3===
 # Go to the cohort page, right click, and click on Inspect. This open a window on the right side of the screen.
@@ Line 62: / Line 61: @@
 # Use regular expressions like Method 2 to get the names, and then move it back to the excel spreadsheet.
 ===Task===

@@ Line 27: / Line 27: @@
   \          escape the next thing (e.g. \} matches })
   [^...]     not whatever (...)
 ==Lex Machina==
 ===Task===

@@ Line 13: / Line 13: @@
   +          1 or more times
   ?          0 or once
-  \s         space
+  \s         any whtespace character
   \d         number
   [0-9]      any number (once)
   [a-z]      any letter (once)
@@ Line 24: / Line 26: @@
   ()         captures whatever is in the bracktets
   \          escape the next thing (e.g. \} matches })
+ [^...]     not whatever (...)
 ==Lex Machina==

← Older revision		Revision as of 22:20, 7 October 2016
Line 43:		Line 43:
	#Repeated above steps until all 2015 patents are in TextPad		#Repeated above steps until all 2015 patents are in TextPad
	#Exported data to Excel and then Removed Duplicates (Data --> Remove Duplicates)		#Exported data to Excel and then Removed Duplicates (Data --> Remove Duplicates)
		+	[[Category:Internal]]

← Older revision		Revision as of 23:17, 21 September 2016
Line 1:		Line 1:
	This is a page for regular expression hacks. Chronicle your exploits so that others can benefit from your ingenuity!		This is a page for regular expression hacks. Chronicle your exploits so that others can benefit from your ingenuity!
		+
		+	==Useful RegExes==
		+
		+	Pattern Matches
		+	------------------
		+	\t tab
		+	\n newline
		+	^ start of line
		+	$ end of line
		+	. any character
		+	* any number of times
		+	+ 1 or more times
		+	? 0 or once
		+	\s space
		+	\d number
		+	[0-9] any number (once)
		+	[a-z] any letter (once)
		+	[a-Z] any letter (case insensitive]
		+	abc abc
		+	[a\|b\|c] a or b or c
		+	{1,3} 1, 2, or 3 times in a row
		+	{3,} 3 or more times
		+	() captures whatever is in the bracktets
		+	\ escape the next thing (e.g. \} matches })

@@ Line 13: / Line 13: @@
 #Lex Machina ran its Patent Portfolio Report
 #Ctrl-A to select all, then pasted into TextPad
-*Patent numbers were the first word in every line
+**Patent numbers were the first word in every line
 #Used replace command (F8) to find "(^.+?)\s.*$" and replace with "\1"
-*Make sure "regular expression" is checked off
+**Make sure "regular expression" is checked
 #That left only the patent numbers
 #Repeated above steps until all 2015 patents are in TextPad
 #Exported data to Excel and then Removed Duplicates (Data --> Remove Duplicates)