I need everything that's behind the second-to-last comma and space of my string.
Example:
input:
Jan 23, 2023, October 23, 2022, 2 October 23, 2022, Jan 23, 2023
output: Jan 23, 2023, October 23, 2022, 2 October 23, 2022
I tried this but this gives me the contrary result and it doesn't handle the space.
([^,]+),[^,]+$
This seems to do the trick in the first capturing group:
(.*)(?=(, .*, ))
Explanation: first capture group captures everything up until the positive lookahead group (?=). Inside the positive lookahead I added the second to last rule you seeked, which is comma and space followed by anything and then another comma and space.
You can match using this regex:
(.*\b\d{4}),.*
and replace with '$1.
RegEx Breakup:
(.*\b\d{4}): Match any text until last 4 digits. Due to greedy nature of .* quantifier it will match longest possible string before matching last 4 digits,: Match a comma.*: Match everything till end