更新csv文件 [英] Updating csv files

问题描述

我需要将我的csv文件更新为特定格式，以便我的脚本可以运行。

I need to update my csv file to a particular format so my script can run.

我有CSV文件1看起来像

I have CSV file 1 which looks like

" PlazaID，LaneNumber"

"PlazaID,LaneNumber"

" 002200,2 ,,"

"002200,2,,"

我需要将其更改为CSV文件，该文件应如下所示

I need to change this to a CSV file which should look like this

" PlazaID"，" Lane Number"

"PlazaID","Lane Number"

" ; 002200"，" 2"

"002200","2"

请注意，PlazaID和LaneNumber应该是新CSV文件中的单独列。任何帮助将不胜感激！

Please note PlazaID and LaneNumber should be seperate columns in the new CSV file. Any help will be greatly appreciated!

推荐答案

是excel还是文本格式csv？

Is that excel or text format csv ?

这篇关于更新csv文件的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！