Reputation
2,098
Top tag
Next privilege 2,500 Rep.
Create tag synonyms
Badges
1 19 52
Impact
~143k people reached

Feb
26
accepted SQL check if first value in line is number
Feb
26
comment SQL check if first value in line is number
yup, it got rid of everything.
Feb
26
asked SQL check if first value in line is number
Feb
25
comment Clustered labeling in Mapinfo
True, any ideas on how to remove duplicate numbering on the same street? Also not label if the address field does not start with a number.
Feb
25
comment Clustered labeling in Mapinfo
Another option is to work out a way to not label any duplicate street numbers on the same street and to only use the number after a "/" (and before the " ") when addressing. Addresses also should not start with a character and be based on the Address column rather than ST_No_Label
Feb
25
comment Clustered labeling in Mapinfo
@PeterHorsbøllMøller just thinking about this further. If there is a way to only label Lotplans that are 0BUP we can solve a lot of the issues and let Case 1 and 2 above just label as they currently are. Ideally using the code in my question as a base.
Feb
25
comment Clustered labeling in Mapinfo
Yes, I was hoping to avoid this but it looks like I will have to have a label column just for this project or the label queries get far to complex.
Feb
25
revised Clustered labeling in Mapinfo
updated base query
Feb
25
comment Clustered labeling in Mapinfo
Case 2 - my mistake, for blocks where we have 10LPxxxx and 11LPxxxx where xxxx is the same we do want both addresses to show as they are distinct blocks. So this should show 10/63-65 and 11/63-65
Feb
25
comment Clustered labeling in Mapinfo
Case 3 - Yes the first digit of the Lotplan is different as these are multistory buildings but we need to just consider the value after BUP (which is the same). For these we just need to show the street address once for the whole building and not each apartment. So if had 50 apartments we don't have 1/345, 2/345 etc but just 345.
Feb
25
accepted If-then expression in Mapinfo label expressions
Feb
25
asked Clustered labeling in Mapinfo
Feb
25
revised Insert sequential row and column values automatically into a fishnet dataset
added request for mapinfo mbx solution
Feb
24
comment If-then expression in Mapinfo label expressions
Nope St_No_1 is an integer.
Feb
24
accepted Search for string and only display characters before it in Mapinfo label expressions
Feb
24
comment Search for string and only display characters before it in Mapinfo label expressions
With {Left$(Address, InStr(1, Address, Chr$(9))-1)} nothing prints.
Feb
24
comment Search for string and only display characters before it in Mapinfo label expressions
No worries -but how do I get to print the first characters upto the first space?
Feb
24
revised If-then expression in Mapinfo label expressions
added example with current issue
Feb
24
comment If-then expression in Mapinfo label expressions
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
comment Search for string and only display characters before it in Mapinfo label expressions
So if the full address is "1/12 Davidson ST, PORT SMITH" it is printing "Port" but it should print 1/12. How do I tell if it is a tab? it's all in one address field as {1/12 Davidson ST, PORT SMITH}