I have a single address field that contains name (both people and institution) and address information. For instance "JERRIA SMITH 123 MAIN" and "JILLIES STATE CARE CENTER P O BOX 123".
I would like to pre-process this field (using USPREP?), but the delimiters aren't working very well. I've tried using ZQMIXAZQ and ZQMIXNZQ. Are there other options that might work better?
Using MIXA and MIXN for the above 2 examples causes "JERRIA SMITH..." to all stay in the ADDRESS domain and "JILLIES STATE" to go in the NAME domain and "CARE CENTER P O BOX 123" to go into the ADDRESS domain.
Any suggestions are appreciated.
USPREP rule question
Infosphere's Quality Product
-
- Charter Member
- Posts: 15
- Joined: Mon Jan 31, 2005 1:53 pm
- Location: CO, USA
Jump to
- Moderators' Choice
- ↳ Editor's BLOG Corner
- ↳ Ask the Experts! - Dads and Grads
- ↳ DSXchange Testimonials
- ↳ Cognos (IBM BI)
- FAQs
- ↳ FAQs
- ↳ FAQ Discussion
- DataStage
- ↳ General
- ↳ IBM<sup>®</sup> Infosphere DataStage Server Edition
- ↳ IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- ↳ Archive of DataStage Users@Oliver.com
- IBM<sup>®</sup>Infosphere Products<sup></sup>
- ↳ Business Glossary
- Suggestions
- ↳ Site/Forum
- ↳ Enhancement Wish List
- Consulting
- ↳ Talent
- ↳ Looking for Talent
- Support
- ↳ Parameter Manager
- ↳ Compile All Plus
- Usergroup Forums
- ↳ Usergroup Central Forum
- ↳ Heartland Usergroup Forum
- The Written Word
- ↳ Articles, White Papers and Tips and Tricks
- ↳ Product Documentation
- Third Party Applications
- ↳ Third Party Applications
- Product Derivatives
- ↳ Functions
- ↳ Routines
- ↳ Jobs
- ↳ Logs
- Tools
- ↳ Tools Forum
- Category
- ↳ Infosphere Master Data Management
- ↳ Data Quality Best Practices
- ↳ IBM QualityStage
- ↳ Information Analyzer (formerly ProfileStage)
- ↳ IBM<sup>®</sup> SOA Editions (Formerly RTI Services)
- ↳ IBM<sup>®</sup> DataStage TX
- ↳ BI
- ↳ Data Integration