{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Sheet1","Sheet2","Sheet3"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"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":"Sheet1","index":0,"n_rows":16,"n_cols":4,"rows_kept":16,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Using RegEx to Match SKU Codes"]
[]
[null,"Product Category","Product SKU","Matched?"]
[null,"Laptop"," COM-001-ABC",{"$f":"RegEx_Match(C5,$C$16)","v":"Matched"}]
[null,"Mouse"," COM-002-DEF",{"$f":"RegEx_Match(C6,$C$16)","v":"Matched"}]
[null,"Laptop"," COM-003-GHI",{"$f":"RegEx_Match(C7,$C$16)","v":"Matched"}]
[null,"Keyboard"," COM-004-JKL",{"$f":"RegEx_Match(C8,$C$16)","v":"Matched"}]
[null,"Monitor","COM-005-MNO",{"$f":"RegEx_Match(C9,$C$16)","v":"Matched"}]
[null,"Mouse"," COM-006-PQR",{"$f":"RegEx_Match(C10,$C$16)","v":"Matched"}]
[null,"Mouspad"," COM-007-STU",{"$f":"RegEx_Match(C11,$C$16)","v":"Matched"}]
[null,"Speaker"," COM-008-VWX",{"$f":"RegEx_Match(C12,$C$16)","v":"Matched"}]
[null,"Smartphone"," SMP-009-HUW",{"$f":"RegEx_Match(C13,$C$16)","v":"Unmatched"}]
[null,"Phone Cover"," SMP-010-IPH",{"$f":"RegEx_Match(C14,$C$16)","v":"Unmatched"}]
[]
[null,"RegEx Pattern","COM-\\d{3}-[A-Z]{3}$"]

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

{"sheet":"Sheet3","index":2,"n_rows":17,"n_cols":4,"rows_kept":17,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Using RegEx to Replace Strings"]
[]
[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,"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,"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,"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,"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,"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,"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,"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,"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,"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,"RegEx Pattern","\\d{2}-\\d{2}-\\d{4}-PoS-\\d"]
[null,"Replaced Text","xx-xx-xxxx-PoS-x"]