|
|
| 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! |
|
| Updated |
Jun 28, 2007 13:13:53 | | Size | 1034 kb | | Licence | Shareware | | Status | Major Update | | Languages | English | | Tags | database, data, search, replace, search and replace, find and replace, advanced search and replace, grep windows, global search and replace, sed search and replace, windows utilities, freeware downloads, grep, grep pattern, egrep, search and replace text | | OS | Windows 95, Windows 98, Windows ME, Windows NT, Windows 2000, Windows XP | | Homepage | datamystic.com | | Email | avangatepad@datamystic.com | | Author | Simon Carter |
|
|
 click for full size
|
| Other author's software: | - ClipSize 2.4 — Shows you how much memory the clipboard is using. This can be very useful when you are using a computer with limited memory or with memory-intensive applications such as image editing or desktop publishing.
- TextPipe Pro 8.4.3 — Fast text manipulation and data extraction. Update websites, database data and electronic text with pattern matching,convert DOS/Unix end of line characters, ASCII-EBCDIC,OEM-ANSI,add/remove lines/columns, sort,split, join, database extracts,VBScript
| | Show all author's software |
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! | Short tags:
database, data, search, replace, search and replace, find and replace, advanced search and replace, grep windows, global search and replace, sed search and replace, windows utilities, freeware downloads, grep, grep pattern, egrep, search and replace text | Change Info:
SQL Syntax highlighting and more! |  Find last version of DataPipe | |
| | Freeware alternatives DataPipe 3.6 |
|  Free Download DataPipe 3.6 from datamystic.com |
| Similar software shotlights: | - Pattern Buddy 1.3 — 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…
| | Find all software similar on DataPipe 3.6 |
| Similar smart reviews: | - HandyFile Find and Replace: Text Workbench — Imagine creating a large website consisting of dozens or hundreds of pages with the company’s name topping each of them and lots of identical links in the HTML code. Now imagine that your client urgently requests that these links be modified due to the change of the site address and that the company’s name has to be written in a slightly different manner due…
- RQ Search and Replace, Needles in a Haystack: Found, Replaced — What can be easier than editing a file? — Simply open it and replace a block of text with a better one. Well, true, if there’s just one file to be edited. But doing the same with a few or, even better, a whole bunch of files that require the same replacement? Then you’ll need something like a batch editing tool. A great choice…
- Advanced Data Generator - quick and easy generation of test data for your database — Whenever you develop a database-driven application of any type, database modeling and creation are an integral part of the process. However, testing cannot be properly carried out without realistic database data — you don’t see how objects, text and other database elements are rendered on the page, you can’t see a full picture of your e-commerce store full of products and…
- Advanced Network Search — If using search engines on the Internet has long been a habitual action for millions of users worldwide, doing the same in local networks still seems to be quite exotic. It is assumed that users know where the necessary files are located and keep the names of the frequently visited systems in their memory. However, these days local, area and corporate networks may get extremely large…
- CompareData 1.4.0, Advanced Database Diff — Comparing the content of two databases or their parts is a frequent task of technical specialists in DB-aware environment. Finding differences in two datasets is an important task for migrations (changing DB structure or engine), replications, backup/restore procedures, and other analysis issues. Writing a custom program for each case is inefficient. Fast visual application for…
- Advanced DBF Repair - an efficient remedy for damaged databases — If you ask yourself a question about the most valuable asset in your IT infrastructure, the answer will be short — information. The data that keep your business rolling are truly invaluable and losing them may jeopardize much of what you have achieved. If your company uses DBF databases and you would like to be sure that whenever a serious crash happens, you will be able…
- Recover My Files - Data Recovery – a handy utility that will make sure nothing gets lost forever! — If you have ever lost a file that was really important at a time when it was least necessary, you know this frantic feeling very well. Files can be lost accidentally after a power failure, a hardware crash or a human mistake, and there isn’t much we can do about it. However, if you think that a deleted file is something you can’t get back, you are…
- InfoSeek - advanced data mining techniques at your fingertips — When it comes to extracting the necessary information from a large array of heterogeneous data, you normally have two options. The first and the least efficient one is to do the work manually — but this approach is plain inefficient when the size of the input file exceeds a certain value and becomes completely unusable when you are dealing with a large file or a website…
- Advanced Web Ranking 5.0.3 – Know Your Search Engine Ranking! — While working on improving our websites’ marketing return, we must always have the overall picture of what’s going on with the website before taking another step toward the improvement. What is your website’s current page rank, keyword rank, visibility? It may take you days to check the rankings by hand. Are you willing to spend that much time and effort just to grow…
| | Find all smart reviews similar on DataPipe 3.6 |
|
