Skip to main content
Best Answer

Splitting text attributes into groups separated by blank lines.

  • June 8, 2019
  • 4 replies
  • 34 views
L
Forum|alt.badge.img

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.

Best answer by ebygomm

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

 

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.

4 replies

ebygomm
Influencer
Forum|alt.badge.img+46
  • ebygommInfluencer
  • Influencer
  • Best Answer
  • June 8, 2019

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

 

L
Forum|alt.badge.img
  • lawrence
  • Author
  • June 8, 2019

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.

L
Forum|alt.badge.img
  • lawrence
  • Author
  • June 9, 2019

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.

L
Forum|alt.badge.img
  • lawrence
  • Author
  • June 9, 2019

Problem solved. @geomm

Community Stats

32,182
Posts
122,181
Replies
39,856
Members

Latest FME

Terms & ConditionsCookie settingsAccessibility statement
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.