Data Base name and firstname ending #160

Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic

   I notice that a lot (most) of the customer fields  (name and firstname) end with an ascii 160. (535 out of 600) that I checked. I believe that ascii 160 is the extented character a with an accent on top of some sort. I could understand a few whose names with with the accented a but not 5 out of 6.
Does anyone know why this is there or how to remove them?
This may be a non-breaking space character and may have appeared after a move from 1 host provider to another.

Edited by JackQB - 21-June-2007 at 6:37am

Author	Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic
JackQB Members Profile Send Private Message Find Members Posts Add to Buddy List Newbie Joined: 20-June-2007 Location: United States Status: Offline Points: 0	Post Options Post Reply Quote JackQB Report Post Thanks(0) Quote Reply Topic: Data Base name and firstname ending #160 Posted: 20-June-2007 at 6:39pm
	I notice that a lot (most) of the customer fields (name and firstname) end with an ascii 160. (535 out of 600) that I checked. I believe that ascii 160 is the extented character a with an accent on top of some sort. I could understand a few whose names with with the accented a but not 5 out of 6. Does anyone know why this is there or how to remove them? This may be a non-breaking space character and may have appeared after a move from 1 host provider to another. Edited by JackQB - 21-June-2007 at 6:37am
	Jack www.AaaTeX.com QuickBooks Add-ons

ProductCart Members Profile Send Private Message Find Members Posts Add to Buddy List Admin Group ProductCart Team Joined: 01-October-2003 Status: Offline Points: 135	Post Options Post Reply Quote ProductCart Report Post Thanks(0) Quote Reply Posted: 24-June-2007 at 7:26pm
	Did you try exporting the customer list and then reimporting via the Customer Import Wizard? - Export name, last name, email - Review - Reimport to update the current records: ProductCart uses the email field to match existing customer records
	The ProductCart Team Home of ProductCart shopping cart software

JackQB Members Profile Send Private Message Find Members Posts Add to Buddy List Newbie Joined: 20-June-2007 Location: United States Status: Offline Points: 0	Post Options Post Reply Quote JackQB Report Post Thanks(0) Quote Reply Posted: 24-June-2007 at 7:32pm
	No, this was when using our QuickBooks Shopping Cart Integrator for a customer. I will mention that to the customer. We put in code to remove the chr(160) but why was it there?
	Jack www.AaaTeX.com QuickBooks Add-ons