Provide me with a set of valid strings and a set of invalid strings and I will write you a regular expression that matches only the valid strings. If you want a replacement operation done, I can provide the replacement string too. Alternatively, I can also review or fix an existing pattern.
I have years of expertise in writing regular expressions as it's a weird hobby of mine.
Regular Expression pattern
A regular expression pattern (and replacement value too, if needed) to match your data