Replacing the entire bowden cable with a used unit is a decent option, but it is a PITA to install it at the transmission end, IIRC.
Another option is to repair your existing cable.
If you replace the nylon hollow bolt adjuster, you could regain the bowden cable function.
You can get one from the throttle kickdown bowden cable of a junker, or the old style cruise control units found on W116s and W123s.
You have to cut the bowden cable to install the replacement adjuster and then you need to re-join the cut cable ends with a
barrel clamp or attach a
threaded cable end to one end and attach a new
threaded quick release socket in place of the original socket.
You may also need to replace the ball on the bracket if the original ball doesn't fit the new socket.