Thanks for the above responses.
I tried again to remove the sensor with the help of youtube videos. I was successful this time and was able to fit the new part myself. Fault message was removed automatically as suggested by the video and all is good. I did not have to get a diagnostic test. I understand Audi is aware of this common problem and have since modified the part. I hope this is of assistance to anyone having the same issue.