{"text_format":"1","workbook":"xlsx","n_sheets":14,"sheets":["Числа","Артикул","Индекс1","Индекс2","Автом.номер","ИНН","Город","Время","Деньги","Имя файла","Кириллица","Пароли","Телефон","Email"],"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":"Числа","index":0,"n_rows":7,"n_cols":5,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
["Hipro 500W (HIPO DIGI) HPP-500W (24+4+4pin) ATX PPFC 120mm fan 4xSATA",{"$f":"--RegExpExtract(A1,$E$2,2)","v":500},null,null,"Регулярное выражение"]
["Thermaltake 650W TR2 S 80+ (24+4+4pin) APFC 120mm fan 5xSATA RTL",{"$f":"--RegExpExtract(A2,$E$2,2)","v":2},null,null,"\\d+"]
["Chieftec 450W iARENA GPA-450S8 (80+ 230V only / 120mm Fan)",450]
["Chieftec 600W iARENA GPA-600S (230V only / 120mm Fan)",600]
["Chieftec 750W Force CPS-750S (Active PFC / 120mm Fan/ 85+)",750]
["Aerocool 750W ATX VX-750 (24+4+4pin) APFC 120mm fan 6xSATA RTL",750]
["Gigabyte ATX 500W GZ-EBS50N-C3 120mm fan, 3*SATA, power cord",50]

{"sheet":"Артикул","index":1,"n_rows":3,"n_cols":5,"rows_kept":3,"cut":false,"hidden":false,"merged":[]}
["Мухобойка Smash-2 реактивная BUM-100 красная, 100-00 руб.",{"$f":"RegExpExtract(A1,$E$2)","v":"BUM-100"},null,null,"Регулярное выражение"]
["Фонарик Spark-100 на солн.батареях LED-123 черн., 250-50 руб.",{"$f":"RegExpExtract(A2,$E$2)","v":"LED-123"},null,null,"[A-Z]{3}-\\d{3}"]
["Ледоруб-гвоздодер ICE-197, серебр., 1200-00 руб.","ICE-197"]

{"sheet":"Индекс1","index":2,"n_rows":3,"n_cols":5,"rows_kept":3,"cut":false,"hidden":false,"merged":[]}
["123456, г.Комсомольск-на-Амуре, Садовая ул., д.80",{"$f":"--RegExpExtract(A1,$E$2)","v":123456},null,null,"Регулярное выражение"]
["Орск, 342565, Гаражная ул., д.82, Пупкину В.В.",{"$f":"--RegExpExtract(A2,$E$2)","v":342565},null,null,"\\d{6}"]
["г.Орехово-Зуево, индекс 756907, Цветочная ул., д.35",756907]

{"sheet":"Индекс2","index":3,"n_rows":27,"n_cols":5,"rows_kept":27,"cut":false,"hidden":false,"merged":[]}
["123456, г.Комсомольск-на-Амуре, Садовая ул., д.80",{"$f":"--RegExpExtract(A1,$E$2)","v":123456},null,null,"Регулярное выражение"]
["Орск, 342565, Гаражная ул., д.82, Пупкину В.В.",{"$f":"--RegExpExtract(A2,$E$2)","v":342565},null,null,"\\b\\d{6}\\b"]
["тел. 89034567890, почт.индекс 356189, Сызрань, Шевченко ул., д.37",356189]
["Москва, ул. Строителей, 5, тел.89012345633, индекс 231900",231900]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null," "]

{"sheet":"Автом.номер","index":4,"n_rows":3,"n_cols":5,"rows_kept":3,"cut":false,"hidden":false,"merged":[]}
["БМВ X3 В123АУ777 черн. E83 2.0d",{"$f":"RegExpExtract(A1,$E$2)","v":"В123АУ777"},null,null,"Регулярное выражение"]
["Кабриолет Peugeot красный М789АР63 ",{"$f":"RegExpExtract(A2,$E$2)","v":"М789АР63"},null,null,"[АВЕКМНОРСТУХ]\\d{3}[АВЕКМНОРСТУХ]{2}\\d{2,3}"]
["Линкольн Навигатор В535ЕС50 немного битый","В535ЕС50"]

{"sheet":"ИНН","index":5,"n_rows":4,"n_cols":5,"rows_kept":4,"cut":false,"hidden":false,"merged":[]}
["Иванов И.И, ИНН3453452342",{"$f":"RegExpExtract(A1,$E$2)","v":"3453452342"},null,null,"Регулярное выражение"]
["АО \"Петрушка\", 988549348522 ИНН",{"$f":"RegExpExtract(A2,$E$2)","v":"988549348522"},null,null,"\\d{12}|\\d{10}"]
["ООО \"Бумбараш\", ИНН 523423423290",{"$f":"RegExpExtract(A3,$E$2)","v":"523423423290"}]
["Банк \"Базилио и Ко\" ИНН 8723",{"$f":"RegExpExtract(A4,$E$2)","v":{"$error":"#VALUE!"}}]

{"sheet":"Город","index":6,"n_rows":3,"n_cols":5,"rows_kept":3,"cut":false,"hidden":false,"merged":[]}
["123456, г.Комсомольск-на-Амуре, Садовая ул., д.80",{"$f":"RegExpExtract(A1,$E$2)","v":"г.Комсомольск-на-Амуре,"},null,null,"Регулярное выражение"]
["Московская обл., г. Зеленоград, ул. Гаражная, д.82",{"$f":"RegExpExtract(A2,$E$2)","v":"г. Зеленоград,"},null,null,"г\\..*?,"]
["г.Орехово-Зуево, 756907, Цветочная ул., д.35","г.Орехово-Зуево,"]

{"sheet":"Время","index":7,"n_rows":3,"n_cols":5,"rows_kept":3,"cut":false,"hidden":false,"merged":[]}
["Время запуска 12:45 по МСК",{"$f":"RegExpExtract(A1,$E$2)","v":"12:45"},null,null,"Регулярное выражение"]
["Отгрузка 3 марта в 23:30",{"$f":"RegExpExtract(A2,$E$2)","v":"23:30"},null,null,"([0-1]\\d|2[0-3]):[0-5]\\d"]
["05:00 - подъем","05:00"]

{"sheet":"Деньги","index":8,"n_rows":20,"n_cols":7,"rows_kept":20,"cut":false,"hidden":false,"merged":[]}
["Мухобойка реактивная BUM-100 красная, 100-00 руб. в т.ч. НДС 16-50 руб.",{"$f":"--SUBSTITUTE(RegExpExtract(A1,$E$2,2),\"-\",\",\")","v":16.5},null,null,"Регулярное выражение"]
["Фонарик на солн.батареях LED-123 черн., 250-50 руб., в т.ч. НДС 45-09 руб.",{"$f":"--SUBSTITUTE(RegExpExtract(A2,$E$2,2),\"-\",\",\")","v":45.09},null,null,"\\d+-\\d{2}"]
["Ледоруб-гвоздодер ICE-197, серебр., 1200-00 руб., в т.ч. НДС 216-00 руб.",216]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null," "]

{"sheet":"Имя файла","index":9,"n_rows":4,"n_cols":5,"rows_kept":4,"cut":false,"hidden":false,"merged":[]}
["C:\\Users\\pavlov.nikolay\\OneDrive\\Проекты\\regexp.xlsm",{"$f":"RegExpExtract(A1,$E$2)","v":"regexp.xlsm"},null,null,"Регулярное выражение"]
["C:\\Program Files\\WinRAR\\Descr.txt",{"$f":"RegExpExtract(A2,$E$2)","v":"Descr.txt"},null,null,"[^\\\\]+$"]
["E:\\Photo\\2015\\2015-05-12\\kotiki.jpg","kotiki.jpg"]
["D:\\Договоры\\Efes\\ДОГОВОР 123.docx","ДОГОВОР 123.docx"]

{"sheet":"Кириллица","index":10,"n_rows":9,"n_cols":5,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
["Оптич. мышь A4 Tech Bloody V8 USB игровая черная",{"$f":"RegExpExtract(A1,$E$2)","v":"Оптич. мышь "},null,null,"Регулярное выражение"]
["Вентилятор Zalman CNPS10X OPTIMA (Socket 754/775/939/940/1156/1366/AM2/AM3/FM1)",{"$f":"RegExpExtract(A2,$E$2)","v":"Вентилятор "},null,null,"[А-Яа-яёЁ\\s\\.]+[^A-Za-z]"]
["Процессор s.1151 Intel Core i5 7400 (3GHz/Intel HD Graphics 630) OEM","Процессор "]
["Модуль памяти DDR3 4Gb Kingston 1600MHz ","Модуль памяти "]
["Корпус чёрн. Super Power 3337 A11, 450W, ATX ","Корпус чёрн. "]
["Накопитель USB флеш 32GB Kingston DTSE9 металл","Накопитель "]
["Блок питания Accord 850W GOLD ACC-850W-80G 80+ gold (24+4+4pin)","Блок питания "]
["Монитор 23.6\" ViewSonic VA2465SM-3 черный VA LED 16:9 DVI ","Монитор 2"]
["Жесткий диск 2TB Toshiba SATA-III HDWD120UZSVA P300 (7200rpm) 64Mb 3.5\"","Жесткий диск 2"]

{"sheet":"Пароли","index":11,"n_rows":6,"n_cols":5,"rows_kept":6,"cut":false,"hidden":false,"merged":[]}
["wfp0c0AY",{"$f":"RegExpExtract(A1,$E$2)","v":"wfp0c0AY"},null,null,"Регулярное выражение"]
["Спартак123",{"$f":"RegExpExtract(A2,$E$2)","v":{"$error":"#VALUE!"}},null,null,"^[A-Za-z0-9]{6,}$"]
["Byw46",{"$error":"#VALUE!"}]
["pa$$w0rd",{"$error":"#VALUE!"}]
["kaban_W",{"$error":"#VALUE!"}]
["multipass111","multipass111"]

{"sheet":"Телефон","index":12,"n_rows":4,"n_cols":6,"rows_kept":4,"cut":false,"hidden":false,"merged":[]}
["Доктор Зло +7 903 123-45-56 (стоматолог)",{"$f":"SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(A1,\" \",\"\"),\"-\",\"\"),\"(\",\"\"),\")\",\"\")","v":"ДокторЗло+79031234556стоматолог"},{"$f":"RegExpExtract(B1,$F$2)","v":"79031234556"},null,null,"Регулярное выражение"]
["Арни 8 495 7775500 (тренер)",{"$f":"SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(A2,\" \",\"\"),\"-\",\"\"),\"(\",\"\"),\")\",\"\")","v":"Арни84957775500тренер"},{"$f":"RegExpExtract(B2,$F$2)","v":"84957775500"},null,null,"\\d{11}"]
["Сантехник Заливайко 8-963-125 9878 (моб)","СантехникЗаливайко89631259878моб","89631259878"]
["тел. 8  (800)  495-77-88 (бесплатный)","тел.88004957788бесплатный","88004957788"]

{"sheet":"Email","index":13,"n_rows":5,"n_cols":5,"rows_kept":5,"cut":false,"hidden":false,"merged":[]}
["vasya@mail.ru",{"$f":"RegExpExtract(A1,$E$2)","v":"vasya@mail.ru"},null,null,"Регулярное выражение"]
["miha.prokopenko1980@yandex.ru",{"$f":"RegExpExtract(A2,$E$2)","v":"miha.prokopenko1980@yandex.ru"},null,null,"[\\w\\-\\.]+\\@[\\w\\-]+\\.(ru|com)"]
["ravshan@kolhoz@.ru",{"$error":"#VALUE!"}]
["ivanov.kirill@gmail.com","ivanov.kirill@gmail.com"]
["david-sokolov@oreg-company.com","david-sokolov@oreg-company.com"]