I have this set of data:
I only want to capture the EndDate that has a Submitted value of N or M.
The captured EndDate should be:
Yes, you can do this with a regex positive lookahead:
\d{4}-\d{2}-\d{2}(?=.+"Submitted":"[NM]")
More detail here: Regex lookahead, lookbehind and atomic groups