如何将包含逗号的值写入csv文件? [英] How to write a value that contains a comma to a csv file?

问题描述

我有一个JavaScript程序，可将值写入csv文件.我有一个包含逗号在内的值.这该怎么做?我是javascript的新手.你能帮我吗?

I have a javascript program to write values to a csv file. I have a value that includes comma within. How to do this? I am newbie to javascript. can you please help me?

我尝试了双引号

content += record.number +","+ record.category +","+ record.status +","+ record.approval_status +","+ record.requested_by +","+ record.assigned_to +","+record.assign_dept +","+ record.coordinator +","+ record.coord_phone +","+ record.planned_start +","+ record.planned_end +","+record.reason +","+ record.risk_assessment +","+ record.logical_name +","+ "record.assets" +","+ record.request_date +","+ record.subcategory +","+ record.priority_code +","+ record.impact +","+  record.sched_outage_start +","+ record.sched_outage_end  + "\n";

record.assets是将在其中包含逗号的字段.

record.assets is the field that will have comma within.

谢谢，Chithra

Thanks, Chithra

推荐答案

用引号将其关闭并转义双引号吗?

Close them in quotes and escape double quotes?

http://en.wikipedia.org/wiki/Comma-separated_values

1999年，雪佛兰，"Venture"扩展版""，4900.00

1999,Chevy,"Venture ""Extended Edition""",4900.00

在您的情况下:

"," + "record.assets" + ","

应该是

"," + '"' + record.assets.replace(/"/g,'""') + '"' + ","

这篇关于如何将包含逗号的值写入csv文件?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！