DataPipe Database Search Replace 4.0


Free Trial
14.02 MB
  Download  




Publisher Description



Search and replace inside databases. Fix garbage data, remove binary characters, change embedded UNC paths coded in your database.

DataPipe interactively or automatically search/replaces 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!

Program Details



General

 
Publisher DataMystic
Released Date 2015-02-02
Languages English, Chinese, ChineseSimplified, ChineseTraditional, Polish, Russian

Category

 
Category Business
Subcategory Databases & Tools

System requirements

 
Operating systems windows

Download information

 
File size 14.02 MB
Total downloads 245

Pricing

 
License model Free Trial
Price $495.00

Version History



» version 4.0   -   posted on 2015-02-02
New drop down menu item to browse for more filters, as some users were confused about how many filters it showed in this history list.

» version 3.6   -   posted on 2005-11-18
SQL Syntax highlighting and more!

EULA - End User License Agreement



This program and the accompanying files and documentation are

Copyright (c) 1990- 2009 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
1 Dalmore Drive
Scoresby
Victoria 3179
AUSTRALIA
Phone: +61-3 9028 8594 (GMT+10 hours)
Fax: +61-3 ---- (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





Add a review


Tell us your experience with DataPipe Database Search Replace 4.0



RELATED PROGRAMS
Our Recommendations






BarCode2D-PNG

DataPipe Database Search Replace 4.0 Screenshot


Click stars to rate this APP!

Users Rating:  
  3.8/5     4
Editor Rating:  
  0/5
Downloads last week: 0
Release Date: 2015-02-02
Publisher: DataMystic
Operating System: windows