I am trying to separate CSV text into columns using a formula in google sheets, but when I do it ends up separating strings with commas within quotes.
https://docs.google.com/spreadsheets/d/1bqG82qVNv8_VaSarVHFJ4dn78khf_2nNajRe9-ulXL4/edit?usp=sharing
For example when I use
=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"
Gets turned into:
| 119 | 6.65 | en | Ezuri | Renegade Leader | 6734497c-16f0-4c4b-ba24-337333511fc6 | 1 | rare | e9544132-bbb5-4ec4-af82-dad56e5091af | som | Scars of Mirrodin |
|---|
Any help would be much appreciated!
CodePudding user response：
=SPLIT(REGEXREPLACE(A1,"""?,""","