Ford transit 2002 lwb med roof aerial cable

[Efcnaylor]

I’m just wondering does anyone know how to put a new aerial cable in a ford transit 2002 lwb?
I have recently purchased it for work, knowing the radio didn’t work (aerial was snapped off, thought that was the problem)
As I went to replace the aerial, I found there was no cable atttached to the base. Does anyone know where I can buy one and how I can fit it?
Thanks