Regular expressions - Revision history

Andrea: /* Library of working regular expressions */

2018-05-14T11:36:19Z

‎Library of working regular expressions

2018-05-14T11:34:25Z

‎What are the regular expressions and how do they work?

2018-04-12T11:23:25Z

‎How do I use them in Tabbles?

2018-04-12T11:22:43Z

2018-04-09T12:59:37Z

2018-04-09T12:56:49Z

‎What are the regular expressions and how do they work?

2018-04-09T12:43:54Z

‎What are the regular expressions and how do they work?

2018-04-09T12:42:42Z

‎Library of working regular expressions

2018-04-09T12:38:27Z

‎Library of working regular expressions

2018-04-09T12:37:59Z

‎Library of working regular expressions

@@ Line 87: / Line 87: @@
 |-
 |   <nowiki>[0-3][0-9][0-1][1-9]\d{2}-\d{4}?[^0-9]*</nowiki> || Danish CPR Number (DDMMYY-NNNN, like 310180-1234) || Andrea
 |-
 |   <nowiki>(^|\s)(00[1-9]|0[1-9]0|0[1-9][1-9]|[1-6]\d{2}|7[0-6]\d|77[0-2])(-?|[\. ])([1-9]0|0[1-9]|[1-9][1-9])\3(\d{3}[1-9]|[1-9]\d{3}|\d[1-9]\d{2}|\d{2}[1-9]\d)($|\s|[;:,!\.\?])</nowiki> || USA Social Security Number (It recognizes the formats 123456789, 123 45 6789, 123-45-6789) || Andrea

@@ Line 7: / Line 7: @@
 - Page on [http://www.codeproject.com/KB/dotnet/regextutorial.aspx Codeplex]
-- Online regular expression editor [https://regexr.com/ RegExr]
+- Online regular expression editors [https://regexr.com/ RegExr] and [https://regex101.com/ regex101]
 - Download [http://www.ultrapico.com/ExpressoDownload.htm Expresso], a regular expression editor

← Older revision		Revision as of 11:23, 12 April 2018
Line 28:		Line 28:
	Go to: '''Tools > Auto-tagging rules > New''' and edit the window to something like this:		Go to: '''Tools > Auto-tagging rules > New''' and edit the window to something like this:

−	http://~~www.~~tabbles.net/images/wiki/~~regular_expressions~~.png	+	http://tabbles.net/images/wiki/T5-Auto-Tagging-RegEx.png

← Older revision		Revision as of 11:22, 12 April 2018
Line 1:		Line 1:
−	Since ~~the version 1.~~5.2 you can use regular expressions within the auto-tagging rules to tag files based on their name/path.	+	Since Tabbles 5.2.31, you can use regular expressions within the auto-tagging rules to tag files based on their name, path and content.

	==What are the regular expressions and how do they work?==		==What are the regular expressions and how do they work?==

@@ Line 4: / Line 4: @@
 - Regex on [http://en.wikipedia.org/wiki/Regular_expression wikipedia]
 - Page on [http://www.codeproject.com/KB/dotnet/regextutorial.aspx Codeplex]
@@ Line 18: / Line 14: @@
 - Regular expression [http://regexlib.com/DisplayPatterns.aspx?cattabindex=0&categoryid=1&p=1 library] (warning: the syntax could be different... the one on the MSDN page is the one that should work)
 ==How do I use them in Tabbles?==

← Older revision		Revision as of 12:56, 9 April 2018
Line 4:		Line 4:

	- Regex on [http://en.wikipedia.org/wiki/Regular_expression wikipedia]		- Regex on [http://en.wikipedia.org/wiki/Regular_expression wikipedia]
		+
		+	- [https://ipsec.pl/data-protection/2012/european-personal-data-regexp-patterns.html European personal data regexp patterns]

	- Searchable Collection of regex [http://regexlib.com/Default.aspx RegExLib]		- Searchable Collection of regex [http://regexlib.com/Default.aspx RegExLib]

@@ Line 79: / Line 79: @@
 |   <nowiki>[0-3][0-9][0-1][1-9]\d{2}-\d{4}?[^0-9]*</nowiki> || Danish CPR Number (DDMMYY-NNNN, like 310180-1234) || Andrea
 |-
-|   <nowiki>.*(?!219-09-9999|078-05-1120)(?!666|000|9\d{2})\d{3}-(?!00)\d{2}-(?!0{4})\d{4}.*|.*(?!219099999|078051120)(?!666|000|9\d{2})\d{3}(?!00)\d{2}(?!0{4})\d{4}.*|.*(?!219-09-9999|078-05-1120)(?!666|000|9\d{2})\d{3}\s(?!00)\d{2}\s(?!0{4})\d{4}.*</nowiki> || USA Social Security Number (It recognizes the formats 123456789, 123 45 6789, 123-45-6789) || Andrea
+|   <nowiki>(^|\s)(00[1-9]|0[1-9]0|0[1-9][1-9]|[1-6]\d{2}|7[0-6]\d|77[0-2])(-?|[\. ])([1-9]0|0[1-9]|[1-9][1-9])\3(\d{3}[1-9]|[1-9]\d{3}|\d[1-9]\d{2}|\d{2}[1-9]\d)($|\s|[;:,!\.\?])</nowiki> || USA Social Security Number (It recognizes the formats 123456789, 123 45 6789, 123-45-6789) || Andrea
 |-
 |   <nowiki>.*(?:(?:[B-DF-HJ-NP-TV-Z]|[AEIOU])[AEIOU][AEIOUX]|[B-DF-HJ-NP-TV-Z]{2}[A-Z]){2}[\dLMNP-V]{2}(?:[A-EHLMPR-T](?:[04LQ][1-9MNP-V]|[1256LMRS][\dLMNP-V])|[DHPS][37PT][0L]|[ACELMRT][37PT][01LM])(?:[A-MZ][1-9MNP-V][\dLMNP-V]{2}|[A-M][0L](?:[1-9MNP-V][\dLMNP-V]|[0L][1-9MNP-V]))[A-Z].*</nowiki> || Italian "Codice Fiscale" || Andrea

@@ Line 71: / Line 71: @@
 |   <nowiki>.*(201\d).*</nowiki> || matches 2010 to 2019 (useful for years). Change "201" to "200" to match 2000 to 2009 || Andrea
 |-
-|   <nowiki>((67\d{2})|(4\d{3})|(5[1-5]\d{2})|(6011))(-?\s?\d{4}){3}|(3[4,7])\d{2}-?\s?\d{6}-?\s?\d{5}</nowiki> || Credit cards (works with the major cards) || Andrea
+|   <nowiki>((67\d{2})|(4\d{3})|(5[1-5]\d{2})|(6011))(-?\s?\d{4}){3}|(3[4,7])\d{2}-?\s?\d{6}-?\s?\d{5}</nowiki> || Credit cards (works with the major cards, with "-" or without) || Andrea
 |-
 |   <nowiki>.*C\d{3}.*</nowiki> || Matches files with a path like "D:\Customers\C001" to "C999" or "...\stuff_C001_stuff" (to ...C999) || Andrea