bash - 在 CSV 中使用 sed 添加具有值的列标题

Question

我将以下 2 列添加到我现有的 CSV 中。除了标题名称或列名称外，一切正常
我稍后将此 CSV 导入 MongoDB

当前 CSV:

"US_Business_Email_Data_01","AL"
"US_Business_Email_Data_01","AL"

所需的 CSV:

"FolderName","FileName"
"US_Business_Email_Data_01","AL"

Additional Information:

在 mongodb 当前文档中转换为 JSON 时:

 {
    "US_Business_Email_Data_01" : "US_Business_Email_Data_01",
    "AL" : "AL"
    }

在 mongodb 中转换为 JSON 时所需文档:

   {
    "FolderName" : "US_Business_Email_Data_01",
    "FileName" : "AL"
    }

我的 Bash 脚本:

我的 bash 脚本中的 sed 如下。

x=$zip_folder_name;y=$csv_name_updated; sed "s/$/,$x,$y/g" ${inner_file} > updated.csv
mv updated.csv ${inner_file}

请帮助提前谢谢!

Answer 1

它终于使用 awk 工作了，原来的答案是 https://stackoverflow.com/questions/46610794/how-to-add-new-column-with-header-to-csv-with-awk

ORIG_FILE=${inner_file}   
        NEW_FILE="updated.csv"
        awk -v d=$zip_folder_name -F"," 'BEGIN {OFS = ","} FNR==1{$(NF+1)="Folder Name"} FNR>1{$(NF+1)=d;} 1' $ORIG_FILE > $NEW_FILE
        mv ${NEW_FILE} ${ORIG_FILE}

        ORIG_FILE=${inner_file}   
        NEW_FILE="updated.csv"
        awk -v d=$csv_name_updated -F"," 'BEGIN {OFS = ","} FNR==1{$(NF+1)="File Name"} FNR>1{$(NF+1)=d;} 1' $ORIG_FILE > $NEW_FILE
        mv ${NEW_FILE} ${ORIG_FILE}