Skip to main content
  • EN

So in my workspace I read in an Access mdb file in. Run it through two attributesplitters transformers to

split the BlockNO and LotNo fields

I the have an AttributeManager transformer setup where I try to clean up and conact the fields back together. I do this be creating 2 new attributes Block and Lot an using a condition statement to reassemble the pieces like this

However I can't format the if correctly, every case false and goes to the Else statement producing this type of output

The "." with no value after it is what I am trying to avoid.

 

Any help would be appreciated.

 

Chris M

I would test for Attribute has Value rather than attribute is null

 

So if attribute Blk_List{1} has value concatenate the items together, otherwise just use Blk_List{0}

Before you do the concatenation, you can use a StringReplacer on both Block and Lot to replace (regex) .$ by nothing.

The .$ will only remove a . at the end of the string.

This should go right before the AttributeSplitter transformers.

Hope this helps.

Reply


Community Stats

31,758
Posts
120,641
Replies
39,382
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.