Use the expression: Left$(field, Instr(1,field," ")) to get the number.
And the expression: Right$(field,len(field)-Instr(1,field," ")) to get the rest of the string. R > >I would like to extract part of the text from a field starting from the left >and ending at the first space in the column. >The field is a column that contains street number and street name. I want to >create two separate columns, one with the street number and another column >with the street name. Any ideas on how I can go about doing the syntax for >this? > >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. > > Robert Crossley Robert Crossley and Associates 10 Trinity Street CAIRNS QLD Australia 4870 P: 61-7-40314877 F: 61-7-40314810 M:0419718642 GPS: 145.768878 -16.928586 _______________________________________________________________________ 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.
