Have you tried: Left$([YOURFIELD],Instr(1,[YOURFIELD]," ")-1)
HTH David -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of John Gosbell Sent: Sunday, January 15, 2006 11:06 PM To: [email protected] Subject: [MI-L] Creating Labels using "Space" as a delimiter.... Howdy, I have a field containing formatted street address (eg "27a Smith St, Smithfield" ) and I want to create a label displaying just the house number (eg "27a"). I'm using MapInfo Pro Version 6.0. Have looked at all the label string functions as hoped to use the first space in the string as a delimiter, but no joy Does anyone have any bright ideas ? Cheers John Gosbell GIS Administrator City of Burnside P: 8366 4130 (direct) F: 8366 4299 E: [EMAIL PROTECTED] This Email is personal correspondence from the sender. It is not an official document from the City of Burnside. _______________________________________________ MapInfo-L mailing list [email protected] http://www.directionsmag.com/mailman/listinfo/mapinfo-l -- Checked by AVG Free Edition. Version: 7.1.371 / Virus Database: 267.14.18/230 - Release Date: 01/14/2006 -- Outgoing mail is certified Virus Free Checked by AVG Free Edition. Version: 7.1.371 / Virus Database: 267.14.18/230 - Release Date: 01/14/2006 _______________________________________________ MapInfo-L mailing list [email protected] http://www.directionsmag.com/mailman/listinfo/mapinfo-l
