Timeline for If-then expression in Mapinfo label expressions
Current License: CC BY-SA 3.0
11 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Feb 25, 2016 at 9:04 | vote | accept | GeorgeC | ||
| Feb 25, 2016 at 8:49 | comment | added | T_Bacon | Ok, I think I understand the problem, I should have read through the original post again. Just to confirm that I'm right, you don't want ANY label on any records with an St_No_1 of 0? I've updated my answer to reflect that change, hopefully that's what you were after! | |
| Feb 25, 2016 at 8:48 | history | edited | T_Bacon | CC BY-SA 3.0 |
added 69 characters in body
|
| Feb 24, 2016 at 22:58 | comment | added | GeorgeC | Nope St_No_1 is an integer. | |
| Feb 24, 2016 at 15:55 | comment | added | T_Bacon | Is the field St_No_1 a character field? If so you will need to put double quotations around the 0, eg. Int(St_No_1<> "0") | |
| Feb 24, 2016 at 15:06 | comment | added | GeorgeC | I tried the following but it still prints the 0. It doesn't print in the lots with null though. {St_No_1+Left$(" ; "+LOTPLAN, Len(" ; "+LOTPLAN)*Int(Suf_No_1="R") * Int (St_No_1<>0))} | |
| Feb 24, 2016 at 15:02 | comment | added | T_Bacon | Yes, that should do it if it's a numerical field. If it's a character column then you will need to change it to test for both "0" and "". | |
| Feb 24, 2016 at 14:56 | comment | added | GeorgeC | Brilliant. One other complication that I found when I ran this. It should not put any label where the St_No is '0' or Null.. Can we add this condition. Would it be something like ...{ "R") * Int (St_No <> 0))... }? | |
| S Feb 24, 2016 at 14:34 | history | suggested | wittich | CC BY-SA 3.0 |
add code highlighting
|
| Feb 24, 2016 at 14:23 | review | Suggested edits | |||
| S Feb 24, 2016 at 14:34 | |||||
| Feb 24, 2016 at 14:06 | history | answered | T_Bacon | CC BY-SA 3.0 |