将逗号分隔的数据导入 Excel
1,1,"重击","用长尾巴或前腿等对敌人进行物理重击",0,40,0,100,35,0,0,0,115,0
2,2,"空手道斩", "用猛烈的斩击攻击敌人,暴击率很高。",43,50,1,100,25,0,0,0,115,0
3,3,"DoubleSlap","敌人被反复拍打,来回,连续两到五次。",29,15,0,85,10,0,0,0,115,0
我有一大组上述格式的数据。 我将其粘贴到 Excel 中,每一行占用 Excel 中的一个单元格。 我希望能够提取引号中文本的第二部分(描述)。 有什么办法可以使用 Excel 来做到这一点吗?
就像,而不是这样:
1,1,"Pound","敌人被长尾巴或前腿等物理重击",0,40,0,100,35,0,0,0,115,0 2,2,"空手道斩","用锋利的斩击攻击敌人。它具有很高的暴击率。",43,50,1,100,25,0,0,0,115,0
我想要这个
:用长尾巴或前腿等对敌人进行物理攻击。 敌人受到猛烈的砍击。 它具有很高的暴击率。
1,1,"Pound","The foe is physically pounded with a long tail or a foreleg, etc.",0,40,0,100,35,0,0,0,115,0
2,2,"Karate Chop","The foe is attacked with a sharp chop. It has a high critical-hit ratio.",43,50,1,100,25,0,0,0,115,0
3,3,"DoubleSlap","The foe is slapped repeatedly, back and forth, two to five times in a row.",29,15,0,85,10,0,0,0,115,0
I have a large set of data in the format above. I paste it into Excel and each row takes up a cell in Excel. I want to be able to extract just the second part of text (descriptions) in quotes. Is there any way to do this using Excel?
Like, instead of this:
1,1,"Pound","The foe is physically pounded with a long tail or a foreleg, etc.",0,40,0,100,35,0,0,0,115,0
2,2,"Karate Chop","The foe is attacked with a sharp chop. It has a high critical-hit ratio.",43,50,1,100,25,0,0,0,115,0
I want this:
The foe is physically pounded with a long tail or a foreleg, etc.
The foe is attacked with a sharp chop. It has a high critical-hit ratio.
如果你对这篇内容有疑问,欢迎到本站社区发帖提问 参与讨论,获取更多帮助,或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱,如果其他用户或者作者回复了您的评论,将不能在第一时间通知您!
发布评论
评论(1)
将其保存在扩展名为 .csv 的文本文件中,然后在 Excel 中打开。 这将为您提供在其自己的单元格中的每个逗号分隔的项目。
Save it in a text file with a .csv extension and open it in Excel. That will give you each comma separated item in its own cell.