Hi Alistair
Try update column: YourColumn=Right$(YourColumn,Len(YourColumn)-5) Ofcourse YourColumn always have to start with "#### " for this to work. Else try this: YourColumn=Right$(YourColumn,Len(YourColumn)-InStr(1,YourColumn," ")) In this way the function deletes all the chars until and with the first space. Regards Thomas Brix Lyng Frederikshavn Munipal Administration Denmark -----Oprindelig meddelelse----- Fra: Alistair Hart [mailto:[EMAIL PROTECTED] Sendt: 11. april 2005 10:35 Til: MapInfo-L <[email protected] Emne: MI-L string expression Hi I have a column of data with a numeric code preceeding the locality name I'd like to join records with. I have searched the archives but haven't been able to find a reference to a mapbasic command that would update the column to remove the numeric data. ie: 2105 ALBANY CREEK and I want 'ALBANY CREEK' It should be easy as there is a space after the numberic data but the numeric data varies in characters from 1-4 long so i can't just trim the first five characters from the field values. I cannot attack from the right hand side because the number of words (and subsequently spaces) between the right side and the numbers varies. Is there a way to join records where tableX.locality string is within tableY.locality string? Or is there a bit of MB code I should use? I've even taken the desparate step of reading the MI Pro UserGuide, to no avail... I'm using V7.0 and 7.8. Cheers, Alistair. *************************************************** Alistair Hart GIS Project Officer Health Surveillance Tropical Public Health Unit Network PO Box 1103 Cairns QLD 4870 Ph: 0740 503 628 Fax: 0740 311 440 E: [EMAIL PROTECTED] "If our hopes of building a better and safer world are to become more than wishful thinking, we will need the engagement of volunteers more than ever." Kofi Annan, Secretary General, United Nations **************************************************************************** ******* This email, including any attachments sent with it, is confidential and for the sole use of the intended recipient(s). This confidentiality is not waived or lost, if you receive it and you are not the intended recipient(s), or if it is transmitted/received in error. Any unauthorised use, alteration, disclosure, distribution or review of this email is prohibited. It may be subject to a statutory duty of confidentiality if it relates to health service matters. If you are not the intended recipient(s), or if you have received this email in error, you are asked to immediately notify the sender by telephone or by return email. You should also delete this email and destroy any hard copies produced. **************************************************************************** ******* --------------------------------------------------------------------- List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Message number: 16049
