UK Address Standardization

kamesh_sk · Post by **kamesh_sk** » Wed Apr 07, 2010 8:24 am

HI,

I have an Address standardization Job for UK. The QS job involves an Address PREP and then an UK address and Area rule set.
The data iam having problem is this 'FLAT 5 193 SUTTON COURT ROAD CHISWICK LONDON W4 5RT'' The prep moves ''FLAT 5 193 SUTTON COURT ROAD CHISWICK' to the Address standardization and the rest of Data to Area Standardization.
Now i dont get the word CHISWICK from outside the address standardizer.
I checked the output from all the output fields including the Unhandled values but i nowhere see this word CHISWICK....so iam missing some of my address information which is really not good. can any one help me to understand why iam losing the information....Iam an starter with Quality stage , so my excuses if i have mentioned something wrong here or missed any fundamental

ray.wurlod · Post by **ray.wurlod** » Wed Apr 07, 2010 2:20 pm

CHISWICK belongs in UKAREA, not in UKADDR. Check how you have configured the UKPREP run.

kamesh_sk · Post by **kamesh_sk** » Fri Apr 09, 2010 2:20 am

ray.wurlod wrote:CHISWICK belongs in UKAREA, not in UKADDR. Check how you have configured the UKPREP run. ...

.

Gotcha , the prep pushes it to UKADDR , could not understand why , but a override at UKADDR pushes this T+ pattern to source field , rather than to output, and hence this area getting dropped.Now managed to capture all the information though....but still wondering why the prep is pushing this to ADDR

ray.wurlod · Post by **ray.wurlod** » Fri Apr 09, 2010 2:28 am

If it looks like a bug, and smells like a bug...

stuartjvnorton · Post by **stuartjvnorton** » Fri Apr 09, 2010 7:41 am

This may be a dumb question because I don't have GBPREP on hand , but is Chiswick in the CLS file?
Strangely enough, I have v7.5, but not v8. Go figure... It's not in the v7.5 CLS file. Hence my question.

ray.wurlod · Post by **ray.wurlod** » Fri Apr 09, 2010 6:03 pm

It's not there in version 8 either.

(I also note that CLWYD is but CLWYDD is not, so maybe there are other issues with this particular rule set.)

Since the GBAREA.PAT does not look up any tables, there does not appear to be any mechanism other than a classification override to handle CHISWICK. Or create a copy rule set.

ray.wurlod · Post by **ray.wurlod** » Fri Apr 09, 2010 6:04 pm

Maybe you need to check that CHISWICK really exists, and isn't just a figment of Douglas Adams's imagination?

JoshGeorge · Post by **JoshGeorge** » Sat Apr 10, 2010 1:51 am

Override classification with Legend "R" for CHISWICK.

kamesh_sk · Post by **kamesh_sk** » Tue Apr 13, 2010 3:13 am

Chiswick is definitely an Proper Location in London

chulett · Post by **chulett** » Tue Apr 13, 2010 6:49 am

ps. Ray was joking... and perhaps meant Robert Rankin rather than DA.

stuartjvnorton · Post by **stuartjvnorton** » Tue Apr 13, 2010 5:13 pm

JoshGeorge wrote:Override classification with Legend "R" for CHISWICK.

I would have thought you'd classify it as S.

A, N and R are what you end up with after you've determined the context and calling it an R up front may well cause it to not parse properly. There are several points in the processing while it's still trying to work out context where finding an A, N or R would stop processing on the field. Because an A, N or R tell it that it's already been processed.

Then you get this: 123 Chiswick St London
Giving Chiswick an R up front would cause some pretty fundamental problems with this, even if it did try to parse it.