FOR IMMEDIATE RELEASE
Contact: Simon Carter, sales@...
From: Crystal Software Corporation, www.crystalsoftware.com.au
Date: 18 July 2002
DATAPIPE SIMPLIFIES DATABASE CLEANSING AND CORRECTION
Crystal Software has released DataPipe v2.4, a Windows application that lets
database administrators, business analysts and IT consultants easily correct
invalid records in databases without programming.
Unlike other tools, DataPipe interactively searches and replaces through a
database, allowing each change to be checked if necessary. Another unique
feature is the application of pattern matching and replacing, which can be used
to re-arrange text such as swapping the order of dates or surnames and first
names.
DataPipe also provides sophisticated text modification and cleanup scripts to
* Correct capitalization in names and surnames (even with names like Mac and Mc,
de and van de etc)
* Standardize formatting of addresses (e.g. PO Box, P.O. Box, POBOX)
* Extract email addresses for your next marketing campaign
* Trim blanks and multiple white space
* Remove binary "garbage" characters
* Remove HTML, XML and SGML
* Remove blank lines
* Insert or remove text within a column
* Truncate or pad a column to a specified width
Custom scripts can also be written using industry standard VBScript and JScript
scripting languages. There is even a command line processor that makes it easy
to set up automated processing at predetermined times.
DataPipe can connect to any database through its ADO or ODBC database driver -
SQL Server, MS Access, Oracle, DB2, Informix, SyBase, RedBrick, MySQL, TeraData
etc.
DataPipe v2.4 runs under Windows 95/98/Me/NT/2000/XP, costs $590(US) for a
single user license, and may be purchased securely online at
http://www.crystalsoftware.com.au. Server and Site licenses and a maintenance
agreement are also available. You can download a free, fully-functional 14-day
trial version of DataPipe from the same address.
For more information, contact Crystal Software, 2/9 Woodbine Court, Wantirna,
Victoria 3152, Australia. Phone: +61-3 9888 3104 Fax: +61-3 8610 1234 E-mail:
sales@... Internet: http://www.crystalsoftware.com.au
# # #
Evaluation Copy Available on Request.
Online demonstrations available at the website.
Screen shot: http://www.crystalsoftware.com.au/images/textpipe_screen.gif
About Crystal Software:
Since 1990, Crystal Software, based in Victoria, Australia, has been developing
and marketing leading-edge data and text processing solutions and systems
utilities for Windows. In addition to DataPipe, Crystal Software offers:
TextPipe Pro, an award-winning data mining and data cleansing tool that removes
binary characters, word-wraps, and other control characters from text;
ResumePipe Pro; a utility that saves Human Resources professionals time and
money while processing applicants' resumes;
WordPipe, an application that lets you search and replace data across multiple
Word documents in a single operation;
DetachPipe, a program to detach and delete attachments from large email
accounts;
DirSize, a program that helps you identify the programs that are using an
inordinate amount of disk space;
and other productivity software for Windows.
Regards,
Simon Carter, Crystal Software, http://www.crystalsoftware.com.au
TextPipe Pro - Save time with UNLIMITED text manipulation and data extraction
capabilities
DataPipe - Cleanse data in your databases, capitalize correctly, remove garbage
etc
ResumePipe - Increase efficiency and reduce costs by cleansing emails and their
attachments to text files