{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["Formula","Extract","Extract (2)","Split","func1","func1 (2)","func1 (3)","func1 (4)"],"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":"Formula","index":0,"n_rows":22,"n_cols":14,"rows_kept":22,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,12,1,13]]}
[]
[null,"Applying Formula",null,null,null,null,null,null,null,null,null,null,"Practice"]
[]
[null,"Pattern","Matched/Not Matched",null,null,null,null,null,null,null,null,null,"Pattern","Matched/Not Matched"]
[null,"AIJ789mkl",{"$f":"AND(LEN(B5)=9,COUNT(FIND(MID(LEFT(B5,3), ROW(INDIRECT(\"1:\"&LEN(LEFT(B5,3)))),1 ),UPPER(Letters)))=LEN(LEFT(B5,3)),COUNT(FIND(MID(MID(B5,4,3), ROW(INDIRECT(\"1:\"&LEN(MID(B5,4,3)))),1 ),Numbers))=LEN(MID(B5,4,3)),ISNUMBER(FIND(RIGHT(B5),Letters)))","v":true},null,null,null,null,null,null,null,null,null,"AIJ789mkl"]
[null,"SGF789mkL",{"$f":"AND(LEN(B6)=9,COUNT(FIND(MID(LEFT(B6,3), ROW(INDIRECT(\"1:\"&LEN(LEFT(B6,3)))),1 ),UPPER(Letters)))=LEN(LEFT(B6,3)),COUNT(FIND(MID(MID(B6,4,3), ROW(INDIRECT(\"1:\"&LEN(MID(B6,4,3)))),1 ),Numbers))=LEN(MID(B6,4,3)),ISNUMBER(FIND(RIGHT(B6),Letters)))","v":false},null,null,null,null,null,null,null,null,null,"SGF789mkL"]
[null,"Aio7a9mkl",{"$f":"AND(LEN(B7)=9,COUNT(FIND(MID(LEFT(B7,3), ROW(INDIRECT(\"1:\"&LEN(LEFT(B7,3)))),1 ),UPPER(Letters)))=LEN(LEFT(B7,3)),COUNT(FIND(MID(MID(B7,4,3), ROW(INDIRECT(\"1:\"&LEN(MID(B7,4,3)))),1 ),Numbers))=LEN(MID(B7,4,3)),ISNUMBER(FIND(RIGHT(B7),Letters)))","v":false},null,null,null,null,null,null,null,null,null,"Aio7a9mkl"]
[null,"AKU654yui",{"$f":"AND(LEN(B8)=9,COUNT(FIND(MID(LEFT(B8,3), ROW(INDIRECT(\"1:\"&LEN(LEFT(B8,3)))),1 ),UPPER(Letters)))=LEN(LEFT(B8,3)),COUNT(FIND(MID(MID(B8,4,3), ROW(INDIRECT(\"1:\"&LEN(MID(B8,4,3)))),1 ),Numbers))=LEN(MID(B8,4,3)),ISNUMBER(FIND(RIGHT(B8),Letters)))","v":true},null,null,null,null,null,null,null,null,null,"AKU654yui"]
[null,"UIY969uoy",{"$f":"AND(LEN(B9)=9,COUNT(FIND(MID(LEFT(B9,3), ROW(INDIRECT(\"1:\"&LEN(LEFT(B9,3)))),1 ),UPPER(Letters)))=LEN(LEFT(B9,3)),COUNT(FIND(MID(MID(B9,4,3), ROW(INDIRECT(\"1:\"&LEN(MID(B9,4,3)))),1 ),Numbers))=LEN(MID(B9,4,3)),ISNUMBER(FIND(RIGHT(B9),Letters)))","v":true},null,null,null,null,null,null,null,null,null,"UIY969uoy"]
[null,"POI654tre",{"$f":"AND(LEN(B10)=9,COUNT(FIND(MID(LEFT(B10,3), ROW(INDIRECT(\"1:\"&LEN(LEFT(B10,3)))),1 ),UPPER(Letters)))=LEN(LEFT(B10,3)),COUNT(FIND(MID(MID(B10,4,3), ROW(INDIRECT(\"1:\"&LEN(MID(B10,4,3)))),1 ),Numbers))=LEN(MID(B10,4,3)),ISNUMBER(FIND(RIGHT(B10),Letters)))","v":true},null,null,null,null,null,null,null,null,null,"POI654tre"]
[null,"QWT324mcf",{"$f":"AND(LEN(B11)=9,COUNT(FIND(MID(LEFT(B11,3), ROW(INDIRECT(\"1:\"&LEN(LEFT(B11,3)))),1 ),UPPER(Letters)))=LEN(LEFT(B11,3)),COUNT(FIND(MID(MID(B11,4,3), ROW(INDIRECT(\"1:\"&LEN(MID(B11,4,3)))),1 ),Numbers))=LEN(MID(B11,4,3)),ISNUMBER(FIND(RIGHT(B11),Letters)))","v":true},null,null,null,null,null,null,null,null,null,"QWT324mcf"]
[null,"9IJa89mkl",{"$f":"AND(LEN(B12)=9,COUNT(FIND(MID(LEFT(B12,3), ROW(INDIRECT(\"1:\"&LEN(LEFT(B12,3)))),1 ),UPPER(Letters)))=LEN(LEFT(B12,3)),COUNT(FIND(MID(MID(B12,4,3), ROW(INDIRECT(\"1:\"&LEN(MID(B12,4,3)))),1 ),Numbers))=LEN(MID(B12,4,3)),ISNUMBER(FIND(RIGHT(B12),Letters)))","v":false},null,null,null,null,null,null,null,null,null,"9IJa89mkl"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,""]

{"sheet":"Extract","index":1,"n_rows":22,"n_cols":16,"rows_kept":22,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,14,1,15]]}
[]
[null,"Extract with Function",null,null,null,null,null,null,null,null,null,null,null,null,"Practice"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,"Pattern","Extracted Portion",null,null,null,null,null,null,null,null,null,null,null,"Pattern","Extracted Portion"]
[null,"AIJU789",{"$f":"match_pat(B5)","v":"789"},null,null,null,null,null,null,null,null,null,null,null,"AIJU789"]
[null,"SGFY7898",{"$f":"match_pat(B6)","v":"7898"},null,null,null,null,null,null,null,null,null,null,null,"SGFY7898"]
[null,"AioI7a9mkl",{"$f":"match_pat(B7)","v":"7a9mkl"},null,null,null,null,null,null,null,null,null,null,null,"AioI7a9mkl"]
[null,"AKUT6546",{"$f":"match_pat(B8)","v":"6546"},null,null,null,null,null,null,null,null,null,null,null,"AKUT6546"]
[null,"UIYJ9697uoy",{"$f":"match_pat(B9)","v":"9697uoy"},null,null,null,null,null,null,null,null,null,null,null,"UIYJ9697uoy"]
[null,"POIu6547",{"$f":"match_pat(B10)","v":"6547"},null,null,null,null,null,null,null,null,null,null,null,"POIu6547"]
[null,"QWTy3247",{"$f":"match_pat(B11)","v":"3247"},null,null,null,null,null,null,null,null,null,null,null,"QWTy3247"]
[null,"UOPW5643",{"$f":"match_pat(B12)","v":"5643"},null,null,null,null,null,null,null,null,null,null,null,"UOPW5643"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,""]

{"sheet":"Extract (2)","index":2,"n_rows":22,"n_cols":15,"rows_kept":22,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,13,1,14]]}
[null," "]
[null,"Extract within a Loop",null,null,null,null,null,null,null,null,null,null,null,"Practice"]
[null," ",null,null,null,null,null,null,null,null,null,null,null," "]
[null,"Pattern","Extracted Portion",null,null,null,null,null,null,null,null,null,null,"Pattern","Extracted Portion"]
[null,"AIJU789",789,null,null,null,null,null,null,null,null,null,null,"AIJU789"]
[null,"SGFY7898",7898,null,null,null,null,null,null,null,null,null,null,"SGFY7898"]
[null,"AioI7a9mkl","7a9mkl",null,null,null,null,null,null,null,null,null,null,"AioI7a9mkl"]
[null,"AKUT6546",6546,null,null,null,null,null,null,null,null,null,null,"AKUT6546"]
[null,"UIYJ9697uoy","9697uoy",null,null,null,null,null,null,null,null,null,null,"UIYJ9697uoy"]
[null,"POIu6547",6547,null,null,null,null,null,null,null,null,null,null,"POIu6547"]
[null,"QWTy3247",3247,null,null,null,null,null,null,null,null,null,null,"QWTy3247"]
[null,"UOPW5643",5643,null,null,null,null,null,null,null,null,null,null,"UOPW5643"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,""]

{"sheet":"Split","index":3,"n_rows":22,"n_cols":18,"rows_kept":22,"cut":false,"hidden":false,"merged":[[1,1,1,4],[1,14,1,17]]}
[null," "]
[null,"Split Values Based on REGEX Pattern",null,null,null,null,null,null,null,null,null,null,null,null,"Practice"]
[null," ",null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,"Pattern","Part 1","Part 2","Part 3",null,null,null,null,null,null,null,null,null,"Pattern","Part 1","Part 2","Part 3"]
[null,"1675Ac5324",1675,"Ac",5324,null,null,null,null,null,null,null,null,null,"1675Ac5324"]
[null,"SGFY7898"," ",null,null,null,null,null,null,null,null,null,null,null,"SGFY7898"]
[null,"6723ff7410",6723,"ff",7410,null,null,null,null,null,null,null,null,null,"6723ff7410"]
[null,"AKUT6546nhd"," ",null,null,null,null,null,null,null,null,null,null,null,"AKUT6546nhd"]
[null,"6134vB5613",6134,"vB",5613,null,null,null,null,null,null,null,null,null,"6134vB5613"]
[null,"7814DD5243",7814,"DD",5243,null,null,null,null,null,null,null,null,null,"7814DD5243"]
[null,"8156HJ7844",8156,"HJ",7844,null,null,null,null,null,null,null,null,null,"8156HJ7844"]
[null,"8276jK2409",8276,"jK",2409,null,null,null,null,null,null,null,null,null,"8276jK2409"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,""]

{"sheet":"func1","index":4,"n_rows":23,"n_cols":16,"rows_kept":23,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,14,1,15]]}
[null," "]
[null,"Checking Any Combination of Numbers and Texts",null,null,null,null,null,null,null,null,null,null,null,null,"Practice"]
[null," ",null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,"Pattern","Extracted Portion",null,null,null,null,null,null,null,null,null,null,null,"Pattern","Extracted Portion"]
[null,"6789uuyt",{"$f":"matchP(B5,\"\\D{4}\\d{4}\")","v":false},null,null,null,null,null,null,null,null,null,null,null,"6789uuyt"]
[null,"sGFY7898",{"$f":"matchP(B6,\"\\D{4}\\d{4}\")","v":true},null,null,null,null,null,null,null,null,null,null,null,"sGFY7898"]
[null,"AioI7a9mkl",{"$f":"matchP(B7,\"\\D{4}\\d{4}\")","v":false},null,null,null,null,null,null,null,null,null,null,null,"AioI7a9mkl"]
[null,"AKUT6546",{"$f":"matchP(B8,\"\\D{4}\\d{4}\")","v":true},null,null,null,null,null,null,null,null,null,null,null,"AKUT6546"]
[null,"UIYJ9697uoy",{"$f":"matchP(B9,\"\\D{4}\\d{4}\")","v":true},null,null,null,null,null,null,null,null,null,null,null,"UIYJ9697uoy"]
[null,"POIu6547",{"$f":"matchP(B10,\"\\D{4}\\d{4}\")","v":true},null,null,null,null,null,null,null,null,null,null,null,"POIu6547"]
[null,"QWTy3247",{"$f":"matchP(B11,\"\\D{4}\\d{4}\")","v":true},null,null,null,null,null,null,null,null,null,null,null,"QWTy3247"]
[null,"UOPW5643",{"$f":"matchP(B12,\"\\D{4}\\d{4}\")","v":true},null,null,null,null,null,null,null,null,null,null,null,"UOPW5643"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,""]

{"sheet":"func1 (2)","index":5,"n_rows":25,"n_cols":16,"rows_kept":25,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,14,1,15]]}
[null," "]
[null,"Checking Any Combination of Numbers and Texts",null,null,null,null,null,null,null,null,null,null,null,null,"Practice"]
[null," ",null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,"Pattern","Extracted Portion",null,null,null,null,null,null,null,null,null,null,null,"Pattern","Extracted Portion"]
[null,"6789uuyt",{"$f":"matchP(B5,\"\\w{8}\")","v":true},null,null,null,null,null,null,null,null,null,null,null,"6789uuyt"]
[null,"sGFY7898",{"$f":"matchP(B6,\"\\w{8}\")","v":true},null,null,null,null,null,null,null,null,null,null,null,"sGFY7898"]
[null,"AioI7a9mkl",{"$f":"matchP(B7,\"\\w{8}\")","v":true},null,null,null,null,null,null,null,null,null,null,null,"AioI7a9mkl"]
[null,"AKUT6546",{"$f":"matchP(B8,\"\\w{8}\")","v":true},null,null,null,null,null,null,null,null,null,null,null,"AKUT6546"]
[null,"UIYJ9697uoy",{"$f":"matchP(B9,\"\\w{8}\")","v":true},null,null,null,null,null,null,null,null,null,null,null,"UIYJ9697uoy"]
[null,"POIu6547",{"$f":"matchP(B10,\"\\w{8}\")","v":true},null,null,null,null,null,null,null,null,null,null,null,"POIu6547"]
[null,"QWTy3247",{"$f":"matchP(B11,\"\\w{8}\")","v":true},null,null,null,null,null,null,null,null,null,null,null,"QWTy3247"]
[null,"UOPW5643",{"$f":"matchP(B12,\"\\w{8}\")","v":true},null,null,null,null,null,null,null,null,null,null,null,"UOPW5643"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,""]
[]
[null,null,null,null,null,null,null,null,null,null,null,""]

{"sheet":"func1 (3)","index":6,"n_rows":25,"n_cols":14,"rows_kept":25,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,12,1,13]]}
[null," "]
[null,"Checking Any Combination of Phone Numbers",null,null,null,null,null,null,null,null,null,null,"Practice"]
[null," ",null,null,null,null,null,null,null,null,null,null," "]
[null,"Pattern","Extracted Portion",null,null,null,null,null,null,null,null,null,"Pattern","Extracted Portion"]
[null,"\n+1 123 237 4567 ",{"$f":"matchP(B5,\"(\\(\\d{3}\\)|\\d{3})[-\\.\\s]?\\d{3}[-\\.\\s]?\\d{4}\")","v":true},null,null,null,null,null,null,null,null,null,"\n+1 123 237 4567 "]
[null,"\n+1 (123) 237 4568",{"$f":"matchP(B6,\"(\\(\\d{3}\\)|\\d{3})[-\\.\\s]?\\d{3}[-\\.\\s]?\\d{4}\")","v":true},null,null,null,null,null,null,null,null,null,"\n+1 (123) 237 4568"]
[null,"\n+1 123.237.4569",{"$f":"matchP(B7,\"(\\(\\d{3}\\)|\\d{3})[-\\.\\s]?\\d{3}[-\\.\\s]?\\d{4}\")","v":true},null,null,null,null,null,null,null,null,null,"\n+1 123.237.4569"]
[null,"+1 786kl90908",{"$f":"matchP(B8,\"(\\(\\d{3}\\)|\\d{3})[-\\.\\s]?\\d{3}[-\\.\\s]?\\d{4}\")","v":false},null,null,null,null,null,null,null,null,null,"+1 786kl90908"]
[null,"\n+1 123-879-4571",{"$f":"matchP(B9,\"(\\(\\d{3}\\)|\\d{3})[-\\.\\s]?\\d{3}[-\\.\\s]?\\d{4}\")","v":true},null,null,null,null,null,null,null,null,null,"\n+1 123-879-4571"]
[null,"\n+1 (123) 237 4572",{"$f":"matchP(B10,\"(\\(\\d{3}\\)|\\d{3})[-\\.\\s]?\\d{3}[-\\.\\s]?\\d{4}\")","v":true},null,null,null,null,null,null,null,null,null,"\n+1 (123) 237 4572"]
[null,"\n+1 123 237 4573",{"$f":"matchP(B11,\"(\\(\\d{3}\\)|\\d{3})[-\\.\\s]?\\d{3}[-\\.\\s]?\\d{4}\")","v":true},null,null,null,null,null,null,null,null,null,"\n+1 123 237 4573"]
[null,"\n+1 123.237.4574",{"$f":"matchP(B12,\"(\\(\\d{3}\\)|\\d{3})[-\\.\\s]?\\d{3}[-\\.\\s]?\\d{4}\")","v":true},null,null,null,null,null,null,null,null,null,"\n+1 123.237.4574"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,""]
[]
[null,null,null,null,null,null,null,null,null,null,null,""]

{"sheet":"func1 (4)","index":7,"n_rows":25,"n_cols":15,"rows_kept":25,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,13,1,14]]}
[null," "]
[null,"Checking Email Patterns",null,null,null,null,null,null,null,null,null,null,null,"Practice"]
[null," ",null,null,null,null,null,null,null,null,null,null,null," "]
[null,"Pattern","Extracted Portion",null,null,null,null,null,null,null,null,null,null,"Pattern","Extracted Portion"]
[null,"sales@chain-frame.com",{"$f":"matchP(B5,\"[\\w\\.\\-]+@[A-Za-z0-9]+[A-Za-z0-9\\.\\-]*[A-Za-z0-9]+\")","v":true},null,null,null,null,null,null,null,null,null,null,"sales@chain-frame.com"]
[null,"taiwan@chain.com",{"$f":"matchP(B6,\"[\\w\\.\\-]+@[A-Za-z0-9]+[A-Za-z0-9\\.\\-]*[A-Za-z0-9]+\")","v":true},null,null,null,null,null,null,null,null,null,null,"taiwan@chain.com"]
[null,"sder@gmail.com",{"$f":"matchP(B7,\"[\\w\\.\\-]+@[A-Za-z0-9]+[A-Za-z0-9\\.\\-]*[A-Za-z0-9]+\")","v":true},null,null,null,null,null,null,null,null,null,null,"sder@gmail.com"]
[null,"sales@outlook.com",{"$f":"matchP(B8,\"[\\w\\.\\-]+@[A-Za-z0-9]+[A-Za-z0-9\\.\\-]*[A-Za-z0-9]+\")","v":true},null,null,null,null,null,null,null,null,null,null,"sales@outlook.com"]
[null,"usasales@yui.frame.com",{"$f":"matchP(B9,\"[\\w\\.\\-]+@[A-Za-z0-9]+[A-Za-z0-9\\.\\-]*[A-Za-z0-9]+\")","v":true},null,null,null,null,null,null,null,null,null,null,"usasales@yui.frame.com"]
[null,"galliver@gmail.com",{"$f":"matchP(B10,\"[\\w\\.\\-]+@[A-Za-z0-9]+[A-Za-z0-9\\.\\-]*[A-Za-z0-9]+\")","v":true},null,null,null,null,null,null,null,null,null,null,"galliver@gmail.com"]
[null,"sales@yahoo.com",{"$f":"matchP(B11,\"[\\w\\.\\-]+@[A-Za-z0-9]+[A-Za-z0-9\\.\\-]*[A-Za-z0-9]+\")","v":true},null,null,null,null,null,null,null,null,null,null,"sales@yahoo.com"]
[null,"frank@outlook.com",{"$f":"matchP(B12,\"[\\w\\.\\-]+@[A-Za-z0-9]+[A-Za-z0-9\\.\\-]*[A-Za-z0-9]+\")","v":true},null,null,null,null,null,null,null,null,null,null,"frank@outlook.com"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,""]
[]
[null,null,null,null,null,null,null,null,null,null,null,""]