I need help to convert a JSON to datatable, i've been trying to get specific data from columns using parse text, this is an example of what i get
{"accounts": [{"id": 1, "client_vat": "99999999-9", "login": "999999999", "account_number": "10101010", "password": "12345678", "bank_id": "020", "browser": "Chrome", "account_type": "personal"}, {"id": 2, "client_vat": "88888888-86", "login": "888888888", "account_number": "8888888888", "password": "88888888", "bank_id": "020", "browser": "Firefox", "account_type": "personal"}
I can get the logins since they're all 9 digits with \d{9} , but when i try to get the passwords for example, there are some with 8 digits, and there's also some account numbers with 8 digits, i only want to get the passwords but i don't know how to make the parse differentiate between password and account number