David, I'm curious. If the low address range is 0, wouldn't that actual indicate that there only is a single address on this road ? And what if the low as well as the high address range is 0 ?
Peter Horsbøll Møller GIS Developer, MTM Geographical Information & IT COWI A/S Odensevej 95 DK-5260 Odense S. Denmark Tel +45 6311 4900 Direct +45 6311 4908 Mob +45 5156 1045 Fax +45 6311 4949 E-mail [EMAIL PROTECTED] http://www.cowi.dk/gis "For enden af regnbuen..." - hvordan kommer man dertil og er det overhovedet muligt? Læs mere om årets MapInfo konference på www.cowi.dk/mapinfokonference -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of David Reid Sent: Thursday, September 14, 2006 6:55 AM To: [EMAIL PROTECTED]; [email protected] Cc: 'Kenneth Hickey' Subject: RE: [MI-L] multline labels Ahhh, but what if the low address range has a "0" on one side or the other and you want to show the true low/high range? In other words, you actually desire "the minimum greater than zero" Thanks to Simon O'Keefe for help with this... left$(str$(minimum(FROMLEFT,FROMRIGHT)),99*int(FROMLEFT<>0 and FROMRIGHT<>0)) + left$(str$(maximum(FROMLEFT,FROMRIGHT)),99*int(FROMLEFT=0 or FROMRIGHT=0)) So, if: FROMLEFT = 1 TOLEFT = 99 FROMRIGHT = 0 TORIGHT = 100 The above syntax will give you (1 - 100) instead as opposed to (0-100) when using "minimum" alone. Of course, the best thing here if you're gonna label with low and high range very much (which I do on all my work as well). The best thing to do is add a "LOW" and "HIGH" field in your table then label from that. Then occasionally, use the above syntax to update your "LOW" column after doing much addressing maintenance (if you do much of that). Just my .2¢ worth :)) David Reid -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Trey Pattillo Sent: Wednesday, September 13, 2006 8:56 PM To: [email protected] Cc: Kenneth Hickey Subject: Re: [MI-L] multline labels here's one I use all the time be sure to set the "position" for center of the object under the field to use select expression and copy/paste the below and set the style to be "boxed" I like a light yellow background with red/blue/black letters minimum(fromleft,toleft) + "-" + maximum(fromleft,toleft) + chr$(10) + Street + chr$(10) + minimum(fromright,toright) + "-" + + maximum(fromright,toright) this produces a look the below where --- street--- is the line [- is line] 100 - 198 -----E MAIN ST ------- 101 - 199 another is minimum(fromleft,fromright) + " - " + Street + " - " + maximum(toleft,toright) which looks like with = being the the actual street line ========== 100 - E MAIN ST - 199 ============ On Wed 13 Sep 2006 19:15, Kenneth Hickey wrote: > Hey > > Can anyone tell me how to make labels with multiple lines each with > data from different fields? > > Thanks > Ken -- Trey Pattillo Failure is not an option.... It comes standard with all Microsoft products. _______________________________________________ MapInfo-L mailing list [email protected] http://www.directionsmag.com/mailman/listinfo/mapinfo-l -- No virus found in this incoming message. Checked by AVG Free Edition. Version: 7.1.405 / Virus Database: 268.12.3/446 - Release Date: 9/12/2006 _______________________________________________ MapInfo-L mailing list [email protected] http://www.directionsmag.com/mailman/listinfo/mapinfo-l _______________________________________________ MapInfo-L mailing list [email protected] http://www.directionsmag.com/mailman/listinfo/mapinfo-l
