Another address parsing question

Infosphere's Quality Product

Moderators: chulett, rschirm

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

Another address parsing question

Post by abc123 »

How would the following address be parsed?:

123 W 34 1/2 St

QualityStage parses it with the input pattern: ^D^^/^T

I am putting the following override: HN1PD1SN1SN1SN1ST1

I would appreciate any suggestions.
abc123
Premium Member
Premium Member
Posts: 605
Joined: Fri Aug 25, 2006 8:24 am

Post by abc123 »

Question 2: How would you add a street type to an address if it is missing? For example, if Qs sees the input pattern as:

^R^

Example address: 123 Maple 1

How would you add 'St' so that the address is?:
123 Maple St 1
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

Is "/" in your STRIPLIST ? If so you only have five pattern components to parse.

How do you know the correct street type is ST ?
Use a pattern override for ^R^
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 »

/ is not in my striplist but I can add it with an escape. However, 34 1/2 is the street address and that's how I want QS to see it in my override. So if I had the / in my strip list, would my override be:

HN1PD1SN1SN1ST1

I guess I am going to run this through, find the address and see how QS treats it.
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

That's why I had to ask the question about "/" in the STRIPLIST. It couldn't have parsed "1/2" as a single token. I think your first solution was better.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Post Reply