 Process Email Body with TextPipe
TextPipe
is a text-processing workbench (also from DataMystic). DetachPipe works with the
Lite, Standard and Pro editions (the Lite edition is the most commonly used).
TextPipe performs text parsing, search/replacing and text processing e.g.
- Parse sales report emails to extract data and place it in a CSV file for
import into Excel (e.g. PayPal, RegNow, CCBill sales emails)
- Search/replace email content to change one string to another
- Changing hyperlinks when you move detached attachments to a new folder
- Remove unwanted text e.g. virus scanning notification messages,
corporate email policy footers etc
- and much more.
The text operation is defined by a TextPipe filter, which is a series of
search/replace instructions, stored in a .fll file. You just tell DetachPipe
which .fll file to apply. If you need help developing a filter, please
contact support.
Note: DetachPipe will prevent you from removing the entire text from an
email. If the new email does not start with a standard <HTML> header tag then
DetachPipe will ignore any changes you have made. This can actually be very
handy for extracting content, and leaving the email unchanged.
Figure 1. TextPipe settings. Most controls are disabled
TextPipe Filter to Apply
This is where you specify the filename (.fll) containing the text-processing
instructions for TextPipe. Double-clicking the field will open the file in
TextPipe. You can also browse for a folder using the button at the right.
Ignore emails smaller than
When checked, DetachPipe will first examine the email to ensure it exceeds
the specified number of KB (KiloBytes) before it processes it. If it is too
small it is not processed. Generally it is only large emails (200 KB or more)
that make up the majority of contributions to mailbox size, so typically this is
set to 200 KB.
Ignore emails younger than
When checked, DetachPipe will first examine the email date to ensure it is
older than the specified number of days before it processes it. If it is too
young (i.e. not old enough) it is not processed. Typically this is set to 30
days, so only files that are looked at infrequently are processed.
| 