title: Remove trailing invisible character(s) from text via VBScript
body: <p>I am scraping some web data and inserting into Access 2007.
  Using a .vbs script to fetch and insert data.
  Things were fine, until a recent upgrade of the scrapping program.</p>
  
  <p>There is an extra space in each text record towards the end.
  Seems related to the encoding.</p>
  
  <p>Trim - function does not work on this.<br>
  Tried Replace A (Circumflex) , and xA0 , no result.</p>
  
  <p>Doing - Left(mystring,len(mystring)-1) right now.</p>
  
  <p>Since I would be scraping millions of records, what would be the simplest and correct way to solve this?</p>
  
  <p>Also, how to rectify this as the existing data in Access will now contain such 'contaminated' data? Use an UPDATE statement? How to check for last character as space?</p>