Hi Vinesh, Put that formula in your MapBasic Window:
Update Table_name Set Street_number_column = Left$(adress_column, (InStr(1,adress_column," ")-1)), Street_name_column= Right$(adress_column, Len(adress_column)-InStr(1,adress_column," ")) This will work fine ONLY if the first space character in your address acts as the separator between your street numbers and your street names. Hope this helps! Fran�ois Robitaille Conseiller en g�omatique SiGis 3981, boul. Saint-Laurent, suite 503 Montr�al, Qc, H2W 1Y5 W73� 34� 42,71�� N45� 31� 00,10�� T: 514.285.959 F: 514.844.2488 C: mailto:[EMAIL PROTECTED] -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Vinesh Govind Sent: 23 octobre, 2001 05:33 To: MapInfo Lists (E-mail) Subject: MI-L Separating Street Numbers from Street Names This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible. Dear Users I have a column in my MapInfo table that has a street number and a street name in one column. I would like to separate them into two separate columns i.e. one column for street number and another column for street name. I have tried various syntax methods but find myself clueless in finding a solution. The problem I have is that street numbers vary in my table: eg. 77 Gipsy Lane 144-146 Glenfield Road 77A Groby Road So if I did truncate my column I still end up with text included from the 'shorter' address fields. Any solutions or suggestions would be most welcome. Regards. Vinny Vinesh Govind Data Technician Leicestershire County Council Room 500 Area J5 * 0116 265 7257 _______________________________________________________________________ The contents of this message do not necessarily represent the opinions, views, policy or procedures of Leicestershire County Council. _______________________________________________________________________ List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, send e-mail to [EMAIL PROTECTED] and put "unsubscribe MapInfo-L" in the message body. _______________________________________________________________________ List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, send e-mail to [EMAIL PROTECTED] and put "unsubscribe MapInfo-L" in the message body.
