Many many thanks, the string works beatifully. Streams, lakes, ponds any
attribute with "UNNAMED" for it's name is left blank leaving only valid
names for labelling.
Again, many thanks
Dave
----- Original Message -----
From: "Spencer Simpson" <[EMAIL PROTECTED]>
To: "Mapinfo Mailing List" <[EMAIL PROTECTED]>
Sent: Monday, September 11, 2000 2:08 PM
Subject: Re: MI Label expression ?
> Sorry to post this after David posted a summary, but I've managed
> to make label expressions that do that he wants; namely: "label if a
> condition is
> met, no label if not met".
>
> This technique relies on the fact that if you use the Int() function on a
> logical
> expression, it returns 1 for TRUE and 0 for FALSE.
>
> Given a condition expression, and a label-expression, you need to specify
>
> left$(label-expression,len(label-expression)*int(condition-expression))
>
> For complicated label expressions, the final expression can get extremely
> long, and a dedicated label column (as David indicated he would do in the
> summary) is a feasible alternative. You can use this technique to fill in
> that column, however.
>
> In David's example, since the label-expression is
>
> Name
>
> and the condition-expression is
>
> left$(Name,7)<>"UNNAMED"
>
> he would use
>
> left$(Name,len(Name)*int(left$(Name,7)<>"UNNAMED"))
>
>
> Hope this helps
> Spencer
>
>
>
>
> ----------------------------------------------------------------------
> To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put
> "unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED]
>
----------------------------------------------------------------------
To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put
"unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED]
