Z3 antenna broke where the thin wire goes into the base. Looking to replace with an aftermarket antenna. Any suggestions/instructions on how to do this with the original coaxial cable. Tried soldering the old antenna base, but it was futile.

Thanks in advance for any suggestions.