Skip to main content
  • EN

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

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:

Reply


Community Stats

31,821
Posts
120,861
Replies
39,452
Members

Latest FME

Terms & ConditionsCookie settings
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.