Skip to main content
Solved

Attribute Trimmer Question

  • September 24, 2018
  • 1 reply
  • 20 views
B

I have a pressing deadline but I have no PERL skill and need this attribute trimmed - Lot/Plan(separators).

an example of an attribute:

1/AB842550

I am duplicating the column Lot/Plan(separators) into two columns - Lot and Plan

All characters to the left of this symbol "/" are the Lot numbers required in the Lot column

and

All the characters to the right of this symbol "/" are the Plan numbers required in the Plan column.

 

Any and all help would be greatly appreciated.

Thanks

 

peter

Best answer by hollyatsafe

HI @bananaspn,

You can use the AttributeSplitter with the delimiter as "/" which will generate a list with each component before and after the slash. Then use an AttributeCreator and set Lot as the first member of the list and Plan as the second part of the list:

Result:

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

H
Forum|alt.badge.img+2
  • hollyatsafe
  • 719 replies
  • Best Answer
  • September 24, 2018

HI @bananaspn,

You can use the AttributeSplitter with the delimiter as "/" which will generate a list with each component before and after the slash. Then use an AttributeCreator and set Lot as the first member of the list and Plan as the second part of the list:

Result:

Community Stats

32,084
Posts
121,839
Replies
39,722
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.