Address parsing questions

Infosphere's Quality Product

Moderators: chulett, rschirm

Post Reply
abc123
Premium Member
Premium Member
Posts: 605
Joined: Fri Aug 25, 2006 8:24 am

Address parsing questions

Post by abc123 »

1)How do we use the CONVERT action to parse an address as:

123 Maple A 1
where:
123: HN1
Maple : SN1
A : (Typo! Should be converted to Ave and then ST1)
1: UV1

2)Where in the.PAT file do I add this code?

3)Is there any way to do this through the GUI, that is, the conversion from A to Ave?

Thanks to anyone who responds.
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

Through the GUI only via a rules override.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
abc123
Premium Member
Premium Member
Posts: 605
Joined: Fri Aug 25, 2006 8:24 am

Post by abc123 »

But how would you tell QS this:

"Interpret A as Ave in this situation"?
stuartjvnorton
Participant
Posts: 527
Joined: Thu Apr 19, 2007 1:25 am
Location: Melbourne

Post by stuartjvnorton »

abc123 wrote:But how would you tell QS this:

"Interpret A as Ave in this situation"?
Putting something like this in the PAT file would do specifically what you asked:

^ | + | I="A" | ^ | $
copy [1] {HN1}
copy [2] {SN1}
copy "AVE" {ST1}
copy [4] {UV1}
retype [1] 0
retype [2] 0
retype [3] 0
retype [4] 0

but this is very specific for the question you originally raised: I don't know how useful that would be.

Alternatively, you could retype the "A"

^ | + | I="A" | ^ | $
retype [3] T "AVE"

Again, specific to the situation, but all this does is change the "A" to "AVE" and retype it as a street type, so then the normal rules could process it.

Not sure if this is the best way to do it though.
More experienced people here might have a much easier or better way.

Cheers,
Stuart.
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

Is it really Avenue, or is it Apt (Apartment)? That it is followed by a 1 (which you're putting in UV1) suggests the latter. Perhaps this particular A (in this particular pattern) needs to go into UT1 in the xxADDR rule set)? You need to determine that before you can accurately address the conversion.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
stuartjvnorton
Participant
Posts: 527
Joined: Thu Apr 19, 2007 1:25 am
Location: Melbourne

Post by stuartjvnorton »

ray.wurlod wrote:Is it really Avenue, or is it Apt (Apartment)? That it is followed by a 1 (which you're putting in UV1) suggests the latter. Perhaps this particular A (in this particular pattern) needs to go into U ...
abc123, my stuff will do what you ask, but Ray's got a darn good point here...
Post Reply