regex - 只有满足条件，Regex 才能捕获某个字符串？

Question

我有这组数据：

• EndDate":"2024-10-24","Employee":"000A0001","Submitted":"N"
• EndDate":"2023-10-18","Employee":"000A0001","Submitted":"P"
• EndDate":"2021-01-02","Employee":"000A0001","Submitted":"J"
• EndDate":"2022-10-11","Employee":"000A0001","Submitted":"M"
• EndDate":"2020-09-18","Employee":"000A0001","Submitted":"N"

我只想捕获Submitted 值为N 或 M的EndDate。

捕获的 EndDate 应该是：

• 2024-10-24
• 2022-10-11
• 2020-09-18

标签： regexregex-lookaroundsregex-groupregex-negation

Answer 1

捕获日期并使用前瞻：

"EndDate":"([^"]+)"(?=.*"Submitted":"[NM]")

您的结束日期在比赛的第 1 组。

注意：我在正则表达式的开头添加了 '"' ，假设您不小心从看起来是 json 的示例中省略了它。