Solved

Splitting text attributes into groups separated by blank lines.


Badge

Hi,

I have a multi-columns table with the first column contsing the Record Id and decription of the polygon. Each record can have one or more polygons in the description where each group is separated by blank lines as shown.

N1139-26

 

PositionCentroid : 49° 24.230'N 064° 33.127'W

Pt 1: 49° 41.000'N 065° 00.000'W

Pt 2: 49° 20.000'N 065° 00.000'W

Pt 3: 49° 11.001'N 064° 00.005'W

Pt 4: 49° 22.002'N 064° 00.005'W

 

Centroid : 49° 05.088'N 063° 29.568'W

Pt 1: 49° 22.000'N 064° 00.000'W

Pt 2: 49° 11.000'N 064° 00.000'W

Pt 3: 48° 48.002'N 063° 00.005'W

Pt 4: 49° 00.002'N 063° 00.005'W

I am able to extract the coordinates and plot the points. However I am unable to group the points to form proper polygons. Without grouping properly, they form zigzag lines.

The table consists of hundreds of similar records. Can anyone suggest how to plot these correctly.

Thanks.

icon

Best answer by ebygomm 8 June 2019, 21:07

View original

4 replies

Userlevel 1
Badge +21

You can look at the AttributeCreator and adjacent attribute handling to assign groupings to your lines by incrementing a group attribute if a feature is preceded by a blank line

 

Badge

You can look at the AttributeCreator and adjacent attribute handling to assign groupings to your lines by incrementing a group attribute if a feature is preceded by a blank line

 

Thanks @egomm for the quick response. That looks like the solution I am looking for. I will give it a try. Thanks again.

Badge

You can look at the AttributeCreator and adjacent attribute handling to assign groupings to your lines by incrementing a group attribute if a feature is preceded by a blank line

 

@geomm Thanks. It works.

Badge

Problem solved. @geomm

Reply