Saturday, May 23, 2015

How to clear up all commas after deleting all the data in CSV in Excel software?



I have this raw item.CSV file:



Name,Price,date
"item1",10,2012-11-21
"item1",10,2012-11-21
"item1",10,2012-11-21



I open it in Excel, it looks correct:



enter image description here



Then I clear all the data except the headers, and saved it:



enter image description here



Then I see those commas are there.




enter image description here



I don't want those commas staying there. How can I clear the data in Excel so that the commas are gone as well in the CSV?


Answer



Instead of clearing the data, have you tried deleting it?



Highlight those same 3 rows, right click and choose delete. Then save it.


No comments:

Post a Comment

linux - How to SSH to ec2 instance in VPC private subnet via NAT server

I have created a VPC in aws with a public subnet and a private subnet. The private subnet does not have direct access to external network. S...