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

I tried double quotes

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 is the field that will have ma within.

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

I tried double quotes

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 is the field that will have ma within.

• javascript
• csv
• escaping

Share Improve this question Follow edited Jun 10, 2022 at 13:43 Vadim Kotov 8,28488 gold badges5050 silver badges6363 bronze badges asked Mar 3, 2014 at 10:25 user1407668user1407668 61755 gold badges2121 silver badges3535 bronze badges 2

• Just quote delimit your columns in your CSV output. – user3358344 Commented Mar 3, 2014 at 10:26
• try this stackoverflow./questions/17836273/… – Aamir Afridi Commented Mar 3, 2014 at 10:28

Add a ment  | 

2 Answers 2

Sorted by: Reset to default 6

Close them in quotes and escape double quotes?

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

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

in your case:

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

should be

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

You can put your text between quotes.
You are not obliged to use a ma , you can use a ";" too (dutch/german format but works well)
--> http://en.wikipedia/wiki/Comma-separated_values
1997;Ford;E350;2,34