{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["RegEx"],"not_rendered":{"charts":0,"images":4,"macros":1,"external_links":0,"defined_names":8,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"RegEx","index":0,"n_rows":25,"n_cols":7,"rows_kept":25,"cut":false,"hidden":false,"merged":[]}
[]
[null,"www.learnExcelMacro.com"]
[]
[null,"Type your RegEx Patter here","^(?=.*[a-z])(?=.*[A-Z])(?=.*[0-9])(?=.*[!@#\\$%\\^&\\*])(?=.{8,})"]
[null,null,"at least one small letter, one capital letter, one symbol and one number and it should be 8 chars long"]
[null,"Your String to validate","aS56@34gh",null,null,null,{"$f":"IF(testMethodRegEx(C4,C6),0,-1)","v":0}]
[]
[]
[]
[]
[null,"CLICK Below to see the Regex with one Example:"]
[]
[null,null,"Strong Password","^(?=.*[a-z])(?=.*[A-Z])(?=.*[0-9])(?=.*[!@#\\$%\\^&\\*])(?=.{8,})","aS56@34gh","at least one small letter, one capital letter, one symbol and one number and it should be 8 chars long"]
[null,null,"Medium Password","^((?=.*[a-z])(?=.*[A-Z])(?=.*[0-9])(?=.{6,}))","mEdium1","One capital, one small letter and one numeric field and total 6 chars long"]
[null,null,"Simple Password","^((?=.*[a-zA-Z])(?=.*[0-9])(?=.{5,}))","abc234","At least one alphabet and one numeric field and total 5 chars long"]
[null,null,"Only Alphanumeric","^((?=.*[a-zA-Z])(?=.*[0-9])(?=.{5,}))","ab356s","Alphanumeric Only"]
[null,null,"Website address","(https?:\\/\\/(?:www\\.|(?!www))[a-zA-Z0-9][a-zA-Z0-9-]+[a-zA-Z0-9]\\.[^\\s]{2,}|www\\.[a-zA-Z0-9][a-zA-Z0-9-]+[a-zA-Z0-9]\\.[^\\s]{2,}|https?:\\/\\/(?:www\\.|(?!www))[a-zA-Z0-9]\\.[^\\s]{2,}|www\\.[a-zA-Z0-9]\\.[^\\s]{2,})","http://www.learnexcelmacro.com","Web URL"]
[null,null,"Positive numers","^([+]?\\d+([.]\\d+))",12345.3,"Positive Numbers"]
[null,null,"Negative numbers","^(\\-\\d+([.]?\\d+))",-346.03,"Negative Numbers"]
[null,null,"10 digit telephone number [not starting with Zero]","[1-9]{1}[0-9]{9}$",9923432345,"10 digit telephone number [not starting with Zero]"]
[null,null,"Phone with a country code format","[+]{1}[0-9]{2}[-]{1}[1-9]{1}[0-9]{9}$","+31-1343563544","Phone number with country code"]
[null,null,"Year between 1900 and 2018","(19[0-9]{2}|200[0-9]{1}|201[0-8]{1})$",1998]
[null,null,"Date format : DD/mm/yyyy","^((0[1-9]|[1-9]|[12][0-9]|3[0-1])\\/(0[1-9]|[1-9]|1[0-2])\\/([12]\\d{3}))","25/01/1984"]
[null,null,"Netherlands Postal Code","\\d{4}[ ]*([aA-zZ]{2})$","1111 VB"]
[null,null,"USA Postal Code","^\\d{5}(?:[-\\s]\\d{4})?$","23345-3456"]