Most people end up replacing the whole antenna assembly, running the new cable all the way back through the firewall into the back of the head unit. Search taco whip mod and you will find dozens of examples. But if your mod works then it would be much less expensive and much less of hassle...
