csv - 在 CSV 文件中的所有字段周围添加双引号

Question

我想在 CSV 文件的所有字段中添加引号。

我的 CSV 文件

$ cat file.csv
1,563,45645,example-text,/example/path,FILE,ftp://,11 

预期产出

$ cat file.csv
"1","563","45645","example-text","/example/path","FILE","ftp://","11"

标签： csvawksedtext-manipulation

Answer 1

试试 Perl

$ cat smc.txt
1,563,45645,example-text,/example/path,FILE,ftp://,11
$ perl -lpe ' s/([^,]+)/"$1"/g ' smc.txt
"1","563","45645","example-text","/example/path","FILE","ftp://","11"
$

或使用环视

$ perl -lne  ' s/^|(?<=,)|(?=,)|$/"/g  ; print ' smc.txt
"1","563","45645","example-text","/example/path","FILE","ftp://","11"
$