我有一个csv
包含 51 个字段的文件,我需要使用它们导入quotation marks
每个space
新记录。我对此完全陌生,并且查看了 CHAR 34 连接。
这是最好的方法吗?我尝试了下面的一个小样本,但认为这对于 51 列来说不现实。有人可以指导我吗?
ID Date ID Number Conversion
1 2/12/17 ''1234'' "1","43071","1234"
2 3/12/17 ''5678'' "2","43072","5678"
3 4/12/17 ''4376'' "3","43073","4376"
4 5/12/17 ''9865'' "4","43074","9865"
5 6/12/17 ''1298'' "5","43075","1298"