如何使用regex删除或过滤数据,以便在中间删除数据?起点是第一个日期(日期可以是动态的,不是固定的),例如08/03/2020,端点是capslock字符串中的最后3个(这也是动态的,但大写字母最多只有3个字符),例如下面的字符串中的TRU。之后,应该忽略或删除所有数据。
这是我目前的准则:
Regex.Match(text,"(?<=08/03/2020\s+)[\S\s]*?(?=TRU)").Value.Trim但它不是动态的。
这将被删除,因为这已经是在08/03/2020和TRU之后。
知道我们怎么能为这个设计一个正则表达式吗?谢谢。#要删除的数据
Processing
Co-Applicant
No inquiry records found."#字符串
"08/03/2020 NOVUS HOME Mortgage Company TRU
MORTGAGE
07/08/2020 FACTUAL DATA Mortgage Reporter XPN
07/08/2020 FCTUALDATA EFX
07/08/2020 NOVUS HOME Mortgage Company TRU
MORTGAGE
07/07/2020 CROSSCOUNTRY Mortgage Loan TRU
MORTGAG
07/07/2020 FACTUAL DATA Mortgage Reporter XPN
07/07/2020 FCTUALDATA EFX
05/21/2020 CAP ONE NA Bank Credit Card XPN
05/21/2020 CAPITAL ONE Credit Card TRU
05/21/2020 CAPITALONE Bank EFX
05/20/2020 CROSSCOUNTRY Mortgage Loan TRU
MORTGAG
05/20/2020 FACTUAL DATA Mortgage Reporter XPN
05/20/2020 FCTUALDATA EFX
05/20/2020 FINGERHUT/WEBBANK Finance Company XPN
05/07/2020 EMS EFX
05/07/2020 GROW FINANCIAL CREDI Credit Bureau/Mortgage TRU
Processing
Co-Applicant
No inquiry records found."预期产出
"08/03/2020 NOVUS HOME Mortgage Company TRU
MORTGAGE
07/08/2020 FACTUAL DATA Mortgage Reporter XPN
07/08/2020 FCTUALDATA EFX
07/08/2020 NOVUS HOME Mortgage Company TRU
MORTGAGE
07/07/2020 CROSSCOUNTRY Mortgage Loan TRU
MORTGAG
07/07/2020 FACTUAL DATA Mortgage Reporter XPN
07/07/2020 FCTUALDATA EFX
05/21/2020 CAP ONE NA Bank Credit Card XPN
05/21/2020 CAPITAL ONE Credit Card TRU
05/21/2020 CAPITALONE Bank EFX
05/20/2020 CROSSCOUNTRY Mortgage Loan TRU
MORTGAG
05/20/2020 FACTUAL DATA Mortgage Reporter XPN
05/20/2020 FCTUALDATA EFX
05/20/2020 FINGERHUT/WEBBANK Finance Company XPN
05/07/2020 EMS EFX
05/07/2020 GROW FINANCIAL CREDI Credit Bureau/Mortgage TRU发布于 2020-09-18 10:12:57
您可以使用
(?ms)\A(?:\d{2}/\d{2}/\d{2}(?:\d{2})?|−−DATE−−)\s.*\s\p{Lu}{3}$详细信息
(?ms) - RegexOptions.Multiline (^匹配行开始和$匹配行结束位置)和RegexOptions.Singleline (.现在也匹配换行符)\A -字符串的开始(?:\d{2}/\d{2}/\d{2}(?:\d{2})?|−−DATE−−) -两位数字,/,两位数字,/和两位或四位数字或−−DATE−−字符串。\s -一个空白.* -任何零或多个字符,尽可能多\s -一个空白[A-Z]{3} -三个大写ASCII字母(\p{Lu}{3}匹配来自任何语言的三个大写字母)$ -线的末端。https://stackoverflow.com/questions/63951979
复制相似问题