Morning Sarah, You could query the text without the space into a new column but by far the easiest way is to use the search and replace tool to search for a space and then replace with nothing...(I'd create a copy of the column to work on though, so that you have a column with spaces and one without.)
The tool is shipped with MapInfo but it's a MapBasic program called SRCHREPL.MBX, you can switch it on through Tools> Tool Manager, but you may have to launch it separately. If so select Tools> Run MapBasic Program> , then navigate to your Tools directory. If you can't find it I'd be happy to send it your way. Good luck. Dave David A. Eagle GIS Consultant ATKINS ENVIRONMENT Cornerstone House Stafford Park 13, Telford Shropshire, TF3 3AZ United Kingdom Tel: +44 (0)1952 213268 Fax: +44 (0)1952 200981 Email: [EMAIL PROTECTED] Web: www.atkinsglobal.com -----Original Message----- From: Hooper Sarah [mailto:[EMAIL PROTECTED] Sent: 20 May 2004 15:59 To: '[EMAIL PROTECTED]' Subject: MI-L Postcodes Hello, I have a table of postcodes (over 200,000), and for querying purposes I need to remove all spaces from the text, e.g. E1 0AA to look like E10AA. How do I do this?! Thanks in advance, Sarah **************************************************************************** ******* The contents of the e-mail and any transmitted files are confidential and intended solely for the use of the individual or entity to whom they are addressed. Transport for London hereby exclude any warranty and any liability as to the quality or accuracy of the contents of this email and any attached transmitted files. If you are not the intended recipient be advised that you have received this email in error and that any use, dissemination, forwarding, printing or copying of this email is strictly prohibited. If you have received this email in error please notify [EMAIL PROTECTED] This footnote also confirms that this email message has been swept for the presence of computer viruses. **************************************************************************** ******* --------------------------------------------------------------------- List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Message number: 11861 This email and any attached files are confidential and copyright protected. If you are not the addressee, any dissemination of this communication is strictly prohibited. Unless otherwise expressly agreed in writing, nothing stated in this communication shall be legally binding. --------------------------------------------------------------------- List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Message number: 11867
