Proper Case Conversion, Data Translation & Standardization API


		Rock-Solid Components for Software Professionals

ActiveCase COM Component

Proven ActiveX Problem Solvers

Proper Case Conversion and Data Transformation API

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. ActiveCase can easily translate, punctuate, abbreviate, unabbreviate as well as correct common misspellings before they enter your system. The result is a precise transformation to proper case no matter what type of data.

	● 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.
	● User Expandable Tables - Included are over 1,000 proper-cased and punctuated Irish surnames.

Windows 7 Compatible

^$299	Single Developer License	Download Evaluation (2.43 MB)
^$599	5 Developer Team License	User’s Guide
^$1499	Site License - Unlimited Developers	View Cart
	ActiveX Bundle Pricing

A Closer Look

How ActiveCase Works


	ActiveCase can process all types of data including Names, Addresses, City/State/Zip, Sentences and Titles, each with its own unique capitalization rules. The capitalization is controlled through the use of 8 user-definable styles. The use of style tables allows the application of different capitalization rules to the same word depending on its context. ActiveCase does more than just proper case conversions. Use it to punctuate, abbreviate and even expand existing abbreviations. Instantly correct typos with the built-in list of common misspellings.		ActiveCase starts by applying the default capitalization rules for the selected style. Next, the selected style table is searched for every character, word and phrase in the input string. When a match is found, the corresponding character, word or phrase from the style table replaces the original data in the input string. To use ActiveCase, set the Text_Style to the data type of the input string then set the Text_In property to the text to be adjusted. After calling the Convert method, ActiveCase returns the converted string in the Text_Out property.

Proper Case Conversion Demonstration

Style	[NameStyle]
Input	MR/MRS JOHN VAN DER CAMP PHD
Output	Mr. and Mrs. John Van der Camp, Ph.D.
Style	[AddressStyle]
Input	1234 SE OBRIEN CT
Output	1234 SE O’Brien Court
Style	[CityStateZipStyle]
Input	FT COLLINS, COLORADO
Output	Fort Collins, CO
Style	[TitleStyle]
Input	(c) TSC
Output	© The Software Company, Inc.
Style	[SentenceStyle]
Input	A FAMILIAR CLICHE.
Output	A familiar cliché.

The screen shot above was taken from a sample application created using VB6. Other samples, including Access, can be found in the ActiveCase folder.

The use of the wildcard character (*) in the style tables allows you to correctly case entire groups of words depending on their prefix.

Benefits

Features

		Save Keying Time - Automatically Convert Symbols and Translate Abbreviations into Their Correctly Capitalized Full Spelling		Apply Different Capitalization Rules to the Same Word Depending on its Context: “Co” Is Company and “CO” Is Colorado
		Instantly Correct Typos - Built-In List of “Common Misspellings”		Easily Add Punctuation Such as: “abc inc” -to- “ABC, Inc.”
		User Updatable Tables so Your Applications Never Go Out-of-Date		Royalty-Free Runtime (License Agreement)
		Over 1,000 Proper-cased and Punctuated Irish Surnames Included		Designed for Use with:
		FREE Upgrades for a Full Year (Maintenance Agreement)		● Visual Basic ● Access ● C++ ● Visual FoxPro ● SQL Server and more

More Data Quality Tools


		ActiveAddress ● Address Validation ● Address Standardization ● Address Parsing ● No Recurring Charges		ActiveGender ● Name Verification ● Name Parsing ● Gender Determination ● 100,000 Name Dictionary