DataPipe

DataPipe interactively fixes development, test or production data in ANY table. You can correct capitalization in people's names, standardize formatting of addresses, extract email addresses, search and replace using advanced pattern matching, fuzzy and sounds-like matching, trim blanks and multiple whitespace, remove binary characters and html, insert or remove text within a column, and write your own transform in VBScript or JScript.

What is new in this release:

Version 4.0 has updated the included TextPipe Pro to v9.5

Limitations:

30-day trial