是否有分裂单元格在引号中忽略定界符的功能？

发布于 2025-02-13 16:25:26 字数 1015 浏览 2 评论 0原文

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

？

=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"

”

https://docs.google.com/spreadsheets/d/1bqg82qvnv8_vasarvhfj4dn78khf_2nnajre9-ulxl4/edit?usp=sharing	>				673497C-16F0-4C4B-BA24-3373333511FC6	1	稀有	E9544132-BB5-4EC4-AF82-DAD56E5091AF	SOM SOM	SOM SOM SOM SOM SOM SON MIRRODIN

任何帮助！

原文

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!

分享到QQ

分享到微博

如果你对这篇内容有疑问，欢迎到本站社区发帖提问参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。

发布评论

需要登录才能够评论，你可以免费注册一个本站的账号。

流年已逝 2025-02-20 16:25:26

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

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

Steps:

Replace "," and ," with ????:

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

and split by ????: