TextPipe Pro is the ideal tool to move and convert data between different systems.

Buy Download Tour

You can generate XML, CSV, Tab and SQL INSERT script exports of data in any system you can connect to via ODBC or OLE DB. Once you have the text extract you can apply a series of search/replace, column re-arrangements or any other kind of change to the data.

TextPipe has no limit on the number of files it processes, no limit on the file size, and no limit on the length of lines. In short, TextPipe makes no assumptions about the data you give it - it can even be used on binary files!

You can also perform as many operations as you need to in one pass - hundreds of search/replaces if need be.

If you're working with huge data extracts, you can use TextPipe's Restrictions to limit a search/replace to just the first 100 rows, or just CSV field 3, or even just rows matching a pattern. And you can combine these restrictions too.

Restrictions

Using TextPipe's unique Restrictions, you can control precisely which piece of text gets affected by a change, such as an UPPERCASE filter or a search/replace filter. Restrictions can be as simple as a line range or column range, a CSV field or other delimited field, or an XML element, attribute, or any combination of these.

Receive our white paper - TextPipe Restrictions - What are they and how do I use them?
How to use TextPipe Restrictions, line and column restrictions, combining restrictions, CSV and Tab-field restrictions, filename restrictions, HTML and XML restrictions, splitting lines between filesblackpixel


More white papers

easypatterns EasyPattern Pattern Language

Buy Download Tour

In addition to offering a standard Perl regex pattern matcher, TextPipe also provides the EasyPattern language - an English-like text pattern matching language that us mere mortals can understand without brain surgery!

e.g. to match phone numbers, use [3 digits, punctuation, 3 digits, punctuation, 4 digits].