{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Sheet1","More Resources"],"not_rendered":{"charts":0,"images":1,"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":55,"n_cols":18,"rows_kept":55,"cut":false,"hidden":false,"merged":[]}
["Regular Expressions"]
[]
[]
["RegExExtract"]
[]
["Two Numeric Digits, a dash and a non-whitespace character",null,null,null,null,null,"s followed by any 3 letters",null,null,null,null,"s followed by 3 groups of any 2 characters",null,null,null,null,"sh followed by 1 or more word characters"]
["String","as .32-.81- 58 f .71-2",null,null,null,null,"String","She sells sea shells on the sea shore",null,null,null,"String","She sells sea shells on the sea shore",null,null,null,"String","She sells sea shells on the sea shore"]
["Pattern","(\\d\\d)-\\S",null,null,null,null,"Pattern","s([a-zA-Z]{3})",null,null,null,"Pattern","s(..)(..)(..)",null,null,null,"Pattern","(sh\\w*)"]
["1st match",{"$f":"RegExExtract(B7,B8,0)","v":"32"},null,null,null,null,"1st match",{"$f":"RegExExtract($H$7,$H$8,0)","v":"ell"},null,null,null,null,null,null,null,null,"1st match",{"$f":"RegExExtract($R$7,$R$8,0)","v":"She"}]
["2nd match",{"$f":"RegExExtract(B7,B8,1)","v":"71"},null,null,null,null,"2nd match",{"$f":"RegExExtract($H$7,$H$8,1)","v":"hel"},null,null,null,null,null,"SubMatch 1","SubMatch 2",null,"2nd match",{"$f":"RegExExtract($R$7,$R$8,1)","v":"shells"}]
[null,null,null,null,null,null,"3rd match",{"$f":"RegExExtract($H$7,$H$8,2)","v":"hor"},null,null,null,"1st match",{"$f":"RegExExtract($M$7,$M$8,0)","v":"he"},{"$f":"RegExExtract($M$7,$M$8,0,1)","v":" s"},{"$f":"RegExExtract($M$7,$M$8,0,2)","v":"el"},null,"3rd match",{"$f":"RegExExtract($R$7,$R$8,2)","v":"shore"}]
[null,null,null,null,null,null,null,null,null,null,null,"2nd match",{"$f":"RegExExtract($M$7,$M$8,1)","v":" s"},{"$f":"RegExExtract($M$7,$M$8,1,1)","v":"ea"},{"$f":"RegExExtract($M$7,$M$8,1,2)","v":" s"}]
[null,null,null,null,null,null,null,null,null,null,null,"3rd match",{"$f":"RegExExtract($M$7,$M$8,2)","v":" o"},{"$f":"RegExExtract($M$7,$M$8,2,1)","v":"n "},{"$f":"RegExExtract($M$7,$M$8,2,2)","v":"th"}]
[null,null,null,null,null,null,null,null,null,null,null,"4th match",{"$f":"RegExExtract($M$7,$M$8,3)","v":"ea"},{"$f":"RegExExtract($M$7,$M$8,3,1)","v":" s"},{"$f":"RegExExtract($M$7,$M$8,3,2)","v":"ho"}]
[]
[]
["RegExMatch"]
[]
["4 numbers,dash, 4 numbers, dash, 4numbers, dash, 4 numbers",null,null,null,null,null,"2 numbers at start of string, a space, 4 numbers, a space, 4 numbers",null,null,null,null,null,null,null,"Australian land line inc international dialling code"]
[null,"1111-2222-3333-4444",null,null,null,null,null,"01 1111 2222",null,null,null,null,null,null,null,"+61 7 1111 2222"]
["Pattern","[0-9]{4}-[0-9]{4}-[0-9]{4}-[0-9]{4}",null,null,null,null,"Pattern","^[0-9]{2} [0-9]{4} [0-9]{4}",null,null,null,null,null,null,"Pattern","(\\+61) ([1-9]) ([0-9]{4}) ([0-9]{4})"]
["Match",{"$f":"RegexMatch(B20,B21)","v":true},null,null,null,null,"Match",{"$f":"RegexMatch(H20,H21)","v":true},null,null,null,null,null,null,"Match",{"$f":"RegexMatch(P20,P21)","v":true}]
[]
[]
["V4 IP Address",null,null,null,null,null,"Secure web address"]
["Pattern","^[0-9]{1,3}.[0-9]{1,3}.[0-9]{1,3}.[0-9]{1,3}$",null,null,null,null,null,"http://www.microsoft.com/index.asp"]
["1.2.3.4",{"$f":"RegexMatch(A27,$B$26)","v":true},null,null,null,null,"Pattern","https://(.*)/"]
["11.0.0.4",{"$f":"RegexMatch(A28,$B$26)","v":true},null,null,null,null,"Match",{"$f":"RegexMatch(H26,H27)","v":false}]
["158.24.56.244",{"$f":"RegexMatch(A29,$B$26)","v":true}]
["0.0.0.0",{"$f":"RegexMatch(A30,$B$26)","v":true}]
["255.255.255.255",{"$f":"RegexMatch(A31,$B$26)","v":true}]
[]
[]
["RegExReplace"]
[]
["Replace first occurrence"]
["apple, pear, apple, banana, orange, grape, apple",null,null,null,null,{"$f":"regexreplace(A37,\"apple\",\"mango\")","v":"mango, pear, apple, banana, orange, grape, apple"}]
[]
["Replace all occurrences"]
["apple, pear, apple, banana, orange, grape, apple",null,null,null,null,{"$f":"regexreplace(A40,\"apple\",\"mango\",TRUE)","v":"mango, pear, mango, banana, orange, grape, mango"}]
[]
["Replace parts of string"]
["ABC-123-XYZ-45-A-6789",null,null,{"$f":"regexreplace(A43,\"\\d+\",\"000\",TRUE)","v":"ABC-000-XYZ-000-A-000"},null,"Replace numbers"]
["ABC-123-XYZ-45-A-6789",null,null,{"$f":"regexreplace(A44,\"-\\d+-*\",\"\",TRUE)","v":"ABCXYZA"},null,"Remove non-alpha"]
["ABC-123-XYZ-45-A-6789",null,null,{"$f":"regexreplace(A45,\"-*[a-zA-Z]*-+\",\"\",TRUE)","v":"123456789"},null,"Remove non-numeric"]
[]
[]
["Split a string"]
["Pattern","(.*[0-9]+)(.*)"]
["IV:INV-32278ABC Widgets PTY LTD",null,null,null,{"$f":"RegExExtract(A50,$B$49,0)","v":"IV:INV-32278"},{"$f":"RegExExtract(A50,$B$49,0,1)","v":"ABC Widgets PTY LTD"}]
["IV:INV-32379 ABC Widgets PTY LTD",null,null,null,{"$f":"RegExExtract(A51,$B$49,0)","v":"IV:INV-32379"},{"$f":"TRIM(RegExExtract(A51,$B$49,0,1))","v":"ABC Widgets PTY LTD"}]
["IV:INV-29385Giant Company plc",null,null,null,{"$f":"RegExExtract(A52,$B$49,0)","v":"IV:INV-29385"},{"$f":"RegExExtract(A52,$B$49,0,1)","v":"Giant Company plc"}]
["IV:5140Big Blue",null,null,null,{"$f":"RegExExtract(A53,$B$49,0)","v":"IV:5140"},{"$f":"RegExExtract(A53,$B$49,0,1)","v":"Big Blue"}]
["INV-35385  Giant Company plc",null,null,null,{"$f":"RegExExtract(A54,$B$49,0)","v":"INV-35385"},{"$f":"TRIM(RegExExtract(A54,$B$49,0,1))","v":"Giant Company plc"}]
[null,null,null,null,null,{"$f":"RegExExtract(A55,$B$49,0)","v":""}]

{"sheet":"More Resources","index":1,"n_rows":24,"n_cols":3,"rows_kept":24,"cut":false,"hidden":false,"merged":[]}
["More Resources"]
[]
[null,"Tutorials"]
[null,"Excel Functions","https://www.myonlinetraininghub.com/excel-functions"]
[null,"Charting Blog Posts","http://www.myonlinetraininghub.com/category/excel-charts"]
[null,"Excel Dashboard Blog Posts","http://www.myonlinetraininghub.com/category/excel-dashboard"]
[]
[null,"Webinars"]
[null,"Excel Dashboards & Power BI","http://www.myonlinetraininghub.com/excel-webinars"]
[]
[null,"Courses"]
[null,"Advanced Excel","https://www.myonlinetraininghub.com/excel-expert-upgrade"]
[null,"PivotTables","https://www.myonlinetraininghub.com/excel-pivottable-course"]
[null,"Power Query","https://www.myonlinetraininghub.com/excel-power-query-course"]
[null,"Power Pivot","https://www.myonlinetraininghub.com/power-pivot-course"]
[null,"Excel Dashboards","http://www.myonlinetraininghub.com/excel-dashboard-course"]
[null,"Power BI","http://www.myonlinetraininghub.com/power-bi-course"]
[null,"Excel for Decision Making Under Uncertainty","https://www.myonlinetraininghub.com/excel-for-decision-making-course"]
[null,"Excel for Finance Professionals","https://www.myonlinetraininghub.com/excel-for-finance-course"]
[null,"Excel Analysis ToolPak","https://www.myonlinetraininghub.com/excel-analysis-toolpak-course"]
[null,"Excel for Customer Service Professionals","https://www.myonlinetraininghub.com/excel-for-customer-service-professionals"]
[]
[null,"Support"]
[null,"Excel Forum","https://www.myonlinetraininghub.com/excel-forum"]