I've been trying to pull apart a string into it's parts. I've sorted out some of it, but the last little bit is driving me crazy. Example
CTH KGB01 3.171 (07) (SH) (Scooby Doo)
I need to pull out the Scooby Doo part, and do it for thousands of different lines. The (SH) is not always there, so I can't just use Mid and search for the 3rd (. I need to find from the right, or trim, or something.
Thanks in advance for your expertise!
CTH KGB01 3.171 (07) (SH) (Scooby Doo)
I need to pull out the Scooby Doo part, and do it for thousands of different lines. The (SH) is not always there, so I can't just use Mid and search for the 3rd (. I need to find from the right, or trim, or something.
Thanks in advance for your expertise!
