Как спарсить данные с текстовика

dmitrypribyl

Доброго времени суток имеются данные для авторизации mail|pass|cookies в формате json, через спарсить csv строку указал разделитель и парсится куки, но удаляются кавычки, как это можно испаравить, или может я, что то изначально не так сделал

gurkin4

@dmitrypribyl CSV вам не подойдёт, он автоматом режет кавычки. Используйте "Получить подстроку между" на каждый, в вашем случае хватит 2 раза.

Получить логин от пусто до |
Получить пароль от [[LOGIN]]| до |
вполне хватит "Заменить строку" и [[LOGIN]]|[[PASSWORD]]| заменить на пусто.

Пример:
Pars.xml

P/S: Помните, что всё должно быть одной строкой и куки BAS работают только в BAS.

Fox

@dmitrypribyl said in Как спарсить данные с текстовика:

Доброго времени суток имеются данные для авторизации mail|pass|cookies в формате json, через спарсить csv строку указал разделитель и парсится куки, но удаляются кавычки, как это можно испаравить, или может я, что то изначально не так сделал

Вам нужно сперва получить данные из json, а потом уже парсить csv. Если приведёте пример данных, вам помогут более предметно

dmitrypribyl

login1@email.com|Password1|[{"name": "PPDM","value": "\"my=https%3A%2F%2Fwww.site.com\"","domain": "secure.site.com","hostOnly": false,"path": "/","secure": false,"httpOnly": false,"sameSite": "no_restriction","session": false,"firstPartyDomain": "","partitionKey": null,"storeId": null},{"name": "__cf_bm","value": "Jgx1.e3Kq_EyYtiOjmEJ0AA2d507aYDuG.S1nQGI3PY-1699126339-0-AcfD35ZhPJU2NWYvMOPPf1eAYDYZjJHMhVy/8+kid9jm9dF/O58/pA2VznaEEhwhQ4ZfVp+9k0bYb3xGdOdfkdg=","domain": "site.com","hostOnly": false,"path": "/","secure": false,"httpOnly": false,"sameSite": "no_restriction","session": false,"firstPartyDomain": "","partitionKey": null,"storeId": null},{"name": "__cflb","value": "02DiuEkMqaZjXZ1bKvd1Fkz8END52DZLs7Kb2qR3J7yNc","domain": "secure.site.com","hostOnly": false,"path": "/","secure": false,"httpOnly": false,"sameSite": "no_restriction","session": false,"firstPartyDomain": "","partitionKey": null,"storeId": null},{"name": "_cfuvid","value": "5275eKMsFxJpntv5rnyMKE0sky12UHa.n1RT3tCpA98-1699126339464-0-604800000","domain": "site.com","hostOnly": false,"path": "/","secure": false,"httpOnly": false,"sameSite": "no_restriction","session": false,"firstPartyDomain": "","partitionKey": null,"storeId": null},{"name": "nonce","value": "9bsbayRPww2sZ4Gk","domain": "secure.site.com","hostOnly": false,"path": "/","secure": false,"httpOnly": false,"sameSite": "no_restriction","session": false,"firstPartyDomain": "","partitionKey": null,"storeId": null},{"name": "APPLE_N","value": "NR2IjRFhPh9cZBJm","domain": "secure.site.com","hostOnly": false,"path": "/","secure": false,"httpOnly": false,"sameSite": "no_restriction","session": false,"firstPartyDomain": "","partitionKey": null,"storeId": null},{"name": "PPID","value": "eyJraWQiOiIzN2FjZGI4MC04M2NkLTQ3YjItODAxOS1mMzE3ZjhiNjRiNmIiLCJ0eXAiOiJKV1QiLCJhbGciOiJFUzI1NiJ9.eyJzdWIiOiIxYmY0NjFiOWFiMWI1YWIwIiwibGFzdF9hdXRoX3RpbWUiOjE2OTkxMjYzNDI1NjQsImVtYWlsX3ZlcmlmaWVkIjp0cnVlLCJhdXRoIjoicHciLCJjcmVhdGVkIjoxMjkxMDQ4NTQ0MDAwLCJpc3MiOiJodHRwczpcL1wvc2VjdXJlLmluZGVlZC5jb20iLCJsYXN0X2F1dGhfbGV2ZWwiOiJXRUFLIiwibG9nX3RzIjoxNjk5MTI2MzQyNTY0LCJhdWQiOiJjMWFiOGYwNGYiLCJyZW1fbWUiOnRydWUsImV4cCI6MTY5OTEyODE0MiwiaWF0IjoxNjk5MTI2MzQyLCJlbWFpbCI6ImFuZHJlLmZvcmdlcnNlbkB5YWhvby5jb20ifQ.YapXb13zp1MVVBNndqNr3SQbkQ1E2iCk3BcdvvI0tRIkOPMWJEAALfLLd7mKRSiMMHqkznZHeKeAMxzZnOoyyQ","domain": "site.com","hostOnly": false,"path": "/","secure": false,"httpOnly": false,"sameSite": "no_restriction","session": false,"firstPartyDomain": "","partitionKey": null,"storeId": null},{"name": "SOCK","value": "\"y5xm_Uuv8cuYKzpmj1E46GWjpU4=\"","domain": "site.com","hostOnly": false,"path": "/","secure": false,"httpOnly": false,"sameSite": "no_restriction","session": false,"firstPartyDomain": "","partitionKey": null,"storeId": null},{"name": "SHOE","value": "\"2lfByGQtBkLk8ke0arrsfhNSb7Aldsv436tRW0pUaBuzDzsb8mNgYU5RI0iIUTdeTGUPhYcDKfw0xqKZDb_NrAHlQu--_hUaE862YyPdSRMP4WhI4DBwDeI-gOvgIpQeeaq9BmbQ_EmnnUuK\"","domain": "site.com","hostOnly": false,"path": "/","secure": false,"httpOnly": false,"sameSite": "no_restriction","session": false,"firstPartyDomain": "","partitionKey": null,"storeId": null},{"name": "rememberMe","value": "c0a1e229c8439dc2157afdb0d85d601f57ae79964c42c5ac34a2969544a7bae92f447aabc9ed385e8c712239f6f507d916893296bef0ddda1b75a6eec7c73e3979d2318660081bcdd043b12684c38813d4d05fab30b3ff2edeb877beb0e7b2c61254e946e27f975e1f5b539850187986b95ea7603e89f5a0","domain": "secure.site.com","hostOnly": false,"path": "/","secure": false,"httpOnly": false,"sameSite": "no_restriction","session": false,"firstPartyDomain": "","partitionKey": null,"storeId": null},{"name": "device","value": "fd097631dba4f43d5a5bcb805cb215b0","domain": "secure.site.com","hostOnly": false,"path": "/account/login","secure": false,"httpOnly": false,"sameSite": "no_restriction","session": false,"firstPartyDomain": "","partitionKey": null,"storeId": null},{"name": "JSESSIONID","value": "47319DBEED97263E8C9BCFBE9935A220","domain": "www.site.com","hostOnly": false,"path": "/","secure": false,"httpOnly": false,"sameSite": "no_restriction","session": false,"firstPartyDomain": "","partitionKey": null,"storeId": null},{"name": "site_CSRF_TOKEN","value": "YnWkE5LEcQomlocBQeVF11wPeYCl5bLP","domain": "www.site.com","hostOnly": false,"path": "/","secure": false,"httpOnly": false,"sameSite": "no_restriction","session": false,"firstPartyDomain": "","partitionKey": null,"storeId": null},{"name": "etfa","value": "\"AAAAAT5MrUt3aKiah0p9BmjHun1zJ8DRdzHFeqgDIKiguGqzc8+mUXXfhoRefil0vvNj5hkGIBKXB6hxHiVf4xmafMTPG632zLZaL995yM5buKNryzgAF4a/kP42ukvmd0QDqgkHoQkKFi3bKhgaS8XND1OC74UnwDZjDFx/bei/ye6gSYUVjT1vRYPP6nOGPcwguFuQUL1IMX6KZnihnW1tNFd7zfo9BF4vYmwugDggNw+aHPeaRGFxBPdItvTBcz163hX20OChDTSM8eQb4ZmDAi2y+YIqnnqrOz1GdYu5+WH+roNDI8adqMarPe+2Ky4HG4ASRhVVjTQUlrKsgw==\"","domain": "site.com","hostOnly": false,"path": "/account/login","secure": false,"httpOnly": false,"sameSite": "no_restriction","session": false,"firstPartyDomain": "","partitionKey": null,"storeId": null},{"name": "SURF","value": "KLElOcNHXIwU3LOddwn8n313N1LSE6af","domain": "site.com","hostOnly": false,"path": "/","secure": false,"httpOnly": false,"sameSite": "no_restriction","session": false,"firstPartyDomain": "","partitionKey": null,"storeId": null},{"name": "JSESSIONID","value": "node01uo479npf723h1u4jhwwrgl79e85474.node0","domain": "billing.site.com","hostOnly": false,"path": "/","secure": false,"httpOnly": false,"sameSite": "no_restriction","session": false,"firstPartyDomain": "","partitionKey": null,"storeId": null},{"name": "CSRF","value": "TRvE2FLARtOU6p2Z3I0par0dkjPqpfnw","domain": "site.com","hostOnly": false,"path": "/","secure": false,"httpOnly": false,"sameSite": "no_restriction","session": false,"firstPartyDomain": "","partitionKey": null,"storeId": null},{"name": "DRAWSTK","value": "75eb56b01fdc0aa7","domain": "employers.site.com","hostOnly": false,"path": "/","secure": false,"httpOnly": false,"sameSite": "no_restriction","session": false,"firstPartyDomain": "","partitionKey": null,"storeId": null},{"name": "site_rcc","value": "CTK","domain": "site.com","hostOnly": false,"path": "/","secure": false,"httpOnly": false,"sameSite": "no_restriction","session": false,"firstPartyDomain": "","partitionKey": null,"storeId": null},{"name": "CTK","value": "1hedt4ppvj3sg800","domain": "site.com","hostOnly": false,"path": "/","secure": false,"httpOnly": false,"sameSite": "no_restriction","session": false,"firstPartyDomain": "","partitionKey": null,"storeId": null},{"name": "ADOC","value": "6900352269333198","domain": "site.com","hostOnly": false,"path": "/","secure": false,"httpOnly": false,"sameSite": "no_restriction","session": false,"firstPartyDomain": "","partitionKey": null,"storeId": null}]
login2@email.com|Password2|[{"name": "PPDM","value": "\"my=https%3A%2F%2Fwww.site.com\"","domain": "secure.site.com","hostOnly": false,"path": "/","secure": false,"httpOnly": false,"sameSite": "no_restriction","session": false,"firstPartyDomain": "","partitionKey": null,"storeId": null},{"name": "__cf_bm","value": "dfdnA1ImdD0FCnxn9G9Ax5Kt1r4_qZdrzWMPtK1sFuE-1699193969-0-ASxbtkukSWjXFY9lf/IATtUDAC1MZ1ypDVbpxSt782T83fOg7h33WN7S8v8VhbCuAdcjNuUN4pWE/PybjeHQZI8=","domain": "site.com","hostOnly": false,"path": "/","secure": false,"httpOnly": false,"sameSite": "no_restriction","session": false,"firstPartyDomain": "","partitionKey": null,"storeId": null},{"name": "__cflb","value": "02DiuEkMqaZjXZ1bKvdow8TqvKM4vYT2by6MZEpbXyTUY","domain": "secure.site.com","hostOnly": false,"path": "/","secure": false,"httpOnly": false,"sameSite": "no_restriction","session": false,"firstPartyDomain": "","partitionKey": null,"storeId": null},{"name": "_cfuvid","value": "rKW_1iqa841NCjbGUcRKHmuqd33LLSM_lvd7g53Q0w8-1699193969893-0-604800000","domain": "site.com","hostOnly": false,"path": "/","secure": false,"httpOnly": false,"sameSite": "no_restriction","session": false,"firstPartyDomain": "","partitionKey": null,"storeId": null},{"name": "nonce","value": "05go749TIFw9asC3","domain": "secure.site.com","hostOnly": false,"path": "/","secure": false,"httpOnly": false,"sameSite": "no_restriction","session": false,"firstPartyDomain": "","partitionKey": null,"storeId": null},{"name": "APPLE_N","value": "SwQiPQWwMbfz6SBe","domain": "secure.site.com","hostOnly": false,"path": "/","secure": false,"httpOnly": false,"sameSite": "no_restriction","session": false,"firstPartyDomain": "","partitionKey": null,"storeId": null},{"name": "PPID","value": "eyJraWQiOiIzN2FjZGI4MC04M2NkLTQ3YjItODAxOS1mMzE3ZjhiNjRiNmIiLCJ0eXAiOiJKV1QiLCJhbGciOiJFUzI1NiJ9.eyJzdWIiOiJkZGI1YThiMjVlNGMzODQ4IiwibGFzdF9hdXRoX3RpbWUiOjE2OTkxOTM5NzMyNjgsImVtYWlsX3ZlcmlmaWVkIjp0cnVlLCJwaG9uZV9zY29wZSI6W10sImF1dGgiOiJwdyIsImNyZWF0ZWQiOjE0MjExMDkxMTkwMDAsImlzcyI6Imh0dHBzOlwvXC9zZWN1cmUuaW5kZWVkLmNvbSIsImxhc3RfYXV0aF9sZXZlbCI6IldFQUsiLCJsb2dfdHMiOjE2OTkxOTM5NzMyNjgsImF1ZCI6ImMxYWI4ZjA0ZiIsInJlbV9tZSI6dHJ1ZSwicGhvbmVfbnVtYmVyIjoiKzE5NzM2ODczODI4IiwiZXhwIjoxNjk5MTk1NzczLCJpYXQiOjE2OTkxOTM5NzMsImVtYWlsIjoiamF5Lm0ubWFydGlAZ21haWwuY29tIn0.i92XuFjdXaxsDqcYAdO9qOPv_Xm1XE7I0IKKTKczUE7VeZsoGsxvAtTOW6sjQ_9vYH4Z7mLJG65VtP9TQ4r5Qg","domain": "site.com","hostOnly": false,"path": "/","secure": false,"httpOnly": false,"sameSite": "no_restriction","session": false,"firstPartyDomain": "","partitionKey": null,"storeId": null},{"name": "SOCK","value": "\"9sROlrOD-exteI7Lk0s-Dnjw6Tw=\"","domain": "site.com","hostOnly": false,"path": "/","secure": false,"httpOnly": false,"sameSite": "no_restriction","session": false,"firstPartyDomain": "","partitionKey": null,"storeId": null},{"name": "SHOE","value": "\"OqVfEaYRmNnTjruhNVDrPpGN7E7JF50j1etlbzWbprgAsmaGJ8sYclAdjELoEtfY9-nlQ08gxlzdvFV4duw3Ukgd6_LNY4yKCqszJzqHHytgo5-ngxki2axCMXss3a4Lh6rskfqK1h06nkmGJR0=\"","domain": "site.com","hostOnly": false,"path": "/","secure": false,"httpOnly": false,"sameSite": "no_restriction","session": false,"firstPartyDomain": "","partitionKey": null,"storeId": null},{"name": "rememberMe","value": "c0a1e229c8439dc27d45d59a2a405d0a6e3a112cc6a918ddee48164decef7a069568e9b5918db998b83aa6f910132bb24f9737870c0426156389ebca8ec455554e34ecf2ea868d9ed9ca345df74b9a64764f1f3517da2e5c93da6c080d3045783b4488ac698349ba394e612ea50c87015a5bcb805cb215b0","domain": "secure.site.com","hostOnly": false,"path": "/","secure": false,"httpOnly": false,"sameSite": "no_restriction","session": false,"firstPartyDomain": "","partitionKey": null,"storeId": null},{"name": "device","value": "5faf460caddeae9e6990a97162493c10","domain": "secure.site.com","hostOnly": false,"path": "/account/login","secure": false,"httpOnly": false,"sameSite": "no_restriction","session": false,"firstPartyDomain": "","partitionKey": null,"storeId": null},{"name": "site_CSRF_TOKEN","value": "HW9YN3Qz3BjSX8J0Q5XlYrsP0cYpZ5Or","domain": "www.site.com","hostOnly": false,"path": "/","secure": false,"httpOnly": false,"sameSite": "no_restriction","session": false,"firstPartyDomain": "","partitionKey": null,"storeId": null},{"name": "JSESSIONID","value": "35856EA5C24AEEC8B0B51C3B389212F5","domain": "www.site.com","hostOnly": false,"path": "/","secure": false,"httpOnly": false,"sameSite": "no_restriction","session": false,"firstPartyDomain": "","partitionKey": null,"storeId": null},{"name": "etfa","value": "\"AAAAAc+445rOb20hfJbkOMqOubJ499n8pQcgSqbz7P001XHd/lGCn7S+0MdLUECA5ANkT5EdhhMH0EQ9TlpOMGR5+AsqFHj7BQ0TmE1KHJy1mEC64SWaQCQP+S+ciNR28uWmm958Ir0Km+c8+oaEjslTQmAXY10bLukgZirWd+kSZ7V4nGynG/2vpK8dl58mmltn5T9Xv6sOdY+7rIb9wOJiCmV7v+sSZ6WT8CspPRepZ3keO8yQi1REcoIM1PF4bKczOBQfC4ZVAqUTV3rMmHTpJ6rPexiP3kWL2ca54ieknQtCqlhJsywVGfTGbxgR253XUhct3QaXNxfy3C2ddPCoOdE=\"","domain": "site.com","hostOnly": false,"path": "/account/login","secure": false,"httpOnly": false,"sameSite": "no_restriction","session": false,"firstPartyDomain": "","partitionKey": null,"storeId": null},{"name": "SURF","value": "jSfqL8cXu1UTVevzlp8OBFm7PIo2o2yU","domain": "site.com","hostOnly": false,"path": "/","secure": false,"httpOnly": false,"sameSite": "no_restriction","session": false,"firstPartyDomain": "","partitionKey": null,"storeId": null},{"name": "JSESSIONID","value": "node0q7kbk4rbra7pck6uws58oono106961.node0","domain": "billing.site.com","hostOnly": false,"path": "/","secure": false,"httpOnly": false,"sameSite": "no_restriction","session": false,"firstPartyDomain": "","partitionKey": null,"storeId": null},{"name": "CSRF","value": "A8SExqOI5xhdsotFDN1NPBaDCMsPQpUe","domain": "site.com","hostOnly": false,"path": "/","secure": false,"httpOnly": false,"sameSite": "no_restriction","session": false,"firstPartyDomain": "","partitionKey": null,"storeId": null},{"name": "DRAWSTK","value": "cb9f91c25a5592ad","domain": "employers.site.com","hostOnly": false,"path": "/","secure": false,"httpOnly": false,"sameSite": "no_restriction","session": false,"firstPartyDomain": "","partitionKey": null,"storeId": null},{"name": "site_rcc","value": "CTK","domain": "site.com","hostOnly": false,"path": "/","secure": false,"httpOnly": false,"sameSite": "no_restriction","session": false,"firstPartyDomain": "","partitionKey": null,"storeId": null},{"name": "CTK","value": "1heftkn6j2aq5000","domain": "site.com","hostOnly": false,"path": "/","secure": false,"httpOnly": false,"sameSite": "no_restriction","session": false,"firstPartyDomain": "","partitionKey": null,"storeId": null},{"name": "ADOC","value": "1865828708649564","domain": "site.com","hostOnly": false,"path": "/","secure": false,"httpOnly": false,"sameSite": "no_restriction","session": false,"firstPartyDomain": "","partitionKey": null,"storeId": null}]

нужно получить из файла строку, и после работы скрипта удалить строку