| Description |
Search and replace inside databases. Fix garbage data, remove binary characters, change embedded UNC paths coded in your database.
DataPipe interactively fixes development, test or production data in ANY table. You can correct capitalization in people's names (a solution to the old problem), standardize formatting of addresses (eg PO Box, P.O. Box, POBOX), extract email addresses (for your next CRM campaign), search and replace using advanced pattern matching, fuzzy matching and sounds-like matching (multiple search and replace operations occur in a single pass through the database), trim blanks and multiple whitespace, remove binary characters ("garbage"characters), remove HTML, XML and SGML, convert between ASCII and EBCDIC, OEM and ANSI, Unicode and ANSI, insert or remove text within a column, force text to a specified width, write your own VBScript or JScript (or PerlScript, PythonScript, REXXscript etc) code against columns (and access COM objects) and MUCH more!
Sub filters can identify text subsets such as a range of lines or columns to be operated on without affecting any other text. This makes it easy to only perform a replacement in lines 1 to 10, or in columns 3 to 20. Other sub filters include CSV- or tab-delimited fields, lines that match or do not match a pattern, and search replacements (allowing replacement text to be capitalized etc).
DataPipe can be fully automated from the command line. Full audit logs keep track of the filters run and changes made. More than 100 example filter files are included along with a comprehensive user manual. DataPipe fully supports language translations.
DataPipe requires you to download TextPipe Pro, and you get TextPipe Pro FREE when you buy DataPipe - so you can use it for cleansing text files and database extracts as well!
Buy DataPipe online:
http://www.datamystic.com/buy |
| Supported languages: English, Russian |
| Supported OS: Win95, Win98, WinME, WinNT 3.x, WinNT 4.x, WinXP, Windows2000 |
| Installation: Install and Uninstall |
|
| Release info |
|
12/01/2004
Major Update
|
Changes:
SQL Syntax highlighting and more!
|
|
| Permissions |
VENDOR INFORMATION
------------------
If you are a
* Shareware distributor
* Disk vendor
* Web site
* CDROM publisher
* Magazine
* Book publisher
* Software bundler
* or any other organisation or person
you may distribute the Evaluation Editions (*) of all DataMystic programs provided the following conditions are met:
1. You must inform the buyer that they are paying for your service,
not for the programs, and that the programs must be purchased if they
wish to continue using them after the evaluation period.
2. You must include all original files included with the program,
and you must not modify these files in any way. If required, you may
add new files of your own.
3. You must let us know by email if you include our software in
your collection. We can then keep you informed of the latest version.
(*) All programs use the HelpAbout dialog or the -? Command line
parameter to identify an Evaluation Edition.
Contact Information
===================
Email: mail@datamystic.com (Simon Carter)
WWW: http://datamystic.com
Fax: +61-3 8610 1234 Any time.
Voice: +61-3 9888-3104 (GMT+10 hours) Mail: Simon Carter
DataMystic
2 / 9 Woodbine Court
Wantirna
Victoria 3152
AUSTRALIA. |
|
| End user license agreement |
This program and the accompanying files and documentation are
Copyright (c) 1990- 2003 DataMystic
All rights reserved
This file contains our end user license. It also explains the terms
of the Commercial License where they're different from the Evaluation
License.
If you have any questions, please contact us at
Address: Simon Carter
DataMystic
2 / 9 Woodbine Court
Wantirna
Victoria 3152
AUSTRALIA
Phone: +61-3 9888-3104 (GMT+10 hours)
Fax: +61-3 8610 1234 (Any time)
Email: mail@datamystic.com (Simon
Carter)
Web: http://datamystic.com
========================================================== ==========
Plain English Evaluation License Agreement and Limited Warranty
1. SUMMARY. You may install this SOFTWARE on as many computers as
your license allows, and no more:
* Desktop Edition/Single User Edition/Personal Edition/Single
User Pack
May be installed on ONE (1) non-server class computer ONLY
* 5 User Pack
May be installed on UP TO FIVE (5) non-server class computers
ONLY
* 10 User Pack
May be installed on UP TO TEN (10) non-server class computers
ONLY
* Server Edition
May be installed on ONE (1) server class computer ONLY
* Site Edition/Educational Site
May be installed on ALL computers at one site
* Company Edition/University Edition
May be installed on ALL computers directly owned by a company
(but not on client's computers)
This is a legal agreement between you and CRYSTAL. By using the
SOFTWARE you are agreeing to be bound by the terms of this Agreement.
Do not use the SOFTWARE if you do not agree to the terms of this
Agreement.
2. DEFINITIONS. In this agreement:
*"SOFTWARE"means the computer program you have purchased
or obtained for evaluation, including the program,
associated documentation and other materials;
*"Evaluation Copy"means a copy of the SOFTWARE distributed
by us or by our authorised agents for evaluation purposes
and which is described as an"Evaluation Edition"or a"Shareware Edition"by the SOFTWARE's"About"screen;
*"Commercial Copy"means a copy of the SOFTWARE purchased
from us or from a dealer, and is NOT described an an
Evaluation Copy by the SOFTWARE's"About"screen. The
actual description may include"Desktop Edition","Single
User Edition","Personal Edition","Server Edition","Site
Edition"or"Company Edition"or other variations
depending on the version purchased;
*"you"means the end user of the SOFTWARE. This can be
either an individual or an entity;
*"server class"means a computer designated as a file
server, database server, application server or other kind
of server;
*"CRYSTAL"means DataMystic, an Australian
corporation (address shown above).
3. GRANT OF LICENSE. CRYSTAL grants you the right to INSTALL this
software on as many computers as you have purchased a license for.
You may NOT install it on computers that you do not have a license
for.
The SOFTWARE is"installed"on the computer when it is loaded into
permanent memory (e.g. hard disk, CD-ROM, or other storage device) of
the computer.
4. COPYRIGHT. The SOFTWARE is owned by CRYSTAL and is protected by
copyright laws and international treaty provisions and all other
applicable national laws. Therefore, you must treat the SOFTWARE
like any other copyrighted material (e.g. a book or musical
recording) except that you may make one copy of the SOFTWARE solely
for backup or archival purposes. You may not copy the user
documentation provided with the SOFTWARE.
5. OTHER RESTRICTIONS. You may not rent or lease the SOFTWARE, but
you may transfer the SOFTWARE and accompanying written materials on a
permanent basis provided you retain no copies and the recipient
agrees to the terms of this Agreement.
You must not copy, translate, adapt, modify, alter, decompile,
disassemble, or otherwise reverse engineer or create any derivative
work of the SOFTWARE, merge the SOFTWARE or any part thereof with any
other software or change any SOFTWARE in whole or in part, nor allow
any other party to do so. You must not alter or remove any copyright
or other intellectual property notifications applied to the SOFTWARE.
You acknowledge that the SOFTWARE and the copyright, and other
intellectual property rights of whatever nature in the SOFTWARE are
not your property and contain valuable proprietary information and
trade secrets and that this license confers no title or ownership in
the SOFTWARE and no rights in any associated source code, and is not
a sale of any rights in SOFTWARE.
6. EVALUATION PERIOD. You may use an Evaluation Copy of the SOFTWARE
for up to 30 days in order to determine whether it meets your needs.
While you are evaluating the SOFTWARE, you may use it on as many
computers as are required to perform your evaluation. Your
evaluation period begins when you first install the SOFTWARE on one
or more computers for evaluation purposes. Once the evaluation
period is over you MUST PURCHASE THE SOFTWARE or REMOVE IT FROM ALL
COMPUTERS.
7. MAKING AND DISTRIBUTING EVALUATION COPIES OF THE SOFTWARE. You
may make copies of your Evaluation Copy of the SOFTWARE to give to
others, as long as you include all of the files that you originally
received with your Evaluation Copy. When you give an Evaluation Copy
of the SOFTWARE to another person, you agree to inform them that
their copy is to be used for a time-limited evaluation period, and
that they must purchase a Commercial Copy if they continue to use the
SOFTWARE once the evaluation period has ended. You agree not to sell
Evaluation Copies of the SOFTWARE or distribute them to others for
any kind of compensation or fee unless the fee solely covers your
costs in providing it to the end user.
8. OPERATION OF THE SOFTWARE. The SOFTWARE offers powerful
capabilities. If you do not follow our instructions, or if you use
the SOFTWARE improperly, you can destroy files or cause other damage
to your software and data. You assume full responsibility for the
selection and use of the SOFTWARE to achieve your intended results.
9. LIMITED WARRANTY. The following limited warranty applies to
Commercial Copies of the SOFTWARE. It is included here so you
understand what your warranty will be when you purchase a Commercial
Copy. This warranty does NOT apply to Evaluation Copies of the
SOFTWARE.
Bugs and SOFTWARE Errors. We don't promise that the SOFTWARE will be
free of bugs or errors. If you report an error or bug to us, we will
use our best efforts to correct it.
10. DISCLAIMERS AND LIMITATIONS. And now the legal language we
couldn't avoid:
DISCLAIMER FOR EVALUATION COPIES: YOU ARE NOT PAYING FOR THE TRIAL
USE LICENSE FOR YOUR EVALUATION COPY OF THE SOFTWARE. ACCORDINGLY
THE EVALUATION COPY IS PROVIDED"AS-IS"AND WITHOUT WARRANTY OF ANY
KIND.
DISCLAIMER FOR COMMERCIAL COPIES: Except for the limited warranty
stated above, we disclaim any and all other warranties, express or
implied, oral or written, including any implied warranties of
merchantability or fitness for a particular purpose. The limited
warranty above gives you specific legal rights, but you may have
other rights, depending on where you purchased the SOFTWARE.
LIMITATION OF LIABILITY. IN NO EVENT SHALL WE BE LIABLE FOR ANY
INCIDENTAL, CONSEQUENTIAL, OR PUNITIVE DAMAGES WHATSOEVER ARISING OUT
OF USE OF THE SOFTWARE OR YOUR RELATIONSHIP WITH US. SOME COUNTRIES
OR STATES DO NOT ALLOW EXCLUSION OR LIMITATION OF LIABILITY FOR
INCIDENTAL OR CONSEQUENTIAL DAMAGES, THEREFORE THE ABOVE LIMITATION
MAY NOT APPLY TO YOU.
11. This agreement is to be interpreted under the laws of the state
of Victoria, Australia.
END OF LICENSE AGREEMENT |
|
|
| Also by this author |
downloadpipe.com
2.3
DataMystic
Start running your OWN download site in a matter of hours! Promote your ISP, your software, or simply use it as a revenue raising tool! With content updated hourly with no intervention from you, what could be simpler!
ExcelPipe Search and Replace
3.1.1
DataMystic
Apply multiple search and replaces to multiple Excel spreadsheets in one pass. Find and replace (or find only) inside hyperlink addresses, inside shapes, inside headers and footers and document properties. Handles passwords too!
ZeroIn
3.3
DataMystic
Fast CD replacement with Windows 95/98/2000/NT/XP long filename support, history, aliases, fixes your spelling, partial name matching. A must have for Windows 95 long filenames. Does NOT require index files.
WordPipe Search Replace
4.7.3
DataMystic
Apply multiple Unicode search and replaces to multiple MS Word documents in one pass. Find and replace (or search only) inside hyperlinks, headers, footers, text boxes, shapes, document properties, field codes and more! Handles passwords too!
TextPipe Pro
7.5.1
DataMystic
Fast text manipulation and data extraction. Fix websites, database data and electronic text with pattern match,convert DOS/Unix end of line characters,ASCII-EBCDIC,OEM-AN SI,add/remove lines/columns,sort,split,join, database extracts,JScript/VBScript
TextPipe Standard
7.5.1
DataMystic
Fast text manipulation and data extraction. Fix websites, database data and electronic text with pattern match,convert DOS/Unix end of line characters,ASCII-EBCDIC,OEM-AN SI,add/remove lines/columns,sort,split,join. Winner SIA 2003...
EmailPipe
2.2
DataMystic
Converts emails to numbered text files suitable for further processing. Attaches to MAPI clients including MS Outlook or Lotus Notes. Processed emails can be moved or deleted, and can be retrieved frrm any folder. Can control where output text files
PatternHelper
1.0
DataMystic
Makes it easy for developers AND beginners to design and test patterns. Patterns written with perl regular expressions, egrep regex, MS Word or Brief pattern matching languages can be designed and tested with syntax highlighting and a s
PowerPointPipe Search and Replace
1.7.1
DataMystic
Apply multiple Unicode search and replaces to multiple PowerPoint presentations in one pass. Find and replace (or find only) inside hyperlink addresses, inside shapes, inside headers and footers, and inside document properties.
DirSize
4.5
DataMystic
Command line tool that can easily be automated to generate nightly reports of disk space usage, network space hogs and very large folder trees. Reports can be sorted and small folders can be prevented from being displayed.
|
|
|
Advanced interactive search/replace directly in database tables with patterns, fuzzy and sounds-like matching,trim leading and trailing blanks and binary characters,correct capitalization,code your own transform in VBScript or JScript and heaps more!
