Home Explore Help
Sign In
Apption
/
cloud-data-tools
2
0
Fork 0
Files Issues 0 Pull Requests 2 Wiki
Branch: master
Branches Tags
cloud-data-t...
/
DTHelperStd
/
RegexHelper.cs

RegexHelper.cs 8.4 KB
Permalink History Raw

12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758596061626364656667686970717273747576777879808182 
  1. 

  2. /* This Source Code Form is subject to the terms of the Mozilla Public
    3. 

  3.  * License, v. 2.0. If a copy of the MPL was not distributed with this
    4. 

  4.  * file, You can obtain one at http://mozilla.org/MPL/2.0/. */
    5. 

  5. 

  6. using System.Linq;
    7. 

  7. using System.Text.RegularExpressions;
    8. 

  8. 

  9. namespace DTHelperStd
    10. 

  10. {
    11. 

  11. 	public class RegexHelper
    12. 

  12. 	{
    13. 

  13. 		public static Regex ALPHANUMERIC_PATTERN = new Regex(@"\b[^a-zA-Z0-9]", RegexOptions.Compiled | RegexOptions.IgnoreCase);
    14. 

  14. 		public static Regex NUMBER_PATTERN1 = new Regex(@"\b^\d+(\.?\d+)?$", RegexOptions.Compiled | RegexOptions.IgnoreCase);
    15. 

  15. 		//public static Regex NUMBER_PATTERN2 = new Regex(@"\b^\d+(\.?\d+)?(-)?$", RegexOptions.Compiled | RegexOptions.IgnoreCase);
    16. 

  16. 		//public static Regex LETTER_PATTERN = new Regex(@"^[a-zA-Z]+$", RegexOptions.Compiled | RegexOptions.IgnoreCase);
    17. 

  17. 		public static Regex EVERYTHING_PATTERN = new Regex(@"\b(.+)", RegexOptions.Compiled | RegexOptions.IgnoreCase);
    18. 

  18. 		public static Regex WORD_COUNTER = new Regex(@"\b[\S]+", RegexOptions.Compiled | RegexOptions.IgnoreCase);
    19. 

  19. 		public static Regex IGNORE_QUOTED_COMMAS = new Regex("(?<=^|,)(\"(?:[^\"]|\"\")*\"|[^,]*)", RegexOptions.Compiled);
    20. 

  20. 

  21.         public static Regex NAME_PATTERN = new Regex(@"^[a-zA-Z ']{2,30}$", RegexOptions.Compiled | RegexOptions.IgnoreCase);
    22. 

  22.         public static Regex CREDIT_CARD_PATTERN = new Regex(@"^\d{12,19}", RegexOptions.Compiled | RegexOptions.IgnoreCase);
    23. 

  23.         //public static Regex DATE_PATTERN4 = new Regex(@"^(0?[1-9]|[12][0-9]|3[01])([ \/\-\.])(0?[1-9]|[12][0-9]|3[01])\2([0-9][0-9][0-9][0-9])(([ -])([0-1]?[0-9]|2[0-3]):[0-5]?[0-9]:[0-5]?[0-9])?$", RegexOptions.IgnoreCase | RegexOptions.Compiled);
    24. 

  24.         //public static Regex DATE_PATTERN2 = new Regex(@"\b(0[1-9]|[12]\d|30|31)(0[1-9]|[12]\d|30|31)(\d{4})\b", RegexOptions.IgnoreCase | RegexOptions.Compiled);
    25. 

  25.         //public static Regex DATE_PATTERN3 = new Regex(@"\b(1[0-9]|2[0-9])(\d{2})(0[1-9]|1[0-2])(0[1-9]|[12]\d|30|31)\b", RegexOptions.IgnoreCase | RegexOptions.Compiled);
    26. 

  26.         public static Regex DATE_PATTERN1 = new Regex(@"^(0?[1-9]|1[0-2])([^\w\d\r\n:])(0?[1-9]|[12][0-9]|3[01])\2((20\d\d)|(1[789]\d\d)|\d{2})$", RegexOptions.IgnoreCase | RegexOptions.Compiled);
    27. 

  27.         public static Regex DATE_PATTERN2 = new Regex(@"^(0?[1-9]|[12][0-9]|3[01])([^\w\d\r\n:])(0?[1-9]|1[0-2])\2((20\d\d)|(1[789]\d\d)|\d{2})$", RegexOptions.IgnoreCase | RegexOptions.Compiled);
    28. 

  28.         public static Regex DATE_PATTERN3 = new Regex(@"^(0[1-9]|1[0-2])(0[1-9]|[12][0-9]|3[01])((20\d\d)|(1[789]\d\d)|\d{2})$", RegexOptions.IgnoreCase | RegexOptions.Compiled);
    29. 

  29.         public static Regex DATE_PATTERN4 = new Regex(@"(^((20\d\d)|(1[789]\d\d))(0[1-9]|1[0-2])(0[1-9]|[12][0-9]|3[01])$)|(^((20\d\d)|(1[789]\d\d))(0[1-9]|[12][0-9]|3[01])(0[1-9]|1[0-2])$)", RegexOptions.IgnoreCase | RegexOptions.Compiled);
    30. 

  30.         public static Regex DATE_PATTERN5 = new Regex(@"^((20\d\d)|(1[789]\d\d)|\d{2})([^\w\d\r\n:])(0?[1-9]|1[0-2])\4(0?[1-9]|[12][0-9]|3[01])$", RegexOptions.IgnoreCase | RegexOptions.Compiled);
    31. 

  31.         
    32. 

  32.         public static Regex IPV4_PATTERN = new Regex(@"^(?:(?:25[0-5]|2[0-4][0-9]|[01]?[0-9][0-9]?)\.){3}(?:25[0-5]|2[0-4][0-9]|[01]?[0-9][0-9]?)$", RegexOptions.Compiled | RegexOptions.IgnoreCase);
    33. 

  33.         public static Regex ISBN_PATTERN = new Regex("[^0-9Xx]", RegexOptions.Compiled | RegexOptions.IgnoreCase);
    34. 

  34. 

  35.         public static Regex LATITUDE_PATTERN1 = new Regex(@"^[-+]?([1-8]?\d(\.\d+)?|90(\.0+)?),\s*[-+]?(180(\.0+)?|((1[0-7]\d)|([1-9]?\d))(\.\d+)?)$", RegexOptions.Compiled | RegexOptions.IgnoreCase);
    36. 

  36.         public static Regex LATITUDE_PATTERN2 = new Regex(@"^[-+]?([1-8]?\d(\.\d+)?|90(\.0+)?)$", RegexOptions.Compiled | RegexOptions.IgnoreCase);
    37. 

  37.         public static Regex LATITUDE_PATTERN3 = new Regex(@"^\s*[-+]?(180(\.0+)?|((1[0-7]\d)|([1-9]?\d))(\.\d+)?)$", RegexOptions.Compiled | RegexOptions.IgnoreCase);
    38. 

  38.         public static Regex LATITUDE_PATTERN4 = new Regex(@"^[NnSs]?([0-8][0-9]([\.\s][0-5]\d)([\.\s][0-5]\d(\.\d\d?)?]?)|90([\.\s]00){2})[NnSs]?$", RegexOptions.Compiled | RegexOptions.IgnoreCase);
    39. 

  39.         public static Regex LATITUDE_PATTERN5 = new Regex(@"^[EeWw]?((0?\d\d|1[0-7]\d)([\.\s][0-5]\d)([\.\s][0-5]\d(\.\d\d?)?]?|180([\.\s]00){2}))[EeWw]?$", RegexOptions.Compiled | RegexOptions.IgnoreCase);
    40. 

  40.         public static Regex LATITUDE_PATTERN6 = new Regex("^[0-9]{1,2}[:|°][0-9]{1,2}[:|'](?:\b[0-9]+(?:\\.[0-9]*)?|\\.[0-9]+\b)\"?[N|S|E|W]$", RegexOptions.Compiled | RegexOptions.IgnoreCase);
    41. 

  41. 

  42.         public static Regex MONEY_PATTERN1 = new Regex(@"^[\$\£\€\¥]+\-?([1-9]{1}[0-9]{0,2}(\,\d{3})*(\.\d{0,2})?|[1-9]{1}\d{0,}(\.\d{0,2})?|0(\.\d{0,2})?|(\.\d{1,2}))$", RegexOptions.Compiled | RegexOptions.IgnoreCase);
    43. 

  43.         public static Regex MONEY_PATTERN2 = new Regex(@"^\-?[\$\£\€\¥]+([1-9]{1}\d{0,2}(\,\d{3})*(\.\d{0,2})?|[1-9]{1}\d{0,}(\.\d{0,2})?|0(\.\d{0,2})?|(\.\d{1,2}))$", RegexOptions.Compiled | RegexOptions.IgnoreCase);
    44. 

  44.         public static Regex MONEY_PATTERN3 = new Regex(@"^\([\$\£\€\¥]+([1-9]{1}\d{0,2}(\,\d{3})*(\.\d{0,2})?|[1-9]{1}\d{0,}(\.\d{0,2})?|0(\.\d{0,2})?|(\.\d{1,2}))\)$", RegexOptions.Compiled | RegexOptions.IgnoreCase);
    45. 

  45. 

  46.         public static Regex PHONE_PATTERN = new Regex(@"^(\+?\d{1,3}\s?)?([\-])?\(?\d{3}\)?([\.\-])?\s*\d{3}([\.\-])?\s*\d{4}$", RegexOptions.Compiled | RegexOptions.IgnoreCase);
    47. 

  47. 

  48.         public static Regex ADDRESS_PATTERN1 = new Regex(@"\b[P|p]?(OST|ost)?\.?\s*[O|o|0]?(ffice|FFICE)?\.?\s*[B|b][O|o|0]?[X|x]?\.?\s+[#]?(\d+)\b", RegexOptions.Compiled | RegexOptions.IgnoreCase);
    49. 

  49.         public static Regex ADDRESS_PATTERN2 = new Regex(@"^\d+\w*\s*(?:(?:[\-\/]?\s*)?\d*(?:\s*\d+\/\s*)?\d+)?\s+", RegexOptions.Compiled | RegexOptions.IgnoreCase);
    50. 

  50. 

  51.         public static Regex EMAIL_PATTERN = new Regex(@"^([a-zA-Z0-9_\.-]+)@([\da-zA-Z\.-]+)\.([a-z\.]{2,6})$", RegexOptions.Compiled | RegexOptions.IgnoreCase);
    52. 

  52. 

  53.         public static Regex HEALTHCARD_PATTERN = new Regex(@"^\d{4}([\-\s*]?)\d{3}([\-\s*]?)\d{3}([\-\s*]?)[a-zA-Z]{2}$", RegexOptions.Compiled | RegexOptions.IgnoreCase);
    54. 

  54.         public static Regex HTTP_PATTERN = new Regex(@"/^((https?|ftp|file):\/\/)?([\da-z\.-]+)\.([a-z\.]{2,6})([\/\w \.-]*)*\/?$/", RegexOptions.Compiled | RegexOptions.IgnoreCase);
    55. 

  55. 

  56.         public static Regex IPV6_PATTERN = new Regex(@"^(([0-9a-fA-F]{1,4}:){7,7}[0-9a-fA-F]{1,4}|([0-9a-fA-F]{1,4}:){1,7}:|([0-9a-fA-F]{1,4}:){1,6}:[0-9a-fA-F]{1,4}|([0-9a-fA-F]{1,4}:){1,5}(:[0-9a-fA-F]{1,4}){1,2}|([0-9a-fA-F]{1,4}:){1,4}(:[0-9a-fA-F]{1,4}){1,3}|([0-9a-fA-F]{1,4}:){1,3}(:[0-9a-fA-F]{1,4}){1,4}|([0-9a-fA-F]{1,4}:){1,2}(:[0-9a-fA-F]{1,4}){1,5}|[0-9a-fA-F]{1,4}:((:[0-9a-fA-F]{1,4}){1,6})|:((:[0-9a-fA-F]{1,4}){1,7}|:)|fe80:(:[0-9a-fA-F]{0,4}){0,4}%[0-9a-zA-Z]{1,}|::(ffff(:0{1,4}){0,1}:){0,1}((25[0-5]|(2[0-4]|1{0,1}[0-9]){0,1}[0-9])\.){3,3}(25[0-5]|(2[0-4]|1{0,1}[0-9]){0,1}[0-9])|([0-9a-fA-F]{1,4}:){1,4}:((25[0-5]|(2[0-4]|1{0,1}[0-9]){0,1}[0-9])\.){3,3}(25[0-5]|(2[0-4]|1{0,1}[0-9]){0,1}[0-9]))$", RegexOptions.Compiled | RegexOptions.IgnoreCase);
    57. 

  57. 

  58.         public static Regex MARKETCAP_PATTERN = new Regex(@"^\$?\d+(\.\d+)?[MmBb]$", RegexOptions.Compiled | RegexOptions.IgnoreCase);
    59. 

  59.         public static Regex POSTALCODE_PATTERN1 = new Regex(@"^(?!.*[DFIOQU])[A-VXY][0-9][A-Z] ?[0-9][A-Z][0-9]$", RegexOptions.Compiled | RegexOptions.IgnoreCase);
    60. 

  60.         public static Regex POSTALCODE_PATTERN2 = new Regex(@"^[0-9]{5}(?:-[0-9]{4})?$", RegexOptions.Compiled | RegexOptions.IgnoreCase);
    61. 

  61.         public static Regex USERNAME_PATTERN = new Regex(@"^[a-zA-Z0-9_-]{3,16}$", RegexOptions.Compiled | RegexOptions.IgnoreCase);
    62. 

  62.         //public static Regex NUMBER_WITH_DOT_PATTERN = new Regex(@"^\-?[0-9]+(\.[0-9]+)\-?$", RegexOptions.Compiled | RegexOptions.IgnoreCase);
    63. 

  63.         private readonly char _separator;
    64. 

  64.         private Regex _ignore_Quoted_Commas;
    65. 

  65. 

  66.         public RegexHelper(char separator)
    67. 

  67.         {
    68. 

  68.             _separator = separator;
    69. 

  69.             _ignore_Quoted_Commas = new Regex("(?<=^|" + separator + ")(\"(?:[^\"]|\"\")*\"|[^" + separator + "]*)", RegexOptions.Compiled);
    70. 

  70.         }
    71. 

  71. 

  72.         public string[] SplitLineIgnoreQuotedCommas(string inputLine, int totalColumns)
    73. 

  73.         {
    74. 

  74. 

  75. 

  76.             var totalSeparators = inputLine.Count(c => c == _separator);
    77. 

  77.             //note: the IGNORE_QUOTED_COMMAS is NOT separator friendly. Only looks at Commas for now.
    78. 

  78.             return (totalSeparators == (totalColumns - 1) || _separator != ',') ? inputLine.Split(_separator) : _ignore_Quoted_Commas.Matches(inputLine).Cast<Match>().Select(m => m.Value).ToArray();
    79. 

  79.         }
    80. 

  80.     }
    81. 

  81. }
    82. 

  82.