Skip to main content
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

 

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

Reply