I have not had time to check the cable yet, I will get back to you once I have verified if it is still connected at both ends.
You were correct the cable had disconnected at the range sensor. The connector was broken. I was able to get the car into drive so that I could take it to the garage for replacement of the part.
Thanks for your help