是否有一个函数来分割单元格，将忽略引号内的分隔符?

Question

我正在尝试使用谷歌表格中的公式将CSV文本分隔成列，但是当我这样做时，它最终会在引号内用逗号分隔字符串。

https://docs.google.com/spreadsheets/d/1bqG82qVNv8_VaSarVHFJ4dn78khf_2nNajRe9-ulXL4/edit?usp=sharing

例如当我使用

=split(A1,","): 

119,"6.65","","en","Ezuri, Renegade Leader","6734497c-16f0-4c4b-ba24-337333511fc6","1","rare","e9544132-bbb5-4ec4-af82-dad56e5091af","som","Scars of Mirrodin"

变成:

=SPLIT(REGEXREPLACE(A1,"""?,""","🤑"),"🤑")

步骤:

用🤑代替","和,":

"119🤑6.65🤑🤑en🤑Ezuri, Renegade Leader🤑6734497c-16f0-4c4b-ba24-337333511fc6🤑1🤑rare🤑e9544132-bbb5-4ec4-af82-dad56e5091af🤑som🤑Scars of Mirrodin"

并被🤑分割:

<表类>1196.65enEzuri，叛变领袖1raree9544132-bbb5-4ec4-af82-dad56e5091afsom镜中伤痕