我有一个CSV文件，其中一个字段名为'Involved ST'。
该字段可以包含如下值:
:
Involved ST
V5 3rd
V4 3rd
V6 3rd
G140 2nd
G141 2nd
A2
A3
:
Involved ST
3rd
3rd
3rd
2nd
2nd
1st
1st
现在我必须替换在-> 3rd
中包含3rd的每个值(如'V5 3rd')包含2nd-> 2nd
的值
哪个工具可以做到这一点?谢谢你! !
如果您在Excel中打开CSV，您可以使用如下公式:
=IF(A2<>"", CHOOSE(IFERROR(MATCH(RIGHT(A2,3),{"3rd","2nd"},0),3),"3rd","2nd","1st"),"")
或
=IF(A2<>"", IF(ISERROR(MATCH(RIGHT(A2,3),{"3rd","2nd"},0)),"1st",RIGHT(A2,3)), "")
(假设您的值从A2开始)
尝试powershell -轻松读写csv和更改值