次のファイルがありますA.txt（フィールド区切り記号= ,）。
Kit Batch Export
Software Version = NO_v1
Date And Time of Export =
Experiment Name = MY20195334_MOL_2014_20201006Run180017
Instrument Software Version =
Instrument Type = Cji
Instrument Serial Number =
Run Start Date =
Run End Date =
Run Operator =
Batch Status = VALID
Method = Nov
Date And Time of Export,Batch ID,Sample Name,Well,Sample Type,Status,Interpretive Result,Action*,Curve analysis,EC,CH
,MY20195334_MOL_2014_20201006Run180017,2061571293,A01,Unkn-01,VALID,,,
,MY20195334_MOL_2014_20201006Run180017,2061584371,A02,Unkn-09,VALID,,,
*See Kit IFU for reporting activities.
CE-IVD
For In Vitro Diagnostic Use.
次のように、_最初の列の後ろと3番目の列の前の内容だけを維持して2番目の列を解析したいと思います。_
Kit Batch Export
Software Version = NO_v1
Date And Time of Export =
Experiment Name = MY20195334_MOL_2014_20201006Run180017
Instrument Software Version =
Instrument Type = Cji
Instrument Serial Number =
Run Start Date =
Run End Date =
Run Operator =
Batch Status = VALID
Method = Nov
Date And Time of Export,Batch ID,Sample Name,Well,Sample Type,Status,Interpretive Result,Action*,Curve analysis,EC,CH
,MOL_2014,2061571293,A01,Unkn-01,VALID,,,
,MOL_2014,2061584371,A02,Unkn-09,VALID,,,
*See Kit IFU for reporting activities.
CE-IVD
For In Vitro Diagnostic Use.
これを行うには、次のようにします。
awk 'BEGIN{FS=OFS=","} NR==4{split($1,a,"_")} NR>13{$2=a[2]"_"a[3]} 1' A.txt > B.txt
うまくいきますが、次のようにファイルの終わりに印刷が続行されます。
Kit Batch Export
Software Version = NO_v1
Date And Time of Export =
Experiment Name = MY20195334_MOL_2014_20201006Run180017
Instrument Software Version =
Instrument Type = Cji
Instrument Serial Number =
Run Start Date =
Run End Date =
Run Operator =
Batch Status = VALID
Method = Nov
Date And Time of Export,Batch ID,Sample Name,Well,Sample Type,Status,Interpretive Result,Action*,Curve analysis,EC,CH
,MOL_2014,2061571293,A01,Unkn-01,VALID,,,
,MOL_2014,2061584371,A02,Unkn-09,VALID,,,
,MOL_2014
*See Kit IFU for reporting activities.,MOL_2014
CE-IVD,MOL_2014
For In Vitro Diagnostic Use.,MOL_2014
この問題を解決する方法を知っている人はいますか？ありがとう