I am due to have a colonoscopy in a few weeks but am a little concerned about the preparation for this procedure. I have been given Moviprep to take prior to the appointment and would like to hear from anyone who has had this procedure using this product, is it as bad as it sounds