|
|
ActiveCase COM Component |
ActiveX Solutions |
 |
|
| |
|
|
|
|
|
| |
 |
ActiveCase
is a data quality component that converts existing data formats
into proper-cased formats that are more attractive and easier to read.
ActiveCase applies proper case through the use of special algorithms and Style
Tables. With ActiveCase you can easily translate, punctuate, adjust field
lengths as well as correct common misspellings before they enter your system. |
|
 |
●
Proper-case Conversion -
Precisely apply proper-case based on context. |
 |
|
|
●
Data Translation -
Convert symbols and abbreviations - "(c) TSC" becomes "© The Software
Company, Inc." |
|
|
|
●
Spelling Correction -
Instantly correct typos using the included list of common misspellings. |
|
 |
●
Field Length Control -
Create or expand abbreviations using the built-in USPS-approved
abbreviation tables.
|
 |
|
|
| |
|
|
|
|
|
| |
|
|
|
Proper-cased,
personalized
mailings are proven to draw
higher
response rates. |
|
|
| |
|
|
|
|
A Closer Look |
How ActiveCase Works |
|
|
|
|
|
|
|
|
|
|
ActiveCase can process all types of data including
Names, Addresses, City/State/Zip,
Titles,
Sentences and more, each with its own unique capitalization rules. The
capitalization is controlled by 16 user-defined style tables. Style tables
allow you to apply different capitalization rules to the same word depending
on its context. ActiveCase does more than
just proper-case conversions. You can also control field lengths using the
built-in table of more than 2,300 common business word abbreviations as
defined in USPS "Postal
Addressing Standards Publication 28". |
|
ActiveCase is controlled by 16 user-defined Style Tables each with its
own unique
customizable
definitions. ActiveCase starts by applying the algorithm for the selected
Capitalization: "Title", "Sentence", "EachWord", "Upper", "Lower" or "None".
Next, every word/phrase from the input string is compared to the Style Table
that was selected for that string. When a match is found, a replacement is made
using the corresponding word/phrase from the selected Style Table overriding any
other capitalization settings. The result is a precise transformation to
proper-case no matter what type of input string.
|
|
| |
|
|
| |
 |
|
| |
The screen shot above was taken from a sample application created using
Visual Basic 6. This sample can be found in the ActiveCase folder. |
|
| |
|
|
| |
|
Capitalization |
Style Table |
Text In |
Text Out |
Comments |
|
EachWord |
NameStyle
CityStateZipStyle |
aspen drilling co
aspen co 81611 |
Aspen Drilling Company
Aspen, Colorado 81611 |
avoid confusion between words like "company"
and "Colorado" |
|
EachWord |
AddressStyle
CityStateZipStyle |
1 n beechwood ct
hartford, ct 06106 |
1 N Beechwood Ct
Hartford, CT 06106 |
eliminate conflict between street
suffixes and certain state abbreviations |
|
EachWord |
NameStyle |
M/M JOHN OBRIEN PHD |
Mr. & Mrs. John O'Brien, Ph.D. |
expand abbreviations, add punctuation |
|
Title |
NameStyle |
minnesota mining and manufacturing company |
Minnesota Min & Mfg Co |
abbreviate business words to fit address line |
|
|
| |
The use of the wildcard character (*) in the style
tables allows you to proper case entire groups of words depending on their
prefixes. |
|
| |
|
|
| |
|
|
-
Save Keying Time
- automatically convert symbols and translate abbreviations into their
correctly-capitalized full-spelling
-
Instantly
Correct Typos - using the built-in list of common misspellings
-
Field Length
Control - create or expand abbreviations using the built-in
USPS-approved abbreviation tables containing more than 2,300 entries
-
Personalization
- over 1,000 proper-cased and punctuated Irish surnames are included
-
Free upgrades for a full year
(License
&
Maintenance agreements)
|
-
Apply different
capitalization rules to the same word depending on its context
-
Eliminate conflict between
street address and city/state: Ct = Court, CT = Connecticut
-
Correctly case surnames names
like: "McDonald" and "O'Brien" and medial caps such as: "FEDEX" to
"FedEx"
-
Standardize name prefixes
like: "M/M" and "M&M" to "Mr. & Mrs."
-
Designed for
use with Visual Basic, C++ and other ActiveX compatible programming
languages
|
|
|
|
More Data Quality Tools |
|
 |
|
| |
|
|
|
|
|
| |
 |
ActiveAddress
●
Address Validation
●
Address Standardization
●
Address Parsing
●
No Recurring Charges |
 |
ActiveGender
●
Name Validation
●
Name Standardization
●
Name Parsing
●
Gender Determination |
|
|
|
|
|
|
|
|
|
