首页 > 解决方案 > 在 Javascript 中从 CSV 数据中删除引号

问题描述

我有这个 CSV 数据,我在使用 javascript 获取请求后从 JSON 转换。

datetime","open","high","low","close","volume"
"2020-01-28","312.48999","318.39999","312.19000","317.69000","31027981"
"2020-01-27","309.89999","311.76001","305.89001","308.95001","36450411"
"2020-01-24","320.06320","323.32001","317.53000","318.32999","33995457"
...

我需要在各处删除 " 引号以进一步处理数据。我尝试使用

csvdata.replace("\"", "")

有没有办法批量替换或者我需要遍历每一行?我希望数据看起来像:

datetime,open,high,low,close,volume
2020-01-28,312.48999,318.39999,312.19000,317.69000,31027981
2020-01-27,309.89999,311.76001,305.89001,308.95001,36450411
2020-01-24,320.06320,323.32001,317.53000,318.32999,33995457
...

谢谢你的帮助!

标签: javascriptcsvreplace

解决方案


您可以在替换中使用带有全局标志的正则表达式,因此:

let rgx = /"/g;
let removedQuotes = csvdata.replace(rgx, '');

推荐阅读