{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Sample Data","FIND","UDF-Find","Patterns"],"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":"Sample Data","index":0,"n_rows":10,"n_cols":2,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Sample Dataset"]
[]
[null,"Original Text"]
[null,"mm@gmail.com is my email id."]
[null,"Contact us at: ee@exceldemy.com"]
[null,"Hi there."]
[null,"Contact Email: cr7@yahoo.com"]
[null,"My ID is Mahdy@exceldemy.com"]
[null,"My universty ID is: mm@name.bd"]

{"sheet":"FIND","index":1,"n_rows":15,"n_cols":7,"rows_kept":15,"cut":false,"hidden":false,"merged":[[1,1,1,3],[14,4,14,5],[15,4,15,5],[4,4,4,6],[11,1,11,2],[12,1,12,2]]}
[]
[null,"Finding Text with a Pattern and It's Location"]
[]
[null,"Original Text","Found Email ID","Position"]
[null,"mm@gmail.com is my email id.",{"$f":"Find_Pattern(B5,$B$13)","v":"mm@gmail.com"},{"$f":"IF(C5<>\"\",FIND(C5,B5),\"Not Found!\")","v":1},"Practice Here!"]
[null,"Contact us at: ee@exceldemy.com",{"$f":"Find_Pattern(B6,$B$13)","v":"ee@exceldemy.com"},{"$f":"IF(C6<>\"\",FIND(C6,B6),\"Not Found!\")","v":16}]
[null,"Hi there.",{"$f":"Find_Pattern(B7,$B$13)","v":""},"Not Found!"]
[null,"Contact Email: cr7@yahoo.com",{"$f":"Find_Pattern(B8,$B$13)","v":"cr7@yahoo.com"},16,"Original Text","Found Email ID","Position"]
[null,"My ID is Mahdy@exceldemy.com",{"$f":"Find_Pattern(B9,$B$13)","v":"Mahdy@exceldemy.com"},10,"mm@gmail.com is my email id."]
[null,"My universty ID is: mm@name.bd",{"$f":"Find_Pattern(B10,$B$13)","v":"mm@name.bd"},21,"Send problems at problem@exceldemy.com"]
[null,null,null,null,"Ronaldo's Email address is: cr7@yahoo.com"]
[null,"Email Pattern",null,null,"My ID is Mahdy@exceldemy.com"]
[null,"([a-zA-Z0-9_\\-\\.]+)@[a-z0-9-]+(\\.[a-z0-9-]+)*(\\.[a-z]{2,3})",null,null,"My universty ID is: mahdy@name.buet.ac.bd"]
[]
[null,null,null,null,"Email Pattern"]

{"sheet":"UDF-Find","index":2,"n_rows":12,"n_cols":6,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,2],[4,4,4,5]]}
[]
[null,"Locating a Pattern"]
[]
[null,"Original Text","Position of Email ID"]
[null,"mm@gmail.com is my email id.",{"$f":"IFERROR(Locate_Pattern(B5),\"Not Found!\")","v":1},null,"Practice Here!"]
[null,"Contact us at: ee@exceldemy.com",{"$f":"IFERROR(Locate_Pattern(B6),\"Not Found!\")","v":16}]
[null,"Hi there.",{"$f":"IFERROR(Locate_Pattern(B7),\"Not Found!\")","v":"Not Found!"},null,"Original Text","Position of Email ID"]
[null,"Contact Email: cr7@yahoo.com",{"$f":"IFERROR(Locate_Pattern(B8),\"Not Found!\")","v":16},null,"mm@gmail.com is my email id."]
[null,"My ID is Mahdy@exceldemy.com",{"$f":"IFERROR(Locate_Pattern(B9),\"Not Found!\")","v":10},null,"Send problems at problem@exceldemy.com"]
[null,"My universty ID is: mm@name.bd",{"$f":"IFERROR(Locate_Pattern(B10),\"Not Found!\")","v":21},null,"Ronaldo's Email address is: cr7@yahoo.com"]
[null,null,null,null,"My ID is Mahdy@exceldemy.com"]
[null,null,null,null,"My universty ID is: mahdy@name.buet.ac.bd"]

{"sheet":"Patterns","index":3,"n_rows":8,"n_cols":4,"rows_kept":8,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Important Patterns"]
[]
[null,"Type","Example","Pattern"]
[null,"Phone","(555) 555-1234",".?(\\\\d{3}).*(\\\\d{3}).*(\\\\d{4})"]
[null,"Date","2022-11-14","(\\\\d{2}).(\\\\d{2}).(\\\\d{4})"]
[null,"URL","https://www.exceldemy.com/","(https?)://(www)?.?(\\\\w+).(\\\\w+)/?(\\\\w+)?"]
[null,"Email","mahdymasum@gmail.com","([a-zA-Z0-9_\\-\\.]+)@[a-z0-9-]+(\\.[a-z0-9-]+)*(\\.[a-z]{2,3})"]