Skip to main content
Solved

topology builder

  • November 11, 2013
  • 1 reply
  • 14 views

I have a Mapinfo Tab file of Points that have an Attribute called 'Code'.

 

Data contained in this field is in the format of ABC# SL or ABC# EL.

 

 

What I need to do is create a line between Nodes whos attributes match e.g. ABC1 SL and ABC1 EL. 

 

SL stands for Start Line and the EL stands for End Line.

 

 

Thanks

 

 

Shane

 

Best answer by takashi

Hi Shane,

 

 

I would use the StringSearcher, Sorter and PointConnector with the following parameter settings.

 

 

StringSearcher: Split the Code into 2 parts.

 

Attribute: Code

 

Regular Expression: ^(.+)(SL|EL)$

 

Matched Parts Attribute: _parts

 

 

_parts{0} contains "ABC# ", _parts{1} contains "SL" or "EL".

 

 

Sorter: Sort the points by the Code (front part) and SL -> EL order.

 

Attribute  |  Alpha/Num  |  Order

 

_parts{0}  |  Alphabetic  |  Ascending

 

_parts{1}  |  Alphabetic  |  Descending

 

 

Point Connector: Connect points grouped by the Code (front part).

 

Connection Break Attributes: _parts{0}

 

 

Hope this helps. Takashi
This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.

1 reply

takashi
Celebrity
  • Best Answer
  • November 11, 2013
Hi Shane,

 

 

I would use the StringSearcher, Sorter and PointConnector with the following parameter settings.

 

 

StringSearcher: Split the Code into 2 parts.

 

Attribute: Code

 

Regular Expression: ^(.+)(SL|EL)$

 

Matched Parts Attribute: _parts

 

 

_parts{0} contains "ABC# ", _parts{1} contains "SL" or "EL".

 

 

Sorter: Sort the points by the Code (front part) and SL -> EL order.

 

Attribute  |  Alpha/Num  |  Order

 

_parts{0}  |  Alphabetic  |  Ascending

 

_parts{1}  |  Alphabetic  |  Descending

 

 

Point Connector: Connect points grouped by the Code (front part).

 

Connection Break Attributes: _parts{0}

 

 

Hope this helps. Takashi