{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["string","numbers only","Numbers 3rd","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":"string","index":0,"n_rows":15,"n_cols":7,"rows_kept":15,"cut":false,"hidden":false,"merged":[[1,1,1,2],[4,5,4,6]]}
[]
[null,"Replacing Strings That Match a Pattern"]
[]
[null,"Before Replacing","After Replacing"]
[null,"Thiago Silva, Phone:+880-1764-789045",{"$f":"Find_Replace_RegEx(B5,$B$13,$C$13,,FALSE)","v":"Thiago Silva, Phone:+880-1764-789045"},null,null,"Practice Here!"]
[null,"Ricardo Powel, Phone: 09-563-5210",{"$f":"Find_Replace_RegEx(B6,$B$13,$C$13,,FALSE)","v":"Ricardo Powel, Phone: XY-XYZ-WXYZ"}]
[null,"Bob, TIN: 12-123-4567",{"$f":"Find_Replace_RegEx(B7,$B$13,$C$13,,FALSE)","v":"Bob, TIN: XY-XYZ-WXYZ"},null,null,"Before Replacing","After Replacing"]
[null,"Scarlett Johnson, Credit Card: 123-06-7890",{"$f":"Find_Replace_RegEx(B8,$B$13,$C$13,,FALSE)","v":"Scarlett Johnson, Credit Card: 123-06-7890"},null,null,"Thiago Silva, Phone:+880-1764-789045"]
[null,"192.0. 2.146 is my IP address",{"$f":"Find_Replace_RegEx(B9,$B$13,$C$13,,FALSE)","v":"192.0. 2.146 is my IP address"},null,null,"Ricardo Powel, Phone: 09-563-5210"]
[null,"Harry Potter Book Part-II, ISBN: 97-804-3906-4866",{"$f":"Find_Replace_RegEx(B10,$B$13,$C$13,,FALSE)","v":"Harry Potter Book Part-II, ISBN: XY-XYZ-WXYZ-4866"},null,null,"Bob, TIN: 12-123-4567"]
[null,null,null,null,null,"Scarlett Johnson, Credit Card: 123-06-7890"]
[null,"Pattern","Replacement",null,null,"192.0. 2.146 is my IP address"]
[null,"\\d{2}-\\d{3}-\\d{4}","XY-XYZ-WXYZ",null,null,"Harry Potter Book Part-II, ISBN: 97-804-3906-4866"]
[]
[null,null,null,null,null,"Pattern","Replacement"]

{"sheet":"numbers only","index":1,"n_rows":14,"n_cols":8,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,2],[3,6,3,7]]}
[]
[null,"Replacing Numbers That Match a Pattern"]
[]
[null,"Before Replacing","After Replacing",null,null,null,"Practice Here!"]
[null,"Thiago Silva, Phone:+880-1764-789045",{"$f":"Find_Replace_RegEx(B5,$B$13,$C$13,,FALSE)","v":"Thiago Silva, Phone:+?-?-?"}]
[null,"Ricardo Powel, Phone: 09-563-5210",{"$f":"Find_Replace_RegEx(B6,$B$13,$C$13,,FALSE)","v":"Ricardo Powel, Phone: ?-?-?"},null,null,null,"Before Replacing","After Replacing"]
[null,"Bob, TIN: 12-123-4567",{"$f":"Find_Replace_RegEx(B7,$B$13,$C$13,,FALSE)","v":"Bob, TIN: ?-?-?"},null,null,null,"Thiago Silva, Phone:+880-1764-789045"]
[null,"Scarlett Johnson, Credit Card: 123-06-7890",{"$f":"Find_Replace_RegEx(B8,$B$13,$C$13,,FALSE)","v":"Scarlett Johnson, Credit Card: ?-?-?"},null,null,null,"Ricardo Powel, Phone: 09-563-5210"]
[null,"192.0.2.146 is my IP address",{"$f":"Find_Replace_RegEx(B9,$B$13,$C$13,,FALSE)","v":"?.?.?.? is my IP address"},null,null,null,"Bob, TIN: 12-123-4567"]
[null,"Harry Potter Book Part-II, ISBN: 97-804-3906-4866",{"$f":"Find_Replace_RegEx(B10,$B$13,$C$13,,FALSE)","v":"Harry Potter Book Part-II, ISBN: ?-?-?-?"},null,null,null,"Scarlett Johnson, Credit Card: 123-06-7890"]
[null,null,null,null,null,null,"192.0.2.146 is my IP address"]
[null,"Pattern","Replacement",null,null,null,"Harry Potter Book Part-II, ISBN: 97-804-3906-4866"]
[null,"\\d+","?"]
[null,null,null,null,null,null,"Pattern","Replacement"]

{"sheet":"Numbers 3rd","index":2,"n_rows":13,"n_cols":6,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,2],[2,4,2,5]]}
[]
[null,"Replacing 3rd Matching Numbers"]
[null,null,null,null,"Practice Here!"]
[null,"Before Replacing","After Replacing"]
[null,"Thiago Silva, Phone:+880-1764-789045",{"$f":"Find_Replace_RegEx(B5,$B$13,$C$13,3,FALSE)","v":"Thiago Silva, Phone:+880-1764-?"},null,"Before Replacing","After Replacing"]
[null,"Ricardo Powel, Phone: 09-563-5210",{"$f":"Find_Replace_RegEx(B6,$B$13,$C$13,3,FALSE)","v":"Ricardo Powel, Phone: 09-563-?"},null,"Thiago Silva, Phone:+880-1764-789045"]
[null,"Bob, TIN: 12-123-WYX",{"$f":"Find_Replace_RegEx(B7,$B$13,$C$13,3,FALSE)","v":"Bob, TIN: 12-123-WYX"},null,"Ricardo Powel, Phone: 09-563-5210"]
[null,"Scarlett Johnson, Credit Card: 123-06-7890",{"$f":"Find_Replace_RegEx(B8,$B$13,$C$13,3,FALSE)","v":"Scarlett Johnson, Credit Card: 123-06-?"},null,"Bob, TIN: 12-123-WYX"]
[null,"192.0.2.146 is my IP address",{"$f":"Find_Replace_RegEx(B9,$B$13,$C$13,3,FALSE)","v":"192.0.?.146 is my IP address"},null,"Scarlett Johnson, Credit Card: 123-06-7890"]
[null,"Harry Potter Book Part-II, ISBN: 97-804-3906-4866",{"$f":"Find_Replace_RegEx(B10,$B$13,$C$13,3,FALSE)","v":"Harry Potter Book Part-II, ISBN: 97-804-?-4866"},null,"192.0.2.146 is my IP address"]
[null,null,null,null,"Harry Potter Book Part-II, ISBN: 97-804-3906-4866"]
[null,"Pattern","Replacement"]
[null,"\\d+","?",null,"Pattern","Replacement"]

{"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-zA-Z]+).(.+)"]