[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

RE: [MI-L] Creating Labels using Space as a delimiter....

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: mapinfo-l@lists.directionsmag.com Subject: [MI-L] Creating Labels using Space

RE: [MI-L] Creating Labels using Space as a delimiter....

Of John Gosbell Sent: Monday, 16 January 2006 4:06 PM To: mapinfo-l@lists.directionsmag.com 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

RE: [MI-L] Creating Labels using Space as a delimiter....

2006 3:36 PM To: mapinfo-l@lists.directionsmag.com 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