Skip to main content
Solved

Attribute Trimmer Question

  • September 24, 2018
  • 1 reply
  • 10 views

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:

View original
Did this help you find an answer to your question?

1 reply

Forum|alt.badge.img+2
  • 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:


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings