How to properly split a string in python?

Question

Python

Good afternoon. What is the correct way to split such a string in Python into an array of data?

(726928131,'Данные','3-и Данные (111), данные','9',NULL,NULL,NULL,NULL,1,'Данные, Данные, Данные', 9,NULL,NULL,2545580,1)

At first I just tried to split by comma, but somewhere there is data in quotes, where there are also commas. Then I tried on the apostrophe, but somewhere it is not there. How then to be?

Answer 1

Do not use regular expressions where they are not needed. Your string is a normal CSV.

import csv

scsv = '''726928131,'Данные','3-и Данные (111), данные','9',NULL,NULL,NULL,NULL,1,'Данные, Данные, Данные', 9,NULL,NULL,2545580,1'''

row = next(csv.reader([scsv], delimiter=','))

print(row)