Skip to main content
  • EN

I want to extract a UK postcode from a free-format address field, but only if there is one.

I am using the AttributeManager transformer with a new output attribute value:

 

@Substring(@Value(OriginalAddress),@FindRegEx(@Value(OriginalAddress),";A-Z]]A-Z]]0-9]]0-9] 0-9]]A-Z]]A-Z]"),8)

This works but I am getting unwanted results where a UK postcode is not found.

An important point is that OriginalAddress is a derived output attribute: @UpperCase(@Value(OccAddress1) @Value(OccAddress2) @Value(OccAddress3) @Value(OccAddress4) @Value(OccAddress5))I would like to say something on the lines of: If there's a postcode then get postcode else don't bother.Is this possible without resorting to using a python transformer? Trying to set a Conditional Value in AttrubuteManager does not work in this case as only the original input attributes are recognised in the Output Values builder of the Test Conditions (that is, it's only seeing the OccAddressN fields).

 

A string searcher can have an input created from several attributes, and would correctly handle cases where no match was found

Unfortunately, the regex for a UK postcode is a lot more complex than you might first think. Your current regex wouldn't pick up a lot of postcodes

Thanks @egomm.

I'm trying to reduce the number of transformers in my ever-growing workspace and am a big fan of the AttributeManager which keeps things tidy. Maybe not such a great idea but I'd like to know for sure.

Yes, thanks, I realise the regex is a bit lightweight but it does for codes in the data from my district that I'm processing.

I use the 1Spatial UKPostcodeValidator custom transformer for grown-up stuff. It's really good.

Thanks again.

Thanks @egomm.

I'm trying to reduce the number of transformers in my ever-growing workspace and am a big fan of the AttributeManager which keeps things tidy. Maybe not such a great idea but I'd like to know for sure.

Yes, thanks, I realise the regex is a bit lightweight but it does for codes in the data from my district that I'm processing.

I use the 1Spatial UKPostcodeValidator custom transformer for grown-up stuff. It's really good.

Thanks again.

Why not just reference the original attributes in your conditional formula if you want to keep everything in the attribute manager? Although it's not easy to decode it should work

 

 

 

 

Thanks @egomm.

I'm trying to reduce the number of transformers in my ever-growing workspace and am a big fan of the AttributeManager which keeps things tidy. Maybe not such a great idea but I'd like to know for sure.

Yes, thanks, I realise the regex is a bit lightweight but it does for codes in the data from my district that I'm processing.

I use the 1Spatial UKPostcodeValidator custom transformer for grown-up stuff. It's really good.

Thanks again.

That's a good idea @egomm. Not as elegant, but if it works I'm happy. I'll try it.

 

Reply


Community Stats

30,159
Posts
114,480
Replies
37,806
Members
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.