使用 csv 的特定行和列值替换文本文件中的几个字符

从这个 csv ( input.csv)

no,a,b
region1,-0.01703,0.08515
region2,0.02297,0.08515

你可以把它转换成这个 TSV ( out.tsv)

region1a    -0.01703
region1b    0.08515
region2a    0.02297
region2b    0.08515

使用 Miller ( https://github.com/johnkerl/miller ) 并运行

mlr --c2t reshape -i a,b -o item,value then put '$field=$no.$item' then cut -o -f field,value ./input.csv | tail -n +2 >./out.tsv

您拥有的第二个文件是 ( input.txt)

p1 (region1a    region1b -0.1);
p2 (region1a    region1b 5);

p1 (region2a    region2b -0.1);
p2 (region2a    region2b 5);

然后你可以在 bash 脚本中简单地运行一个 for 循环

#!/bin/bash

set -x

cp ./input.txt ./output.txt
while IFS=$'\t' read -r region value; do
    sed -i -r 's/'"$region"'/'"$value"'/g' ./output.txt
done <./out.tsv

该output.txt会

p1 (-0.01703    0.08515 -0.1);
p2 (-0.01703    0.08515 5);

p1 (0.02297    0.08515 -0.1);
p2 (0.02297    0.08515 5);