时间戳

首页 > 解决方案 > 如何删除行包含以下带有正则表达式模式的扩展？

windows - 如何删除行包含以下带有正则表达式模式的扩展？

问题描述

我想根据“脚本或预期文件”列删除行，该列包含“技术”一词或空或扩展名。仅当该列为空或包含以下扩展名时才会执行删除操作：.txt_go
.zip
.prd
.xml
.go
.csv .txt 或 .xlsx
或包含 _00* ???????? ？？？

这是 csv 文件：

Jobstream,"Jobstream Description","Op num","Job","Script or expected file(s)","Server","user","location","Job Description"

Jobstream,"Jobstream Description","Op num","Job","Script or expected file(s)","Server","user","location","Job Description"
\ACTO\data\out\PACTO500\f_ref12.prd,"WAIT TRGFIC-ACTO001","9","","\ACTO\data\out\PACTO500\f_ref12.prd","","","","START"
ACTOTRGAAA,"WAIT TRGFIC-ACTO001","10","PACTOAAA","technical","","","","ADDJOBSTREAM"
\prod\FACIMPORT\*.xml,"WAIT TRGFIC-ACTO001","9","","\prod\FACIMPORT\*.xml","","","","START"
ACTOTRGAAB,"WAIT TRGFIC-ACTO001","10","PACTOAAB","technical","","","","ADDJOBSTREAM"
\prod\TREATIESDECLARATIONIMPORT\*.xml,"WAIT TRGFIC-ACTO002","9","","\prod\TREATIESDECLARATIONIMPORT\*.xml","","","","START"
ACTOTRGAAC,"WAIT TRGFIC-ACTO002","10","PACTOAAD","technical","","","","ADDJOBSTREAM"
\prod\ACTO\data\in\PACTO003\*_desc.xml,"WAIT TRGFIC-ACTO560","9","","\prod\ACTO\data\in\PACTO003\*_desc.xml","","","","START"
ACTOTRGAAD,"WAIT TRGFIC-ACTO560","10","PACTOAAE","technical","","","","ADDJOBSTREAM"
ROD\ACTO\data\archives\f_ref12.prd.xml_????????_??????,"WAIT TRGFIC-ACTO999","9","","ROD\ACTO\data\archives\f_ref12.prd.xml_????????_??????","","","","START"
\REINSURANCE_DATA\client\01-Sources\*.xlsx,"WAIT TRGFIC-SHIN001","9","","\REINSURANCE_DATA\client\01-Sources\*.xlsx","","","","START"
SHINTRGAAA,"WAIT TRGFIC-SHIN001","10","PSHINAAB","technical","","","","ADDJOBSTREAM"
\prod\SHIN\data\in\PSHIN004\*.zip,"WAIT TRGFIC-SHIN003","9","","\prod\SHIN\data\in\PSHIN004\*.zip","","","","START"
\prod\AGPC\WEBX.001\flg\trt.go,"WAIT TRGFIC-WEBX001","9","","\prod\AGPC\WEBX.001\flg\trt.go","","","","START"
WEBXTRGAAA,"WAIT TRGFIC-WEBX001","10","PWEBXAAC","technical","","","","ADDJOBSTREAM"
\prod\AGPC\WEBX.002\in\PRTCP.csv,"Run Participations ACTOR","9","","\prod\AGPC\WEBX.002\in\PRTCP.csv","","","","START"
WEBXTRGAAB,"Run Participations ACTOR","10","PWEBXAAD","technical","","","","ADDJOBSTREAM"
\prod\AGPC\COPERNIC_LIL\WEBXL_COP\in\EC_AXACES.csv,"WAIT TRGFIC-WEBXWX2","9","","\prod\AGPC\COPERNIC_LIL\WEBXL_COP\in\EC_AXACES.csv","","","","START"
WEBXTRGAAC,"WAIT TRGFIC-WEBXWX2","10","PWEBXAAE","technical","","","","ADDJOBSTREAM"
\prod\WEBX\data\in\PWEBXWX1\LIL_AH_I100_WX101_00*,"WAIT TRGFIC-WEBX224","9","","\prod\WEBX\data\in\PWEBXWX1\LIL_AH_I100_WX101_00*","","","","START"
WRPT100Q,"REPORTXL","40","PWRPTTAG","technical","","","","Envoi mail utilisateurs"
WRPT-100Q-005T,"REPORTXL","45","PWRPT0B4","PWRPT-100Q-005T.BAT","PRAXCAPP02","AXA-CESSIONS\SVC_SCHEDULING","F+WRPT-007","Export (DataPump) AGPC"
WRPT-100Q-015T,"REPORTXL","55","PWRPT0B6","PWRPT-100Q-015T.KSH","PRATFUDMGTW01","svcudmu","F+WRPT-004","Transfert Fichiers DUMP"
WRPT-100Q-025T,"REPORTXL","75","PWRPT0CA","PWRPT-100Q-025T.BAT","PRAXCAPP02","AXA-CESSIONS\SVC_SCHEDULING","F+WRPT-007","Import (DataPump) AGPC"

标签： windowspowershellcsv

解决方案

用于Where-Object过滤您的数据：

# import data 
$data = Import-Csv .\path\to\file.csv

# define list of extensions to filter out
$excludedExtensions = -split @'
.txt_go
.zip
.prd
.xml
.go
.csv
.txt
.xlsx
'@

# filter data 
$data |Where-Object {
  foreach($extension in $excludedExtensions){
    if($_.'Script or expected file(s)' -like "*$extension"){
      # immediately return $false and filter out row if ANY extension matches
      return $false
    }
  }

  # finally check for *_00* and return $true if not found
  return $_.'Script or expected file(s)' -notlike '*_00*'
} |Export-Csv .\path\to\output.csv -NoTypeInformation

推荐阅读