{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Sheet1","Sheet2","Sheet3","Sheet4","Sheet5"],"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":21,"n_cols":9,"rows_kept":21,"cut":false,"hidden":false,"merged":[]}
[]
[null,"String",null,"Pattern","Result","Formula",null,"Website:","Get Digital Help"]
[null,123,null,"12#",{"$f":"Compare(B3,D3)","v":true},{"$f":"_xlfn.FORMULATEXT(E3)","v":"=Compare(B3,D3)"},null,"Webpage:","LIKE operator"]
[null,123,null,"1#",{"$f":"Compare(B4,D4)","v":false},"=Compare(B4,D4)"]
[null,123,null,"#2#",{"$f":"Compare(B5,D5)","v":true},"=Compare(B5,D5)"]
[null,"ABC",null,"A?C",{"$f":"Compare(B6,D6)","v":true},"=Compare(B6,D6)"]
[null,"ABCD",null,"A?D",{"$f":"Compare(B7,D7)","v":false},"=Compare(B7,D7)"]
[null,"ABCD",null,"?BC?",{"$f":"Compare(B8,D8)","v":true},"=Compare(B8,D8)"]
[null,"AAAC",null,"AAA*",{"$f":"Compare(B9,D9)","v":true},"=Compare(B9,D9)"]
[null,"AAAC",null,"aaa*",{"$f":"Compare(B10,D10)","v":false},"=Compare(B10,D10)"]
[null,"DDC23E",null,"DD*E",{"$f":"Compare(B11,D11)","v":true},"=Compare(B11,D11)"]
[null,"AA23BB",null,"*##??",{"$f":"Compare(B12,D12)","v":true},"=Compare(B12,D12)"]
[null,"AA23BB",null,"*##?",{"$f":"Compare(B13,D13)","v":false},"=Compare(B13,D13)"]
[null,"AA23BB",null,"*##*",{"$f":"Compare(B14,D14)","v":true},"=Compare(B14,D14)"]
[null,"ABCD",null,"[A]*",{"$f":"Compare(B15,D15)","v":true},"=Compare(B15,D15)",null,"Webpage:","LIKE operator"]
[null,"ABCD",null,"[A]",{"$f":"Compare(B16,D16)","v":false},"=Compare(B16,D16)"]
[null,"ABCD",null,"[!A]*",{"$f":"Compare(B17,D17)","v":false},"=Compare(B17,D17)"]
[null,"C22R",null,"[A-Z]##?",{"$f":"Compare(B18,D18)","v":true},"=Compare(B18,D18)"]
[null,"C22R",null,"[A-Z]##[A-Z]",{"$f":"Compare(B19,D19)","v":true},"=Compare(B19,D19)"]
[null,"C222",null,"[A-Z]##[A-Z]",{"$f":"Compare(B20,D20)","v":false},"=Compare(B20,D20)"]
[null,552513256,null,"*1*",{"$f":"Compare(B21,D21)","v":true}]

{"sheet":"Sheet2","index":1,"n_rows":16,"n_cols":12,"rows_kept":16,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Values",null,"Pattern:",null,null,null,null,{"$f":"CHAR(RANDBETWEEN(65,67))&CHAR(RANDBETWEEN(65,67))&CHAR(RANDBETWEEN(65,67))","v":"BBA"}]
[null,"AAC",null,"?B?",null,null,null,null,{"$f":"CHAR(RANDBETWEEN(65,67))&CHAR(RANDBETWEEN(65,67))&CHAR(RANDBETWEEN(65,67))","v":"CCC"},null,"Website:","Get Digital Help"]
[null,"BCC",null,null,null,null,null,null,{"$f":"CHAR(RANDBETWEEN(65,67))&CHAR(RANDBETWEEN(65,67))&CHAR(RANDBETWEEN(65,67))","v":"CBA"},null,"Webpage:","LIKE operator"]
[null,"AAA",null,"Results:",null,null,null,null,"BAC"]
[null,"CAB",null,{"$f":"SearchPattern(B3:B16,D3)","v":"ABB"},null,null,null,null,"BCC"]
[null,"AAA",null,"BBB",null,null,null,null,"BCB"]
[null,"BCA",null,"ABB",null,null,null,null,"BBC"]
[null,"CAA",null,"BBC",null,null,null,null,"BAC"]
[null,"ABB",null,"",null,null,null,null,"CCC"]
[null,"CCB",null,null,null,null,null,null,"AAA"]
[null,"BBB",null,null,null,null,null,null,"BCA"]
[null,"ACA",null,null,null,null,null,null,"ABB"]
[null,"ABB",null,null,null,null,null,null,"AAB"]
[null,"BAC",null,null,null,null,null,null,"BBA"]
[null,"BBC"]

{"sheet":"Sheet3","index":2,"n_rows":16,"n_cols":10,"rows_kept":16,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Values","Numbers",null,"Pattern:"]
[null,"AAC",1,null,"?B?",null,null,null,"Website:","Get Digital Help"]
[null,"BCC",2,null,null,null,null,null,"Webpage:","LIKE operator"]
[null,"AAA",3,null,"Results:"]
[null,"CAB",4,null,{"$f":"SearchCol(B3:B16,C3:C16,E3)","v":"8"}]
[null,"AAA",5,null,"10"]
[null,"BCA",6,null,"12"]
[null,"CAA",7,null,"14"]
[null,"ABB",8,null,""]
[null,"CCB",9]
[null,"BBB",10]
[null,"ACA",11]
[null,"ABB",12]
[null,"BAC",13]
[null,"BBC",14]

{"sheet":"Sheet4","index":3,"n_rows":15,"n_cols":7,"rows_kept":15,"cut":false,"hidden":false,"merged":[]}
["Values","Pattern:","Count:"]
["AAC","*B",{"$f":"COUNTIF(A2:A15,B2)","v":5},null,null,"Website:","Get Digital Help"]
["BCC",null,null,null,null,"Webpage:","LIKE operator"]
["AAA"]
["CAB"]
["AAA"]
["BCA"]
["CAA"]
["ABB"]
["CCB"]
["BBB"]
["ACA"]
["ABB"]
["BAC"]
["BBC"]

{"sheet":"Sheet5","index":4,"n_rows":10,"n_cols":8,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Text",null,"Pattern:","[A-Z]##[A-Z]",null,"Website:","Get Digital Help"]
[null,"A123B 22",null,null,null,null,"Webpage:","LIKE operator"]
[null,"A1B H44Z",null,"Result:"]
[null,"A44C",null,{"$f":"ExtractWords(B3:B10,E2)","v":"H44Z"}]
[null,"AA323B",null,"A44C"]
[null,"VV54CDE",null,"M23Q"]
[null,"4AB76"]
[null,"M23Q X5W"]
[null,"V22 X33FF"]