Excellent, A subset of points can be labelled based on their value in a column with the use of "Label Expressions"
Left$(Str$(FIELDNAME), Int(FIELDNAME Mod 25 = 0) * Len(Str$(FIELDNAME))) 'Picks Every point with Value divisible by 25 Left$(Str$(FIELDNAME), Int(FIELDNAME Mod 25 <> 0) * Len(Str$(FIELDNAME))) 'Picks Every point with a Value NOT divisible by 25 As Peter said, "Now you can just change the 25 to what ever value you need to label." Thank you to Peter and Stephen for your assistance. Cheers Paul -----Original Message----- From: Peter Horsbøll Møller [mailto:[EMAIL PROTECTED] Sent: Tuesday, 21 June 2005 3:49 PM To: Paul Smith; Stephen Chan Cc: mapinfo-l@lists.directionsmag.com Subject: RE: MI-L Label Expression Help Sure, Left$(Str$(FIELDNAME), Int(FIELDNAME Mod 25 = 0) * Len(Str$(FIELDNAME))) Now you can just change the 25 to what ever value you need to label. I tak eit that your column holds numbers/integer not characters 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 -----Original Message----- From: Paul Smith [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 21, 2005 7:37 AM To: 'Stephen Chan' Cc: mapinfo-l@lists.directionsmag.com Subject: RE: MI-L Label Expression Help Thanks Stephen, Mid$(str$(Fieldname),InStr(1,Right$(str$(Fieldname), 2),"00"),4) Works perfect. What about if I want to label every 25 records? 125,150,175,200 etc Any Ideas if this can be done with an expression. Paul -----Original Message----- From: Stephen Chan [mailto:[EMAIL PROTECTED] Sent: Tuesday, 21 June 2005 12:57 PM To: Paul Smith Cc: mapinfo-l@lists.directionsmag.com Subject: Re: MI-L Label Expression Help I meant mid$() not left$() sorry On 6/21/05, Stephen Chan <[EMAIL PROTECTED]> wrote: > Use the following label Expression: > Left$(str$(Fieldname),InStr(1,Right$(str$(Fieldname), 2),"00"),4) > > > On 6/21/05, Paul Smith <[EMAIL PROTECTED]> wrote: > > > > Sorry I ment "possible withOUT using a SQL Select statement." > > > > > > -----Original Message----- > > From: Paul Smith [mailto:[EMAIL PROTECTED] > > Sent: Tuesday, 21 June 2005 11:30 AM > > To: mapinfo-l@lists.directionsmag.com > > Subject: MI-L Label Expression Help > > > > > > Hi Everyone, > > > > I need help with a Label Expression to only show labels which are a > > multiple of 100. > > > > I have a table with numbers 1 to 1000 and currently have the > > following expression which gives me T and F labels correctly at 100, > > 200 etc. > > > > But how do i adapt this expression to show the original value ie. > > label with 100, 200 instead of T and F. > > > > Right$(str$(Fieldname), 2)="00" > > > > I am hoping that this is possible with using a SQL Select statement. > > > > Thanks > > > > Paul > > > > > > > > -------------------------------------------------------------------- > > - > > List hosting provided by Directions Magazine | www.directionsmag.com > > | To unsubscribe, e-mail: > > [EMAIL PROTECTED] > > For additional commands, e-mail: > > [EMAIL PROTECTED] > > Message number: 16837 > > > > > --------------------------------------------------------------------- List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Message number: 16842 --------------------------------------------------------------------- List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Message number: 16844 --------------------------------------------------------------------- List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Message number: 16846
