Hello-
I have a column of data that can very in length and syntax but characters I want are buried in the middle. I'm looking to create an update query to make them uniform. Below are examples of how the data can vary.
#2690304(8665-176 #2687654(8638-P192 #510253(323-133)
I just need the 3 or 4 digit code after the "(", the hyphen and the 3 or 4 digits after the hyphen. Not including the ")" if it exists.
Thanks