Advanced search/replace in databases with patterns, fuzzy and sounds-like match
Publisher's 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!
Size: 1.01MB
Cost: $495.00
Platform: Win95,Win98,WinME,WinNT 3.x,WinNT 4.x,Windows2000,WinXP
License: Free To Try
Category:
Business::Databases & Tools
Date Added: Oct 29, 2006
Date Updated: Sep 19, 2008
Last Release Date: Nov 18, 2005
Page Visit: 7
Malware Status: Clean
Scan Date: Apr 15, 2008
Link to this page
AbusePipe |
Email Abuse Analysis Solution for ISPs. Identifies the originating source of email abuse complaints extremely quickly, and allows you to immediately contact the originating customer and take appropriate action.
Arc Menu |
Y2K compliant, text-based,mouse-driven,uses NO memory, network support, multi-user, passwords and authority levels + access retrictions. Auto install. Shortcuts and hot keys. Context help/user-defined. AutoBuild new items. Unlimitedmenu
BabyShield |
Disables the mouse AND keyboard so that inadvertent keystrokes, mouse clicks/movements by babies, children or pets won't destroy your unsaved 100 page masterpiece. A must have! Use Ctrl+Alt+S to invoke it in an emergency.
Clean 'n' Go |
Ever noticed how you always have your computer turned on when you realise you need to clean the mouse (or spill a drink on the keyboard and need to mop it up in a hurry)? And while cleaning the mouse, you inadvertently screw up running programs?
ClipSize |
ClipSize is a simple program that 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.
DetachPipe |
Save, delete, compress, detach and upload huge email attachments, replace with hyperlink. Reduce PST size and improve Outlook performance. Files are auto-numbered, and can be Compressed and set Read Only. Detach based on date, sender, subject etc
DirDate |
Modify file or folder create/modify/access dates from the command line. It can change dates using either a reference file or a series of YEAR, MONTH, DAY, HOUR, MIN, SEC, MSEC commands. Handles read-only files
DirSize |
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.
DropConvert |
Fix your million page website FAST! with advanced multi-file, multi-folder search and replace, with multi-line exact matches, sounds-like and typographical error correction, pattern matching.
EasyPattern Engine |
EasyPattern Engine COM DLL provides a cool new way to describe text patterns. They're English-like, powerful and easy to understand. Parse a phone number with [optional punctuation, 3 digits, punctuation, 3 digits, punctuation, 4 digits].
EasyPattern Helper |
Design perl patterns using point and click! Just highlight the variable text and the text to capture, and EPHelper does the rest! EasyPatterns are a cool new way to describe text patterns. They're English-like, powerful and easy to understand.
EmailPipe |
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
ExcelPipe Search and Replace |
Search and Replace multiple Microsoft Excel spreadsheets. Change hyperlinks and UNC paths when servers get renamed, update names, addresses and phone numbers, translate with find/replace lists. Automatically handles passwords. Unicode compliant
FileWatcher |
Continuously monitor folders for new files matching a wildcard, then trigger a custom action, such as running a second program with the new files. Files are processed only when completely written - perfect for huge files such as video
KeyboardLocker |
Disables the keyboard, leaving the mouse active. An exit phrase must be entered before the keyboard is reactivated. Can be used to secure dedicated servers, or to show a DVD to a small child without them destroying your computer!
PatternHelper |
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 |
Search and Replace multiple Microsoft PowerPoint presentations. Change hyperlinks and UNC paths when servers get renamed, update names, addresses and phone numbers, translate with find/replace lists. Automatically handles passwords. Unicode compliant
ResumePipe |
Convert emailed resumes and their attachments to numbered text files suitable for importing into packages such as ResTrac. CVs can be cleansed using a TextPipe filter to remove blank lines and garbage characters, word wrap, fix punctuation and more!
TextPipe Engine |
Fast text manipulation and data extraction engine. Fix websites, database data and electronic text with pattern match,convert DOS/Unix end of line characters,ASCII-EBCDIC,add/remove lines/columns,sort,split,join,database extracts,JScript/VBScript
TextPipe Lite |
TextPipe is the ultimate Webmaster tool for updating text. It handles an unlimited number of files and folders, and is unique in handling files of unlimited size. It performs one or more changes AT THE SAME TIME, and can search for MULTI-LINE text...
TextPipe Pro |
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
TextPipe Standard |
Fast text manipulation and data extraction. Fix websites, database data and electronic text with pattern match, convert DOS/Unix end of line characters, restrict changes to line/column ranges, add/remove lines/columns, sort, split and join files
Time Zone Helper |
See an email's time zone and current time with just one click, and generate a time zone chart with one more click! Don't wake your boss at 3am! Time Zone Helper lets you set up different time zones for the people you talk to across the world.
Web Copyrighter |
Secretly protect web text content from theft with hidden information.Secretly leave your 'Mark" on any HTML web page or site, Blogs, RSS feeds, Unicode text and more! Get the legal tools you need to pursue and stamp out illegal use of your content!
WebPipe |
Offline Explorer Pro lets download your favorite Web and FTP sites for later offline viewing, editing or browsing thanks to its many web development features using a built-in internal browser.
WordPipe Search Replace |
Search and Replace multiple Microsoft Word documents. Change hyperlinks and UNC paths when servers get renamed, update names, addresses and phone numbers, translate with find/replace lists. Automatically handles passwords. Unicode compliant
ZeroIn |
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.
Let others know your opinion about this program! Add your comments:
No comments have been provided.
How to link to this page( simply cut and paste the following code into your web page):
Virus Free Award sample code:
Text link code:
DataPipe listed on
DoubleR Software Download
Disclaimer: DoubleR Software Download is not responsible for the content of the publisher's description or website. We cannot be held liable for issues that arise from the download or use of these products. We take every care to ensure that software available from this site is adware-spyware-virus-free but any software downloaded should be virus-checked by the downloader.
