================================================================
Crystal Software Newsletter Vol. 1 www.crystalsoftware.com.au
================================================================

Monday, January 26, 2004 - Happy Australia Day!

Welcome to our inaugural newsletter! In this newsletter we offer
TextPipe tips and techniques, share some of our customer's success
stories, and let you know about product upgrades and special
promotions.

This month features some great articles on TextPipe Restrictions and
the TextPipe wizard.

Regards,

Simon Carter
CEO, Crystal Software
simon.carter@...

****************************************************************

THIS ISSUE INCLUDES:

1) askSam and TextPipe Help Turn Crime Tips Into Arrests

2) The TextPipe Wizard - What is it?

3) TextPipe Restrictions - What are they and how do I use them?

4) WANTED: Professional Information Consultants to resell TextPipe

5) Download TextPipe Pro 6.7

****************************************************************
Please forward this newsletter to anyone you think may be interested.
Thank you. Information on how to SUBSCRIBE / UNSUBSCRIBE is at the
bottom.
****************************************************************

ASKSAM AND TEXTPIPE HELP TURN CRIME TIPS INTO ARRESTS

Nestled in the heart of Southern Ontario Canada, in the town of
Fergus, is the Crime Stopper program covering Wellington County.
Crime is no stranger to any of our communities and is enforced by
local and provincial police. Crime Stoppers, as a service, supports
law enforcement by providing tips gathered by their staff. Those
reporting the tips, "Tipsters" they are called with affection, have
their identities protected through rigorously followed procedures and
mechanisms. The tips, provided by the Tipsters, are recorded and
immediately forwarded to law enforcement for investigation, arrest
and prosecution. Millions of dollars annually is diverted or
recovered from Criminal Activities directly related to Crime Stopper
programs.

Read more:

http://www.crystalsoftware.com.au/textpipe/case_studies/crimestoppers.
html

****************************************************************

THE TEXTPIPE WIZARD - WHAT IS IT?

The TextPipe Wizard is an easy to use front-end for TextPipe Web,
Standard and Pro. Whereas the TextPipe interface is function-based,
the Wizard is task-based, and includes Wizards for tasks including:
- searching and replacing
- adding line numbers
- cleaning up email text
- converting end of line formats between PC/Unix/Mainframe
formats
- converting between tab delimited, pipe delimited, comma
delimited and semi-colon delimited formats
- processing website logs
- splitting and joining files
- sorting
- extracting data from a database
- and much more.

The Wizard is a great example of how you can control TextPipe from
within your own applications.

We welcome any suggestions for new tasks.

The Wizard can be found online here:
http://www.crystalsoftware.com.au/textpipe/wizard

****************************************************************

TEXTPIPE RESTRICTIONS - WHAT ARE THEY AND HOW DO I USE THEM?

TextPipe Restrictions are one of its most powerful and unique
features. Put simply, they allow you to control exactly where a text
modification occurs. An example of a restriction could be lines 1 to
10, or columns 3 to 17, or only lines matching a pattern. For
example, if you wanted to perform a search and replace in just the
first header line of a CSV or tab-delimited file, you could do it
like this:

|--Restrict lines:Line 1 .. line 1
| |
| +--Replace [old value] with [new value]
| [ ] Match case
| [ ] Whole words only
| [ ] Case sensitive replace
| [ ] Prompt on replace
| [ ] Skip prompt if identical
| [ ] First only
| [ ] Extract matches

(By the way, if you've never seen filters displayed as above, check
out the File Menu\Export Filter to Clipboard option)

Tip: To drag one filter inside another, first add both filters from
the Filter Menu, then drag and drop the lower filter to the RIGHT
HAND HALF of the upper filter in the filter view. When you drop it,
it will be added as a sub filter, inside the upper filter.

You can combine restrictions by putting one restriction inside
another.

Read more:
http://www.crystalsoftware.com.au/textpipe/restrictions.html

****************************************************************

PROFESSIONAL INFORMATION CONSULTANTS WANTED TO RESELL TEXTPIPE

If you have clients who may benefit from TextPipe, we would love to
hear from you. We have a dedicated and friendly support staff, highly
reputable products and a generous commission structure.

If interested in receiving more information, please see:
http://www.crystalsoftware.com.au/resellers

We also have an affiliate scheme if you would like to sell TextPipe
from your website - see the link above.

****************************************************************

DOWNLOAD TEXTPIPE PRO 6.7

The TextPipe Pro release will be announced shortly!

http://www.crystalsoftware.com.au/textpipepro.exe

****************************************************************
This newsletter is sponsored by Crystal Software.

It can be reprinted and redistributed as long as the
author and sponsor are acknowledged.