{"text_format":"1","workbook":"xlsx","n_sheets":13,"sheets":["Cheat Sheet of RegEx","Match SKU","Check SSN","Validate Number","IFMATCH","Unmatch String","COUNTIF RegEx","Unmatch Character","Mail Address","Case Insensitive","Extract String","Replace","Without VBA"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":2,"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":"Cheat Sheet of RegEx","index":0,"n_rows":42,"n_cols":3,"rows_kept":42,"cut":false,"hidden":false,"merged":[[36,1,36,2],[1,1,1,2],[3,1,3,2],[11,1,11,2],[18,1,18,2],[26,1,26,2]]}
[]
[null,"Cheat Sheet of RegEx"]
[]
[null,"Pattern Elements:"]
[null,".","Matches any single character except newline (\\n)"]
[null,"[ ]","Match exactly one of the objects inside the brackets"]
[null,"[a-z]","Matches any single lowercase letter from a to z"]
[null,"[0-9]","Matches any single digit from 0 to 9"]
[null,"[^ ]","Match any character not in the brackets"]
[null,"^","Matches the start of the string"]
[null,"$","Matches the end of the string"]
[null,"Quantifiers:"]
[null,"*","Match zero or more occurrences of the preceding pattern"]
[null,"=+","Match one or more occurrences of the preceding pattern"]
[null,"?","Match zero or one occurrence of the preceding pattern"]
[null,"{m}","Match exactly m occurrences of the preceding pattern"]
[null,"{m,n}","Match between m and n occurrences of the preceding pattern"]
[null,"{m,n}?","Match between m and n occurrences of the preceding pattern (non-greedy)"]
[null,"Predefined Character Abbreviations:"]
[null,"\\d","Matches any single digit (equivalent to [0-9])"]
[null,"\\D","Matches any single character that's not a digit"]
[null,"\\w","Matches any word character (letters, digits, underscore)"]
[null,"\\W","Matches any non-word character"]
[null,"\\s","Matches any whitespace character (space, tab, newline)"]
[null,"\\S","Matches any non-whitespace character"]
[null,"\\n","Matches a newline character (\\n)"]
[null,"Grouping and Capturing:",""]
[null,"( )","Groups different matches for return purposes"]
[null,"(?: )","Groups the pattern without capturing it"]
[null,"Alternation:",""]
[null,"|","OR operator, matches either the pattern before or after it"]
[null,"(a|b)","Matches either \"a\" or \"b\""]
[null,"Modifiers:",""]
[null,"i","Case-insensitive matching"]
[null,"g","Global matching (continues to search for all occurrences)"]
[null,"m","Multi-line matching"]
[null,"Escape Characters:"]
[null,"\\","Escapes special characters (., [, ], (, ), ?, +, *, {, }, |, ^, $, \\)"]
[null,"Examples:",""]
[null,"^\\d{3}-\\d{3}-\\d{4}","Matches a phone number in the format ###-###-####"]
[null,"[A-Za-z]+","Matches one or more consecutive letters"]
[null,"\\d{2,4}","Matches a number with 2 to 4 digits"]

{"sheet":"Match SKU","index":1,"n_rows":16,"n_cols":8,"rows_kept":16,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,5,1,7]]}
[]
[null,"Using RegEx to Match SKU Codes",null,null,null,"Practice Yourself"]
[]
[null,"Product Category","Product SKU","Matched?",null,"Product Category","Product SKU","Matched?"]
[null,"Laptop"," COM-001-ABC",{"$f":"RegEx_Match(C5,$C$16)","v":"Matched"},null,"Laptop"," COM-001-ABC"]
[null,"Mouse"," COM-002-DEF",{"$f":"RegEx_Match(C6,$C$16)","v":"Matched"},null,"Mouse"," COM-002-DEF"]
[null,"Laptop"," COM-003-GHI",{"$f":"RegEx_Match(C7,$C$16)","v":"Matched"},null,"Laptop"," COM-003-GHI"]
[null,"Keyboard"," COM-004-JKL",{"$f":"RegEx_Match(C8,$C$16)","v":"Matched"},null,"Keyboard"," COM-004-JKL"]
[null,"Monitor","COM-005-MNO",{"$f":"RegEx_Match(C9,$C$16)","v":"Matched"},null,"Monitor","COM-005-MNO"]
[null,"Mouse"," COM-006-PQR",{"$f":"RegEx_Match(C10,$C$16)","v":"Matched"},null,"Mouse"," COM-006-PQR"]
[null,"Mouspad"," COM-007-STU",{"$f":"RegEx_Match(C11,$C$16)","v":"Matched"},null,"Mouspad"," COM-007-STU"]
[null,"Speaker"," COM-008-VWX",{"$f":"RegEx_Match(C12,$C$16)","v":"Matched"},null,"Speaker"," COM-008-VWX"]
[null,"Smartphone"," SMP-009-HUW",{"$f":"RegEx_Match(C13,$C$16)","v":"Unmatched"},null,"Smartphone"," SMP-009-HUW"]
[null,"Phone Cover"," SMP-010-IPH",{"$f":"RegEx_Match(C14,$C$16)","v":"Unmatched"},null,"Phone Cover"," SMP-010-IPH"]
[]
[null,"RegEx Pattern","COM-\\d{3}-[A-Z]{3}$",null,null,"RegEx Pattern","COM-\\d{3}-[A-Z]{3}$"]

{"sheet":"Check SSN","index":2,"n_rows":16,"n_cols":8,"rows_kept":16,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,5,1,7]]}
[]
[null,"Using RegEx to Check Social Security Numbers",null,null,null,"Practice Yourself"]
[]
[null,"Name","Number","Matched with SSN Pattern?",null,"Name","Number","Matched with SSN Pattern?"]
[null,"Luca Rossi","123-45-6789",{"$f":"RegEx_Match(C5,$C$16)","v":"Matched"},null,"Luca Rossi","123-45-6789"]
[null,"Sofia Müller","987-65-4321",{"$f":"RegEx_Match(C6,$C$16)","v":"Matched"},null,"Sofia Müller","987-65-4321"]
[null,"David Andersen","246-80-1357",{"$f":"RegEx_Match(C7,$C$16)","v":"Matched"},null,"David Andersen","246-80-1357"]
[null,"Isabella García","753-09-8642T",{"$f":"RegEx_Match(C8,$C$16)","v":"Unmatched"},null,"Isabella García","753-09-8642T"]
[null,"Gabriel Lefèvre","369-24-6801",{"$f":"RegEx_Match(C9,$C$16)","v":"Matched"},null,"Gabriel Lefèvre","369-24-6801"]
[null,"Amelia Sánchez","S02-46-1359",{"$f":"RegEx_Match(C10,$C$16)","v":"Unmatched"},null,"Amelia Sánchez","S02-46-1359"]
[null,"Oliver Schneider","514-92-6870",{"$f":"RegEx_Match(C11,$C$16)","v":"Matched"},null,"Oliver Schneider","514-92-6870"]
[null,"Elena Petrova","679-03-2158",{"$f":"RegEx_Match(C12,$C$16)","v":"Matched"},null,"Elena Petrova","679-03-2158"]
[null,"Felix Van Der Berg","321-76-9085",{"$f":"RegEx_Match(C13,$C$16)","v":"Matched"},null,"Felix Van Der Berg","321-76-9085"]
[null,"Lea Fischer","857-10-2946",{"$f":"RegEx_Match(C14,$C$16)","v":"Matched"},null,"Lea Fischer","857-10-2946"]
[]
[null,"RegEx Pattern","\\d{3}-\\d{2}-\\d{4}$",null,null,"RegEx Pattern","\\d{3}-\\d{2}-\\d{4}$"]

{"sheet":"Validate Number","index":3,"n_rows":16,"n_cols":8,"rows_kept":16,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,5,1,7]]}
[]
[null,"Using RegEx to Validate Number of USA",null,null,null,"Practice Yourself"]
[]
[null,"Name","Phone Number","Matched with Valid Pattern?",null,"Name","Phone Number","Matched with Valid Pattern?"]
[null,"Emily Johnson","(555) 123-4567",{"$f":"RegEx_Match(C5,$C$16)","v":"Matched"},null,"Emily Johnson","(555) 123-4567"]
[null,"Ethan Davis","(555) 987-6543",{"$f":"RegEx_Match(C6,$C$16)","v":"Matched"},null,"Ethan Davis","(555) 987-6543"]
[null,"Sophia Wilson","(555) 456-7890",{"$f":"RegEx_Match(C7,$C$16)","v":"Matched"},null,"Sophia Wilson","(555) 456-7890"]
[null,"Benjamin Thompson","(555) 234-5678",{"$f":"RegEx_Match(C8,$C$16)","v":"Matched"},null,"Benjamin Thompson","(555) 234-5678"]
[null,"Ava Miller","(321) 876-5432",{"$f":"RegEx_Match(C9,$C$16)","v":"Unmatched"},null,"Ava Miller","(321) 876-5432"]
[null,"Jacob Anderson","(555) 345-6789",{"$f":"RegEx_Match(C10,$C$16)","v":"Matched"},null,"Jacob Anderson","(555) 345-6789"]
[null,"Olivia Martinez","(321) 654-3210",{"$f":"RegEx_Match(C11,$C$16)","v":"Unmatched"},null,"Olivia Martinez","(321) 654-3210"]
[null,"William Brown","(555) 789-0123",{"$f":"RegEx_Match(C12,$C$16)","v":"Matched"},null,"William Brown","(555) 789-0123"]
[null,"Isabella Taylor","(555) 432-1098",{"$f":"RegEx_Match(C13,$C$16)","v":"Matched"},null,"Isabella Taylor","(555) 432-1098"]
[null,"James Johnson","(555) 901-2345",{"$f":"RegEx_Match(C14,$C$16)","v":"Matched"},null,"James Johnson","(555) 901-2345"]
[]
[null,"RegEx Pattern of USA Phone Numbers","^\\(555\\) \\d{3}-\\d{4}$",null,null,"RegEx Pattern of USA Phone Numbers","^\\(555\\) \\d{3}-\\d{4}$"]

{"sheet":"IFMATCH","index":4,"n_rows":16,"n_cols":8,"rows_kept":16,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,5,1,7]]}
[]
[null,"Using IF Function with RegEx",null,null,null,"Practice Yourself"]
[]
[null,"Name","Address","From Outside Texas?",null,"Name","Address","From Outside Texas?"]
[null,"Emily Johnson","Dallas, Texas",{"$f":"IF(RegEx_Match(C5,$C$16)=\"Matched\",\"Yes\",\"No\")","v":"No"},null,"Emily Johnson","Dallas, Texas"]
[null,"Ethan Davis","New York City, New York",{"$f":"IF(RegEx_Match(C6,$C$16)=\"Matched\",\"Yes\",\"No\")","v":"Yes"},null,"Ethan Davis","New York City, New York"]
[null,"Sophia Wilson","Los Angeles, California",{"$f":"IF(RegEx_Match(C7,$C$16)=\"Matched\",\"Yes\",\"No\")","v":"Yes"},null,"Sophia Wilson","Los Angeles, California"]
[null,"Benjamin Thompson","Chicago, Illinois",{"$f":"IF(RegEx_Match(C8,$C$16)=\"Matched\",\"Yes\",\"No\")","v":"Yes"},null,"Benjamin Thompson","Chicago, Illinois"]
[null,"Ava Miller","Houston, Texas",{"$f":"IF(RegEx_Match(C9,$C$16)=\"Matched\",\"Yes\",\"No\")","v":"No"},null,"Ava Miller","Houston, Texas"]
[null,"Jacob Anderson","Phoenix, Arizona",{"$f":"IF(RegEx_Match(C10,$C$16)=\"Matched\",\"Yes\",\"No\")","v":"Yes"},null,"Jacob Anderson","Phoenix, Arizona"]
[null,"Olivia Martinez","Philadelphia, Pennsylvania",{"$f":"IF(RegEx_Match(C11,$C$16)=\"Matched\",\"Yes\",\"No\")","v":"Yes"},null,"Olivia Martinez","Philadelphia, Pennsylvania"]
[null,"William Brown","San Antonio, Texas",{"$f":"IF(RegEx_Match(C12,$C$16)=\"Matched\",\"Yes\",\"No\")","v":"No"},null,"William Brown","San Antonio, Texas"]
[null,"Isabella Taylor","San Diego, California",{"$f":"IF(RegEx_Match(C13,$C$16)=\"Matched\",\"Yes\",\"No\")","v":"Yes"},null,"Isabella Taylor","San Diego, California"]
[null,"James Johnson","San Francisco, California",{"$f":"IF(RegEx_Match(C14,$C$16)=\"Matched\",\"Yes\",\"No\")","v":"Yes"},null,"James Johnson","San Francisco, California"]
[]
[null,"RegEx Pattern","^(?!.*Texas).*$",null,null,"RegEx Pattern","^(?!.*Texas).*$"]

{"sheet":"Unmatch String","index":5,"n_rows":16,"n_cols":8,"rows_kept":16,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,5,1,7]]}
[]
[null,"Using RegEx to Look up Unmatched String",null,null,null,"Practice Yourself"]
[]
[null,"Name","Address","From Outside Texas?",null,"Name","Address","From Outside Texas?"]
[null,"Emily Johnson","Dallas, Texas",{"$f":"RegEx_Match(C5,$C$16,\"Yes\",\"No\")","v":"No"},null,"Emily Johnson","Dallas, Texas"]
[null,"Ethan Davis","New York City, New York",{"$f":"RegEx_Match(C6,$C$16,\"Yes\",\"No\")","v":"Yes"},null,"Ethan Davis","New York City, New York"]
[null,"Sophia Wilson","Los Angeles, California",{"$f":"RegEx_Match(C7,$C$16,\"Yes\",\"No\")","v":"Yes"},null,"Sophia Wilson","Los Angeles, California"]
[null,"Benjamin Thompson","Chicago, Illinois",{"$f":"RegEx_Match(C8,$C$16,\"Yes\",\"No\")","v":"Yes"},null,"Benjamin Thompson","Chicago, Illinois"]
[null,"Ava Miller","Houston, Texas",{"$f":"RegEx_Match(C9,$C$16,\"Yes\",\"No\")","v":"No"},null,"Ava Miller","Houston, Texas"]
[null,"Jacob Anderson","Phoenix, Arizona",{"$f":"RegEx_Match(C10,$C$16,\"Yes\",\"No\")","v":"Yes"},null,"Jacob Anderson","Phoenix, Arizona"]
[null,"Olivia Martinez","Philadelphia, Pennsylvania",{"$f":"RegEx_Match(C11,$C$16,\"Yes\",\"No\")","v":"Yes"},null,"Olivia Martinez","Philadelphia, Pennsylvania"]
[null,"William Brown","San Antonio, Texas",{"$f":"RegEx_Match(C12,$C$16,\"Yes\",\"No\")","v":"No"},null,"William Brown","San Antonio, Texas"]
[null,"Isabella Taylor","San Diego, California",{"$f":"RegEx_Match(C13,$C$16,\"Yes\",\"No\")","v":"Yes"},null,"Isabella Taylor","San Diego, California"]
[null,"James Johnson","San Francisco, California",{"$f":"RegEx_Match(C14,$C$16,\"Yes\",\"No\")","v":"Yes"},null,"James Johnson","San Francisco, California"]
[]
[null,"RegEx Pattern","^(?!.*Texas).*$",null,null,"RegEx Pattern","^(?!.*Texas).*$"]

{"sheet":"COUNTIF RegEx","index":6,"n_rows":17,"n_cols":8,"rows_kept":17,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,5,1,7]]}
[]
[null,"Using COUNTIF & RegEx",null,null,null,"Practice Yourself"]
[]
[null,"Name","Address","From Outside Texas?",null,"Name","Address","From Outside Texas?"]
[null,"Emily Johnson","Dallas, Texas",{"$f":"RegEx_Match(C5,$C$16,\"Yes\",\"No\")","v":"No"},null,"Emily Johnson","Dallas, Texas"]
[null,"Ethan Davis","New York City, New York",{"$f":"RegEx_Match(C6,$C$16,\"Yes\",\"No\")","v":"Yes"},null,"Ethan Davis","New York City, New York"]
[null,"Sophia Wilson","Los Angeles, California",{"$f":"RegEx_Match(C7,$C$16,\"Yes\",\"No\")","v":"Yes"},null,"Sophia Wilson","Los Angeles, California"]
[null,"Benjamin Thompson","Chicago, Illinois",{"$f":"RegEx_Match(C8,$C$16,\"Yes\",\"No\")","v":"Yes"},null,"Benjamin Thompson","Chicago, Illinois"]
[null,"Ava Miller","Houston, Texas",{"$f":"RegEx_Match(C9,$C$16,\"Yes\",\"No\")","v":"No"},null,"Ava Miller","Houston, Texas"]
[null,"Jacob Anderson","Phoenix, Arizona",{"$f":"RegEx_Match(C10,$C$16,\"Yes\",\"No\")","v":"Yes"},null,"Jacob Anderson","Phoenix, Arizona"]
[null,"Olivia Martinez","Philadelphia, Pennsylvania",{"$f":"RegEx_Match(C11,$C$16,\"Yes\",\"No\")","v":"Yes"},null,"Olivia Martinez","Philadelphia, Pennsylvania"]
[null,"William Brown","San Antonio, Texas",{"$f":"RegEx_Match(C12,$C$16,\"Yes\",\"No\")","v":"No"},null,"William Brown","San Antonio, Texas"]
[null,"Isabella Taylor","San Diego, California",{"$f":"RegEx_Match(C13,$C$16,\"Yes\",\"No\")","v":"Yes"},null,"Isabella Taylor","San Diego, California"]
[null,"James Johnson","San Francisco, California",{"$f":"RegEx_Match(C14,$C$16,\"Yes\",\"No\")","v":"Yes"},null,"James Johnson","San Francisco, California"]
[]
[null,"RegEx Pattern","^(?!.*Texas).*$",null,null,"RegEx Pattern","^(?!.*Texas).*$"]
[null,"No of People from Outsideof Texas",{"$f":"COUNTIF(D5:D14,\"Yes\")","v":7},null,null,"No of People from Outsideof Texas"]

{"sheet":"Unmatch Character","index":7,"n_rows":16,"n_cols":8,"rows_kept":16,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,5,1,7]]}
[]
[null,"Using RegEx to Look up Unmatched Character",null,null,null,"Practice Yourself"]
[]
[null,"Name"," Mobile Number","Contains Country Code?",null,"Name"," Mobile Number","Contains Country Code?"]
[null,"John Smith"," +1 1234567890",{"$f":"RegEx_Match(C5,$C$16,\"No\",\"Yes\")","v":"Yes"},null,"John Smith"," +1 1234567890"]
[null,"Emma Johnson"," +1 9876543210",{"$f":"RegEx_Match(C6,$C$16,\"No\",\"Yes\")","v":"Yes"},null,"Emma Johnson"," +1 9876543210"]
[null,"Maria García"," +34 612345678",{"$f":"RegEx_Match(C7,$C$16,\"No\",\"Yes\")","v":"Yes"},null,"Maria García"," +34 612345678"]
[null,"Liam Wilson"," +61 412345678",{"$f":"RegEx_Match(C8,$C$16,\"No\",\"Yes\")","v":"Yes"},null,"Liam Wilson"," +61 412345678"]
[null,"Sophie Müller",15123456789,{"$f":"RegEx_Match(C9,$C$16,\"No\",\"Yes\")","v":"No"},null,"Sophie Müller",15123456789]
[null,"Lucas Dubois"," +33 612345678",{"$f":"RegEx_Match(C10,$C$16,\"No\",\"Yes\")","v":"Yes"},null,"Lucas Dubois"," +33 612345678"]
[null,"Isabella Rossi"," +39 3476543210",{"$f":"RegEx_Match(C11,$C$16,\"No\",\"Yes\")","v":"Yes"},null,"Isabella Rossi"," +39 3476543210"]
[null,"Alexander Petrov",9876543210,{"$f":"RegEx_Match(C12,$C$16,\"No\",\"Yes\")","v":"No"},null,"Alexander Petrov",9876543210]
[null,"Mia Takahashi"," +81 9012345678",{"$f":"RegEx_Match(C13,$C$16,\"No\",\"Yes\")","v":"Yes"},null,"Mia Takahashi"," +81 9012345678"]
[null,"Noah Kim"," +82 1023456789",{"$f":"RegEx_Match(C14,$C$16,\"No\",\"Yes\")","v":"Yes"},null,"Noah Kim"," +82 1023456789"]
[]
[null,"RegEx Pattern","^[^\\+]*$",null,null,"RegEx Pattern","^[^\\+]*$"]

{"sheet":"Mail Address","index":8,"n_rows":16,"n_cols":8,"rows_kept":16,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,5,1,7]]}
[]
[null,"Using RegEx to Validate Mail Addresses",null,null,null,"Practice Yourself"]
[]
[null,"Name","Email Address","Is Email Address Valid",null,"Name","Email Address","Is Email Address Valid"]
[null,"Emily Johnson","emily.johnson@google.com",{"$f":"RegEx_Match(C5,$C$16,\"Valid\",\"Invalid\")","v":"Valid"},null,"Emily Johnson","emily.johnson@google.com"]
[null,"Ethan Davis","ethan.davis@google.com",{"$f":"RegEx_Match(C6,$C$16,\"Valid\",\"Invalid\")","v":"Valid"},null,"Ethan Davis","ethan.davis@google.com"]
[null,"Sophia Wilson","sophia.wilson@google.com",{"$f":"RegEx_Match(C7,$C$16,\"Valid\",\"Invalid\")","v":"Valid"},null,"Sophia Wilson","sophia.wilson@google.com"]
[null,"Benjamin Thompson","benjamin.thompson@google.com",{"$f":"RegEx_Match(C8,$C$16,\"Valid\",\"Invalid\")","v":"Valid"},null,"Benjamin Thompson","benjamin.thompson@google.com"]
[null,"Ava Miller","ava.miller@google.com",{"$f":"RegEx_Match(C9,$C$16,\"Valid\",\"Invalid\")","v":"Valid"},null,"Ava Miller","ava.miller@google.com"]
[null,"Jacob Anderson","jacob.anderson.google.com",{"$f":"RegEx_Match(C10,$C$16,\"Valid\",\"Invalid\")","v":"Invalid"},null,"Jacob Anderson","jacob.anderson.google.com"]
[null,"Olivia Martinez","olivia.martinez@outlook.com",{"$f":"RegEx_Match(C11,$C$16,\"Valid\",\"Invalid\")","v":"Valid"},null,"Olivia Martinez","olivia.martinez@outlook.com"]
[null,"William Brown","william.brown.google.com",{"$f":"RegEx_Match(C12,$C$16,\"Valid\",\"Invalid\")","v":"Invalid"},null,"William Brown","william.brown.google.com"]
[null,"Isabella Taylor","isabella.taylor.google.com",{"$f":"RegEx_Match(C13,$C$16,\"Valid\",\"Invalid\")","v":"Invalid"},null,"Isabella Taylor","isabella.taylor.google.com"]
[null,"James Johnson","james.johnson@google.com",{"$f":"RegEx_Match(C14,$C$16,\"Valid\",\"Invalid\")","v":"Valid"},null,"James Johnson","james.johnson@google.com"]
[]
[null,"RegEx Pattern","^[a-zA-Z0-9._%+-]+@[a-zA-Z0-9.-]+\\.[a-zA-Z]{2,}$",null,null,"RegEx Pattern","^[a-zA-Z0-9._%+-]+@[a-zA-Z0-9.-]+\\.[a-zA-Z]{2,}$"]

{"sheet":"Case Insensitive","index":9,"n_rows":16,"n_cols":8,"rows_kept":16,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,5,1,7]]}
[]
[null,"Performing Case Insensitive Matching with RegEx",null,null,null,"Practice Yourself"]
[]
[null,"Product Category","Product SKU","Matched?",null,"Product Category","Product SKU","Matched?"]
[null,"Laptop"," cOM-001-ABC",{"$f":"RegEx_Match(C5,$C$16,\"Yes\",\"No\",TRUE)","v":"No"},null,"Laptop"," cOM-001-ABC"]
[null,"Mouse"," COM-002-DEF",{"$f":"RegEx_Match(C6,$C$16,\"Yes\",\"No\",TRUE)","v":"Yes"},null,"Mouse"," COM-002-DEF"]
[null,"Laptop"," COM-003-GHI",{"$f":"RegEx_Match(C7,$C$16,\"Yes\",\"No\",TRUE)","v":"Yes"},null,"Laptop"," COM-003-GHI"]
[null,"Keyboard"," COM-004-JKL",{"$f":"RegEx_Match(C8,$C$16,\"Yes\",\"No\",TRUE)","v":"Yes"},null,"Keyboard"," COM-004-JKL"]
[null,"Monitor","COM-005-MNO",{"$f":"RegEx_Match(C9,$C$16,\"Yes\",\"No\",TRUE)","v":"Yes"},null,"Monitor","COM-005-MNO"]
[null,"Mouse"," COM-006-PQR",{"$f":"RegEx_Match(C10,$C$16,\"Yes\",\"No\",TRUE)","v":"Yes"},null,"Mouse"," COM-006-PQR"]
[null,"Mouspad"," COM-007-STU",{"$f":"RegEx_Match(C11,$C$16,\"Yes\",\"No\",TRUE)","v":"Yes"},null,"Mouspad"," COM-007-STU"]
[null,"Speaker"," COM-008-VWX",{"$f":"RegEx_Match(C12,$C$16,\"Yes\",\"No\",TRUE)","v":"Yes"},null,"Speaker"," COM-008-VWX"]
[null,"Smartphone"," SMP-009-HUW",{"$f":"RegEx_Match(C13,$C$16,\"Yes\",\"No\",TRUE)","v":"No"},null,"Smartphone"," SMP-009-HUW"]
[null,"Phone Cover"," SMP-010-IPH",{"$f":"RegEx_Match(C14,$C$16,\"Yes\",\"No\",TRUE)","v":"No"},null,"Phone Cover"," SMP-010-IPH"]
[]
[null,"RegEx Pattern","COM-\\d{3}-[A-Z]{3}$",null,null,"RegEx Pattern","COM-\\d{3}-[A-Z]{3}$"]

{"sheet":"Extract String","index":10,"n_rows":16,"n_cols":8,"rows_kept":16,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,5,1,7]]}
[]
[null,"Using RegEx to Extract Strings",null,null,null,"Practice Yourself"]
[]
[null,"Name","Unique Code","Joining Date",null,"Name","Unique Code","Joining Date"]
[null,"John Smith"," JS-DoJ-12-03-2017-PoS-6YRS",{"$f":"RegExtract(C5,$C$16)","v":"12-03-2017"},null,"John Smith"," JS-DoJ-12-03-2017-PoS-6YRS"]
[null,"Emma Johnson","EJ-DoJ-05-08-2019-PoS-2YRS",{"$f":"RegExtract(C6,$C$16)","v":"05-08-2019"},null,"Emma Johnson","EJ-DoJ-05-08-2019-PoS-2YRS"]
[null,"Michael Brown","MB-DoJ-07-12-2015-PoS-8YRS",{"$f":"RegExtract(C7,$C$16)","v":"07-12-2015"},null,"Michael Brown","MB-DoJ-07-12-2015-PoS-8YRS"]
[null,"Emily Davis","ED-DoJ-09-21-2018-PoS-4YRS",{"$f":"RegExtract(C8,$C$16)","v":"09-21-2018"},null,"Emily Davis","ED-DoJ-09-21-2018-PoS-4YRS"]
[null,"Daniel Wilson","DW-DoJ-03-17-2016-PoS-7YRS",{"$f":"RegExtract(C9,$C$16)","v":"03-17-2016"},null,"Daniel Wilson","DW-DoJ-03-17-2016-PoS-7YRS"]
[null,"Sophia Miller","SM-DoJ-11-05-2020-PoS-1YR",{"$f":"RegExtract(C10,$C$16)","v":"11-05-2020"},null,"Sophia Miller","SM-DoJ-11-05-2020-PoS-1YR"]
[null,"David Anderson","DA-DoJ-02-09-2014-PoS-9YRS",{"$f":"RegExtract(C11,$C$16)","v":"02-09-2014"},null,"David Anderson","DA-DoJ-02-09-2014-PoS-9YRS"]
[null,"Olivia Thompson","OT-DoJ-06-29-2017-PoS-5YRS",{"$f":"RegExtract(C12,$C$16)","v":"06-29-2017"},null,"Olivia Thompson","OT-DoJ-06-29-2017-PoS-5YRS"]
[null,"Benjamin Lee","BL-DoJ-10-14-2019-PoS-3YRS",{"$f":"RegExtract(C13,$C$16)","v":"10-14-2019"},null,"Benjamin Lee","BL-DoJ-10-14-2019-PoS-3YRS"]
[null,"Ava Garcia"," AG-DoJ-04-25-2016-PoS-7YRS",{"$f":"RegExtract(C14,$C$16)","v":"04-25-2016"},null,"Ava Garcia"," AG-DoJ-04-25-2016-PoS-7YRS"]
[]
[null,"RegEx Pattern","\\d{2}-\\d{2}-\\d{4}",null,null,"RegEx Pattern","\\d{2}-\\d{2}-\\d{4}"]

{"sheet":"Replace","index":11,"n_rows":17,"n_cols":8,"rows_kept":17,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,5,1,7]]}
[]
[null,"Using RegEx to Replace Strings",null,null,null,"Practice Yourself"]
[]
[null,"Name","Unique Code","Encrypted Code",null,"Name","Unique Code","Encrypted Code"]
[null,"John Smith"," JS-DoJ-12-03-2017-PoS-6YRS",{"$f":"RegReplace(C5,$C$16,$C$17)","v":" JS-DoJ-xx-xx-xxxx-PoS-xYRS"},null,"John Smith"," JS-DoJ-12-03-2017-PoS-6YRS"]
[null,"Emma Johnson","EJ-DoJ-05-08-2019-PoS-2YRS",{"$f":"RegReplace(C6,$C$16,$C$17,1)","v":"EJ-DoJ-xx-xx-xxxx-PoS-xYRS"},null,"Emma Johnson","EJ-DoJ-05-08-2019-PoS-2YRS"]
[null,"Michael Brown","MB-DoJ-07-12-2015-PoS-8YRS",{"$f":"RegReplace(C7,$C$16,$C$17,1)","v":"MB-DoJ-xx-xx-xxxx-PoS-xYRS"},null,"Michael Brown","MB-DoJ-07-12-2015-PoS-8YRS"]
[null,"Emily Davis","ED-DoJ-09-21-2018-PoS-4YRS",{"$f":"RegReplace(C8,$C$16,$C$17,1)","v":"ED-DoJ-xx-xx-xxxx-PoS-xYRS"},null,"Emily Davis","ED-DoJ-09-21-2018-PoS-4YRS"]
[null,"Daniel Wilson","DW-DoJ-03-17-2016-PoS-7YRS",{"$f":"RegReplace(C9,$C$16,$C$17,1)","v":"DW-DoJ-xx-xx-xxxx-PoS-xYRS"},null,"Daniel Wilson","DW-DoJ-03-17-2016-PoS-7YRS"]
[null,"Sophia Miller","SM-DoJ-11-05-2020-PoS-1YR",{"$f":"RegReplace(C10,$C$16,$C$17,1)","v":"SM-DoJ-xx-xx-xxxx-PoS-xYR"},null,"Sophia Miller","SM-DoJ-11-05-2020-PoS-1YR"]
[null,"David Anderson","DA-DoJ-02-09-2014-PoS-9YRS",{"$f":"RegReplace(C11,$C$16,$C$17,1)","v":"DA-DoJ-xx-xx-xxxx-PoS-xYRS"},null,"David Anderson","DA-DoJ-02-09-2014-PoS-9YRS"]
[null,"Olivia Thompson","OT-DoJ-06-29-2017-PoS-5YRS",{"$f":"RegReplace(C12,$C$16,$C$17,1)","v":"OT-DoJ-xx-xx-xxxx-PoS-xYRS"},null,"Olivia Thompson","OT-DoJ-06-29-2017-PoS-5YRS"]
[null,"Benjamin Lee","BL-DoJ-10-14-2019-PoS-3YRS",{"$f":"RegReplace(C13,$C$16,$C$17,1)","v":"BL-DoJ-xx-xx-xxxx-PoS-xYRS"},null,"Benjamin Lee","BL-DoJ-10-14-2019-PoS-3YRS"]
[null,"Ava Garcia"," AG-DoJ-04-25-2016-PoS-7YRS",{"$f":"RegReplace(C14,$C$16,$C$17,1)","v":" AG-DoJ-xx-xx-xxxx-PoS-xYRS"},null,"Ava Garcia"," AG-DoJ-04-25-2016-PoS-7YRS"]
[]
[null,"RegEx Pattern","\\d{2}-\\d{2}-\\d{4}-PoS-\\d",null,null,"RegEx Pattern","\\d{2}-\\d{2}-\\d{4}-PoS-\\d"]
[null,"Replaced Text","xx-xx-xxxx-PoS-x",null,null,"Replaced Text","xx-xx-xxxx-PoS-x"]

{"sheet":"Without VBA","index":12,"n_rows":14,"n_cols":8,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,5,1,7]]}
[]
[null,"Regular Expression Formula Without VBA",null,null,null,"Practice Yourself"]
[]
[null,"Product Category","Product SKU","Matched?",null,"Product Category","Product SKU","Matched?"]
[null,"Laptop","COM-001-ABC",{"$f":"AND(LEN(C5)=11, COUNT(FIND(MID(LEFT(C5,3),ROW(INDIRECT(\"1:\"&LEN(LEFT(C5,3)))),1),UPPER(Letters)))=LEN(LEFT(C5,3)), COUNT(FIND(MID(MID(C5,5,3),ROW(INDIRECT(\"1:\"&LEN(MID(C5,5,3)))),1), Numbers))=LEN(MID(C5,5,3)), COUNT(FIND(MID(RIGHT(C5,3),{1,2,3},1),Letters))=3)","v":true},null,"Laptop","COM-001-ABC"]
[null,"Mouse","COM-002-DEF",{"$f":"AND(LEN(C6)=11, COUNT(FIND(MID(LEFT(C6,3),ROW(INDIRECT(\"1:\"&LEN(LEFT(C6,3)))),1),UPPER(Letters)))=LEN(LEFT(C6,3)), COUNT(FIND(MID(MID(C6,5,3),ROW(INDIRECT(\"1:\"&LEN(MID(C6,5,3)))),1), Numbers))=LEN(MID(C6,5,3)), COUNT(FIND(MID(RIGHT(C6,3),{1,2,3},1),Letters))=3)","v":true},null,"Mouse","COM-002-DEF"]
[null,"Laptop","COM-003-GHI",{"$f":"AND(LEN(C7)=11, COUNT(FIND(MID(LEFT(C7,3),ROW(INDIRECT(\"1:\"&LEN(LEFT(C7,3)))),1),UPPER(Letters)))=LEN(LEFT(C7,3)), COUNT(FIND(MID(MID(C7,5,3),ROW(INDIRECT(\"1:\"&LEN(MID(C7,5,3)))),1), Numbers))=LEN(MID(C7,5,3)), COUNT(FIND(MID(RIGHT(C7,3),{1,2,3},1),Letters))=3)","v":true},null,"Laptop","COM-003-GHI"]
[null,"Keyboard","COM-004-JKL",{"$f":"AND(LEN(C8)=11, COUNT(FIND(MID(LEFT(C8,3),ROW(INDIRECT(\"1:\"&LEN(LEFT(C8,3)))),1),UPPER(Letters)))=LEN(LEFT(C8,3)), COUNT(FIND(MID(MID(C8,5,3),ROW(INDIRECT(\"1:\"&LEN(MID(C8,5,3)))),1), Numbers))=LEN(MID(C8,5,3)), COUNT(FIND(MID(RIGHT(C8,3),{1,2,3},1),Letters))=3)","v":true},null,"Keyboard","COM-004-JKL"]
[null,"Monitor","COM-005-MNO",{"$f":"AND(LEN(C9)=11, COUNT(FIND(MID(LEFT(C9,3),ROW(INDIRECT(\"1:\"&LEN(LEFT(C9,3)))),1),UPPER(Letters)))=LEN(LEFT(C9,3)), COUNT(FIND(MID(MID(C9,5,3),ROW(INDIRECT(\"1:\"&LEN(MID(C9,5,3)))),1), Numbers))=LEN(MID(C9,5,3)), COUNT(FIND(MID(RIGHT(C9,3),{1,2,3},1),Letters))=3)","v":true},null,"Monitor","COM-005-MNO"]
[null,"Mouse","COM-006-Pqa",{"$f":"AND(LEN(C10)=11, COUNT(FIND(MID(LEFT(C10,3),ROW(INDIRECT(\"1:\"&LEN(LEFT(C10,3)))),1),UPPER(Letters)))=LEN(LEFT(C10,3)), COUNT(FIND(MID(MID(C10,5,3),ROW(INDIRECT(\"1:\"&LEN(MID(C10,5,3)))),1), Numbers))=LEN(MID(C10,5,3)), COUNT(FIND(MID(RIGHT(C10,3),{1,2,3},1),Letters))=3)","v":false},null,"Mouse","COM-006-Pqa"]
[null,"Mouspad","COM-007-STU",{"$f":"AND(LEN(C11)=11, COUNT(FIND(MID(LEFT(C11,3),ROW(INDIRECT(\"1:\"&LEN(LEFT(C11,3)))),1),UPPER(Letters)))=LEN(LEFT(C11,3)), COUNT(FIND(MID(MID(C11,5,3),ROW(INDIRECT(\"1:\"&LEN(MID(C11,5,3)))),1), Numbers))=LEN(MID(C11,5,3)), COUNT(FIND(MID(RIGHT(C11,3),{1,2,3},1),Letters))=3)","v":true},null,"Mouspad","COM-007-STU"]
[null,"Speaker","COM-008-VWX",{"$f":"AND(LEN(C12)=11, COUNT(FIND(MID(LEFT(C12,3),ROW(INDIRECT(\"1:\"&LEN(LEFT(C12,3)))),1),UPPER(Letters)))=LEN(LEFT(C12,3)), COUNT(FIND(MID(MID(C12,5,3),ROW(INDIRECT(\"1:\"&LEN(MID(C12,5,3)))),1), Numbers))=LEN(MID(C12,5,3)), COUNT(FIND(MID(RIGHT(C12,3),{1,2,3},1),Letters))=3)","v":true},null,"Speaker","COM-008-VWX"]
[null,"Smartphone","SMP-009-HUW",{"$f":"AND(LEN(C13)=11, COUNT(FIND(MID(LEFT(C13,3),ROW(INDIRECT(\"1:\"&LEN(LEFT(C13,3)))),1),UPPER(Letters)))=LEN(LEFT(C13,3)), COUNT(FIND(MID(MID(C13,5,3),ROW(INDIRECT(\"1:\"&LEN(MID(C13,5,3)))),1), Numbers))=LEN(MID(C13,5,3)), COUNT(FIND(MID(RIGHT(C13,3),{1,2,3},1),Letters))=3)","v":true},null,"Smartphone","SMP-009-HUW"]
[null,"Phone Cover","SMP-010-IP9",{"$f":"AND(LEN(C14)=11, COUNT(FIND(MID(LEFT(C14,3),ROW(INDIRECT(\"1:\"&LEN(LEFT(C14,3)))),1),UPPER(Letters)))=LEN(LEFT(C14,3)), COUNT(FIND(MID(MID(C14,5,3),ROW(INDIRECT(\"1:\"&LEN(MID(C14,5,3)))),1), Numbers))=LEN(MID(C14,5,3)), COUNT(FIND(MID(RIGHT(C14,3),{1,2,3},1),Letters))=3)","v":false},null,"Phone Cover","SMP-010-IP9"]