{"text_format":"3","workbook":"xlsx","n_sheets":5,"sheets":["FIND+SUBSTITUTE","Case-sensitive","TEXTJOIN+SEQUENCE","FILTER+SEQUENCE","VBA Macros"],"read":"whole","date_system":"1900"}

{"sheet":"FIND+SUBSTITUTE","index":0,"n_rows":13,"n_cols":5,"rows_kept":13}
["ID","Text_String","Character","Nth_Occurrence","Position"]
["T001","abc-def-ghi-jkl","-",2,{"$f":"FIND(\"~\", SUBSTITUTE(B2, C2, \"~\", D2))","v":8}]
["T002","order-123-456-789","-",3,{"$f":"FIND(\"~\", SUBSTITUTE(B3, C3, \"~\", D3))","v":14}]
["T003","gloriajeans@example.com","@",1,12]
["T004","INV-2025-EXCEL-REPORT","-",3,15]
["T005","project_alpha_version_1.2.3","_",2,14]
["T006","file_path_c:users:documents:excel",":",3,28]
["T007","john_doe_dev_team","_",1,5]
["T008","account#number#section#45","#",3,23]
["T009","chapter.section.subsection",".",2,16]
["T010","AA-BB-CC-DD-EE","-",4,12]
["T011","price:discount:tax:total",":",2,15]
["T012","alpha|beta|gamma|delta","|",3,17]

{"sheet":"Case-sensitive","index":1,"n_rows":13,"n_cols":5,"rows_kept":13}
["ID","Text_String","Character","Nth_Occurrence","Position"]
["T001","abc-abc-abc-abc","B",2,{"$f":"IFERROR(FIND(CHAR(1), SUBSTITUTE(LOWER(B4), LOWER(C4), CHAR(1), D4)), \"Not found\")","v":6}]
["T002","order-123-456-789","-",3,{"$f":"IFERROR(FIND(CHAR(1), SUBSTITUTE(LOWER(B5), LOWER(C5), CHAR(1), D5)), \"Not found\")","v":13}]
["T003","gloriajeans@example.com","a",1,14]
["T004","INV-2025-EXCEL-REPORT","E",2,28]
["T005","project_alpha_version_1.2.3","_",2,8]
["T006","file_path_c:users:documents:excel",":",3,18]
["T007","john_doe_dev_team","e",1,17]
["T008","account#number#section#45","C",3,8]
["T009","chapter.section.subsection","S",2,15]
["T010","AA-BB-CC-DD-EE","c",2,17]
["T011","price:discount:tax:total",":",2,"Not found"]
["T012","alpha|beta|gamma|delta","|",3,"Not found"]

{"sheet":"TEXTJOIN+SEQUENCE","index":2,"n_rows":13,"n_cols":5,"rows_kept":13}
["ID","Text_String","Character","Nth_Occurrence","Position"]
["T001","abc-abc-abc-abc","-",2,{"$f":"LEN(_xlfn.TEXTJOIN(\"\",,INDEX(_xlfn.TEXTSPLIT(B2,C2),_xlfn.SEQUENCE(D2)))) + D2","v":8}]
["T002","order-123-456-789","-",3,{"$f":"LEN(_xlfn.TEXTJOIN(\"\",,INDEX(_xlfn.TEXTSPLIT(B3,C3),_xlfn.SEQUENCE(D3)))) + D3","v":14}]
["T003","gloriajeans@example.com","@",1,{"$f":"LEN(_xlfn.TEXTJOIN(\"\",,INDEX(_xlfn.TEXTSPLIT(B4,C4),_xlfn.SEQUENCE(D4)))) + D4","v":12}]
["T004","INV-2025-EXCEL-REPORT","-",3,{"$f":"LEN(_xlfn.TEXTJOIN(\"\",,INDEX(_xlfn.TEXTSPLIT(B5,C5),_xlfn.SEQUENCE(D5)))) + D5","v":15}]
["T005","project_alpha_version_1.2.3","_",2,{"$f":"LEN(_xlfn.TEXTJOIN(\"\",,INDEX(_xlfn.TEXTSPLIT(B6,C6),_xlfn.SEQUENCE(D6)))) + D6","v":14}]
["T006","file_path_c:users:documents:excel",":",3,{"$f":"LEN(_xlfn.TEXTJOIN(\"\",,INDEX(_xlfn.TEXTSPLIT(B7,C7),_xlfn.SEQUENCE(D7)))) + D7","v":28}]
["T007","john_doe_dev_team","_",1,{"$f":"LEN(_xlfn.TEXTJOIN(\"\",,INDEX(_xlfn.TEXTSPLIT(B8,C8),_xlfn.SEQUENCE(D8)))) + D8","v":5}]
["T008","account#number#section#45","#",3,{"$f":"LEN(_xlfn.TEXTJOIN(\"\",,INDEX(_xlfn.TEXTSPLIT(B9,C9),_xlfn.SEQUENCE(D9)))) + D9","v":23}]
["T009","chapter.section.subsection",".",2,{"$f":"LEN(_xlfn.TEXTJOIN(\"\",,INDEX(_xlfn.TEXTSPLIT(B10,C10),_xlfn.SEQUENCE(D10)))) + D10","v":16}]
["T010","AA-BB-CC-DD-EE","-",4,{"$f":"LEN(_xlfn.TEXTJOIN(\"\",,INDEX(_xlfn.TEXTSPLIT(B11,C11),_xlfn.SEQUENCE(D11)))) + D11","v":12}]
["T011","price:discount:tax:total",":",2,{"$f":"LEN(_xlfn.TEXTJOIN(\"\",,INDEX(_xlfn.TEXTSPLIT(B12,C12),_xlfn.SEQUENCE(D12)))) + D12","v":15}]
["T012","alpha|beta|gamma|delta","|",3,{"$f":"LEN(_xlfn.TEXTJOIN(\"\",,INDEX(_xlfn.TEXTSPLIT(B13,C13),_xlfn.SEQUENCE(D13)))) + D13","v":17}]

{"sheet":"FILTER+SEQUENCE","index":3,"n_rows":13,"n_cols":5,"rows_kept":13}
["ID","Text_String","Character","Nth_Occurrence","Position"]
["T001","abc-abc-abc-abc","-",2,{"$f":"INDEX(_xlfn._xlws.FILTER(_xlfn.SEQUENCE(LEN(B2)), MID(B2, _xlfn.SEQUENCE(LEN(B2)),1)=C2), D2)","v":8}]
["T002","order-123-456-789","-",3,{"$f":"INDEX(_xlfn._xlws.FILTER(_xlfn.SEQUENCE(LEN(B3)), MID(B3, _xlfn.SEQUENCE(LEN(B3)),1)=C3), D3)","v":14}]
["T003","gloriajeans@example.com","@",1,{"$f":"INDEX(_xlfn._xlws.FILTER(_xlfn.SEQUENCE(LEN(B4)), MID(B4, _xlfn.SEQUENCE(LEN(B4)),1)=C4), D4)","v":12}]
["T004","INV-2025-EXCEL-REPORT","-",3,{"$f":"INDEX(_xlfn._xlws.FILTER(_xlfn.SEQUENCE(LEN(B5)), MID(B5, _xlfn.SEQUENCE(LEN(B5)),1)=C5), D5)","v":15}]
["T005","project_alpha_version_1.2.3","_",2,{"$f":"INDEX(_xlfn._xlws.FILTER(_xlfn.SEQUENCE(LEN(B6)), MID(B6, _xlfn.SEQUENCE(LEN(B6)),1)=C6), D6)","v":14}]
["T006","file_path_c:users:documents:excel",":",3,{"$f":"INDEX(_xlfn._xlws.FILTER(_xlfn.SEQUENCE(LEN(B7)), MID(B7, _xlfn.SEQUENCE(LEN(B7)),1)=C7), D7)","v":28}]
["T007","john_doe_dev_team","_",1,{"$f":"INDEX(_xlfn._xlws.FILTER(_xlfn.SEQUENCE(LEN(B8)), MID(B8, _xlfn.SEQUENCE(LEN(B8)),1)=C8), D8)","v":5}]
["T008","account#number#section#45","#",3,{"$f":"INDEX(_xlfn._xlws.FILTER(_xlfn.SEQUENCE(LEN(B9)), MID(B9, _xlfn.SEQUENCE(LEN(B9)),1)=C9), D9)","v":23}]
["T009","chapter.section.subsection",".",2,{"$f":"INDEX(_xlfn._xlws.FILTER(_xlfn.SEQUENCE(LEN(B10)), MID(B10, _xlfn.SEQUENCE(LEN(B10)),1)=C10), D10)","v":16}]
["T010","AA-BB-CC-DD-EE","-",4,{"$f":"INDEX(_xlfn._xlws.FILTER(_xlfn.SEQUENCE(LEN(B11)), MID(B11, _xlfn.SEQUENCE(LEN(B11)),1)=C11), D11)","v":12}]
["T011","price:discount:tax:total",":",2,{"$f":"INDEX(_xlfn._xlws.FILTER(_xlfn.SEQUENCE(LEN(B12)), MID(B12, _xlfn.SEQUENCE(LEN(B12)),1)=C12), D12)","v":15}]
["T012","alpha|beta|gamma|delta","|",3,{"$f":"INDEX(_xlfn._xlws.FILTER(_xlfn.SEQUENCE(LEN(B13)), MID(B13, _xlfn.SEQUENCE(LEN(B13)),1)=C13), D13)","v":17}]

{"sheet":"VBA Macros","index":4,"n_rows":13,"n_cols":5,"rows_kept":13}
["ID","Text_String","Character","Nth_Occurrence","Position"]
["T001","abc-abc-abc-abc","-",2,{"$f":"FindNthOccur(B2, C2, D2)","v":8}]
["T002","order-123-456-789","-",3,{"$f":"FindNthOccur(B3, C3, D3)","v":14}]
["T003","gloriajeans@example.com","@",1,{"$f":"FindNthOccur(B4, C4, D4)","v":12}]
["T004","INV-2025-EXCEL-REPORT","-",3,{"$f":"FindNthOccur(B5, C5, D5)","v":15}]
["T005","project_alpha_version_1.2.3","_",2,{"$f":"FindNthOccur(B6, C6, D6)","v":14}]
["T006","file_path_c:users:documents:excel",":",3,{"$f":"FindNthOccur(B7, C7, D7)","v":28}]
["T007","john_doe_dev_team","_",1,{"$f":"FindNthOccur(B8, C8, D8)","v":5}]
["T008","account#number#section#45","#",3,{"$f":"FindNthOccur(B9, C9, D9)","v":23}]
["T009","chapter.section.subsection",".",2,{"$f":"FindNthOccur(B10, C10, D10)","v":16}]
["T010","AA-BB-CC-DD-EE","-",4,{"$f":"FindNthOccur(B11, C11, D11)","v":12}]
["T011","price:discount:tax:total",":",2,{"$f":"FindNthOccur(B12, C12, D12)","v":15}]
["T012","alpha|beta|gamma|delta","|",3,{"$f":"FindNthOccur(B13, C13, D13)","v":17}]