我有一个类似于这样的CSV文件:
Amebiasis,California,2001,Total,571,34514777,1.654,1.521,1.796
Amebiasis,California,2001,Female,176,17340743,1.015,0.871,1.176
Amebiasis,California,2001,Male,365,17174034,2.125,1.913,2.355
我需要一个脚本,可以将所有文字块封装起来,使其看起来像这样:
"Amebiasis","California",2001,"Total",571,34514777,1.654,1.521,1.796
"Amebiasis","California",2001,"Female",176,17340743,1.015,0.871,1.176
"Amebiasis","California",2001,"Male",365,17174034,2.125,1.913,2.355
我习惯于使用PHP,但欢迎使用其他语言的解决方案。
我尝试使用Excel的本地解决方案,但那给了我三个引号:
"""Amebiasis""","""California""",2001,"""Total""",571,34514777,1.654,1.521,1.796