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 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 MapInfo-L@lists.directionsmag.com 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 MapInfo-L@lists.directionsmag.com http://www.directionsmag.com/mailman/listinfo/mapinfo-l
RE: [MI-L] Creating Labels using Space as a delimiter....
Try: Left$(MyColumn, InStr(1, MyColumn, )-1) In this instance, InStr() returns the position of the first space character. Subtract 1 from this to exclude the space itself in the label. Cheers, Peter -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf 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 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 MapInfo-L@lists.directionsmag.com http://www.directionsmag.com/mailman/listinfo/mapinfo-l ___ MapInfo-L mailing list MapInfo-L@lists.directionsmag.com http://www.directionsmag.com/mailman/listinfo/mapinfo-l
RE: [MI-L] Creating Labels using Space as a delimiter....
here ya go, this should werk... # Left$(YOURFIELD, InStr(1, YOURFIELD+ , )-1) # the YOURFIELD+ is in case your field value doesn't have a space in one of them so it won't return zero on the instr command, it'll give back 1 greater than the len of the string. btw, there's no smith st in smithfield, and only 5 suburbs have a 27 smith st in them. plus, stay away from smithfield, land of Fubu Maternity-wear, ick :) ash -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of John Gosbell Sent: Monday, 16 January 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 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 MapInfo-L@lists.directionsmag.com http://www.directionsmag.com/mailman/listinfo/mapinfo-l ___ MapInfo-L mailing list MapInfo-L@lists.directionsmag.com http://www.directionsmag.com/mailman/listinfo/mapinfo-l