@Laura-Harrison ,
Don’t post essentially the same thing twice. The posting form reminds you that until you have enough upvotes, you have to wait for the posting queue for the post to show up.
If all of your badly-quoted dates have the quotes in exactly the same places (3 digits, quote, digit, hyphen, quote, digit, quote, digit, hyphen, quote, two digits), then you can use a similar idea to above, but put each into capture groups using the (...) notation: FIND = (\d{3})"(\d)-"(\d)"(\d)-"(\d{2}) . Each capture group gets numbered 1-5 for each set of parens, and is $1 - $5 in the REPLACE WITH field. So REPLACE WITH = "$1$2-$3$4-$5"
This will take
199"0-"0"8-"28
199"2-"1"1-"12
and make it
"1990-08-28"
"1992-11-12"
But I have a feeling you are going to tell me in the next post that what you really have is quotes in different places each time, like
1"99"0-"0"8-"28
199"2-"1"1-"12
"2"0"2"6"0"1"0"6"
In which case, I’d say, look for “possible quote, digit, possible quote, digit, possible quote, …etc”, where “possible quote” is in regex as "? (which means "0 or 1 quote mark)
FIND = "?(\d)"?(\d)"?(\d)"?(\d)"?-"?(\d)"?(\d)"?-"?(\d)"?(\d)"?
REPLACE = "$1$2$3$4-$5$6-$7$8"
REPLACE ALL
would give
"1990-08-28"
"1992-11-12"
"2026-01-06"
(Note that if you had more digits than that, like if you also had hh:mm:ss, so it would be up to 14, the replacements for 10-14 would be ${10} - ${14})