domain prep rules.
domain prep rules.
I have the canadian Vendors and US vendors and other international vendors Using integrity applying any pre built procedure(domain prep rules) can i do address scrubbing on the file which contains all the 3 vendors from canada,us,other. or do i need to do the address scrubbing seperately for each vendor.... i presume i have to do it seperately...if there is any way....
-
- Participant
- Posts: 3593
- Joined: Thu Jan 23, 2003 5:25 pm
- Location: Australia, Melbourne
- Contact:
I'm only guessing here because I haven't had experience with a wide range of international addresses however the handling of locality, postcode/zipcode and country should be the same for all addresses. You could have a single set of code that handles these fields across countries.
When it comes to street it gets more complex. Different countries might have different standards for the handling of street types and abbreviations for units, floors etc.
When it comes to street it gets more complex. Different countries might have different standards for the handling of street types and abbreviations for units, floors etc.
Last edited by vmcburney on Tue Dec 02, 2003 7:24 pm, edited 1 time in total.
Certus Solutions
Blog: Tooling Around in the InfoSphere
Twitter: @vmcburney
LinkedIn:Vincent McBurney LinkedIn
Blog: Tooling Around in the InfoSphere
Twitter: @vmcburney
LinkedIn:Vincent McBurney LinkedIn
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
There is a built-in procedure called MNS (multi-national address standardization). There is also a COUNTRY rule set, that can be applied ahead of anything else to separate your data into country based on the contents of address and area fields, then individual per-country domain preprocessors can be applied to bucket the actual name, address and area items. Rules for a limited set of countries ship with INTEGRITY and I'm afraid India is not one of them. But MNS will certainly still do the separation - it handles approximately 200 countries.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
parsing
Thanks,
But my address info and area information spreads between multiple fields
and i have to first parse them into name, addr, area but when i try to parse based on area using usprep domain prep rule
I can parse name, addr fields but when coming to area.. i have city, state,country,zip,pobox... how can i use the delimeters to do the parsing for these fields
But my address info and area information spreads between multiple fields
and i have to first parse them into name, addr, area but when i try to parse based on area using usprep domain prep rule
I can parse name, addr fields but when coming to area.. i have city, state,country,zip,pobox... how can i use the delimeters to do the parsing for these fields