I am having a problem with the conversion - after adding the EBCDIC to
ASCII conversion my output file is showing unmatchable ascii characters.
I tried to use the parse format but it is still giving me weird
characters in my data. Anybody have any thoughts?
Thank you!
Renee

The trick is to replace only between >...< pairs.

The beauty of TextPipe is that you can restrict a set of changes to any region,
using either a pattern, or other subsets like a line range, columns range, a set
of CSV fields etc,

Use a search/replace for the EasyPattern:
   >[ 1+ chars ]<

and set the Action to 'Send Matching Text to Subfilter'.

Then, use a search/replace as a subfilters, finding " and replacing
with nothing or &#8220;



--- In textpipe-discuss@yahoogroups.com, "Doug C" <subscribe@...> wrote:
>
> This is probably so simple that it's been solved a dozen times, but I'm
> stuck. How do I remove quote marks from content that are interfering
> with correct parsing of XML?
>
> I have a lousy translation to XML(XHTML) that has decided that all
> quotation marks need to be translated as ".
>
> Which of course leaves me with text that looks a bit like this:
>
> <p>I would <span class="annoy_reader">never</span> reveal the name of
> the <span class="so_called">"quality"</span> product that put me in
> this position, but it lacks a certain flare.</p>
>
> What I want to do is make sure I replace the quotes around quality
> with... well, anything except what they currently are, really (but in
> this case, &#8220; and &#8221; respectively). And of course, I want to
> leave the other quote marks alone, since they're correct.
>
> This has to be such a common problem that solutions exist by the
> handful, yes?
>

This is probably so simple that it's been solved a dozen times, but I'm
stuck. How do I remove quote marks from content that are interfering
with correct parsing of XML?

I have a lousy translation to XML(XHTML) that has decided that all
quotation marks need to be translated as ".

Which of course leaves me with text that looks a bit like this:

<p>I would <span class="annoy_reader">never</span> reveal the name of
the <span class="so_called">"quality"</span> product that put me in
this position, but it lacks a certain flare.</p>

What I want to do is make sure I replace the quotes around quality
with... well, anything except what they currently are, really (but in
this case, &#8220; and &#8221; respectively). And of course, I want to
leave the other quote marks alone, since they're correct.

This has to be such a common problem that solutions exist by the
handful, yes?

Hi Steve,

You need to add a `Convert end of lines' filter at the top of your
filter list. The Trial Run area (as documented in the help) converts
all EOLs to Windows Cr/LF. Your files, and the clipboard, may use Unix
or Mac EOLs.

Let me know if we can help further.

Regards,

Simon Carter, DataMystic          Melbourne, Australia
www.datamystic.com         +61.3.9886.6896 (GMT+10 hours)
TextPipe: Text Conversion, Reformatting and Extraction Workbench
   PCMAG - "The ultimate text conversion and manipulation tool"
Online Demo: www.datamystic.com/tpdemo
http://www.DownloadPipe.com - Newest Software Every Minute

I have a filter file which using a series of preset filters (like the
HTML code stripper), and a series of exact-match replacement filters
(usually to get rid of text altogether), and a series of regexp
replacement filters.

The intended input are HTML files. These HTML files are actually
webpages from an online reseller service, saved to my hard drive. Each
webpage details a single sale.

Anyway, if I open any of these HTML files into Notepad, then paste all
the code into the TPP Trial Run Area, the output is perfect.

*But* if any of these HTML files are input as files (by pointing to a
specific file, or a folder containing the files on my hard drive) then
many of the replacement operations are left undone.

The same poor result is evident even when I input straight from the
clipboard. I even get a poor result when I copy the data to the
clipboard from the input pane in the Trial Run Area, after having just
ran a successful trial run on that very same data!!!

All the filters and steps in this .fll file are enabled. As I said, it
works perfectly in the Trial Run Area.

I just don't get it. This forum doesn't seem very active anymore, but
I hope somebody out there can help me. This is a rather urgent matter.
(And this isn't a matter of trying to save time by salvaging an old
filter file. I just created this filter file, and it is perfect, as
shown by performing trial runs of several different HTML files from my
reseller.)

Thanks in advance for your help!

Steve Kay

Hi,

How can split a file by file size and string pattern?
For example I would like to split a file into minimum size of 5 MB and
find a string pattern as the splitting point.

Thank You!

--- In textpipe-discuss@yahoogroups.com, "Seven" <sevenkitten@...> wrote:
>
> I have been working on some data extraction.  I am using textpipe
> pro as well as Easy pattern helper.. I need to extract two lines
> that read like this
> Sales:
> $200.12 bil
> There is the line break in it and the numbers in red are the
> variable chars.
> I can get it to pull up using the Perl pattern
> (?:Sales:)
> (?:(?:[[:digit:]!"#$%&'()*+,\-./\\:;=?@\[\]\^_`{}~|]{1,7}?))(?:
> bil)            ........ which is the same as this EasyPattern

Simple. Replace line break with whitespace after "Sales:"
First filter (replace):
     -Search
     (Sales:)(\r\n)
     -Replace with
     $1[ ]
Second filter (extract matching line, or just grep)
     - Match pattern
     Sales:

So first filter appends next line to "Sales:" line resulting in
Sales: $120.12 bil
Second filter extracts all lines with "Sales:" in it

I have been working on some data extraction.  I am using textpipe
pro as well as Easy pattern helper.. I need to extract two lines
that read like this
Sales:
$200.12 bil
There is the line break in it and the numbers in red are the
variable chars.
I can get it to pull up using the Perl pattern
(?:Sales:)
(?:(?:[[:digit:]!"#$%&'()*+,\-./\\:;=?@\[\]\^_`{}~|]{1,7}?))(?:
bil)            ........ which is the same as this EasyPattern

Sales:
[ longest 1 to 7 digits or <!"#$%&'()*+,-./\:;=?@[]^_`{}~|> ] bil

But what it's doing is pulling two separate lines so I get Sales:
and the number that goes with it.. plus a million other numbers that
match that "number" pattern on these documents.. The entire reason
I'm using the word Sales:  is that it's the only way to distinguish
that number from all the rest of them!! I've tried everything I can
think of in between there like [newline] [linefeed] [return] .. (of
course their Perl conversions) .. but nothing works!!
Can someone please help me find a way to extract those two lines
together? Can that be done?
I have been working on this forever now and I have a major deadline
on this.. Please Help!!! :)
Thanks,
Tori

The latest TextPipe Pro Beta can be downloaded from:
   http://www.datamystic.com/textpipeprobeta.exe
and for customers, from the pre-release link in the secure area.

We're inviting all users to try it out, but particularly those using
- Mainframe copybooks
- Unicode data
- Conversions between language encodings
- Complex search/replace expressions with a need for more than 36
variables.

Please send us your feedback!


What's New in TextPipe v7.7.5
=============================

* The user is now given the option to manually start Word or Excel
if they are
not running when TextPipe needs them (with the Convert Word/Excel
Document to
Text filters).
* Pattern matches can now name captured variables for use in the
replacement
text e.g. searching for (?P<dollars>\d+) would then allow the macro
@dollars
to be used in the replacement, and also as a global anywhere else in
the
filter list.
* Far more complex patterns can be processed, with support for up to
99
captured variables, from $1-$99.
* Mainframe Copybook Wizard now allows underscores (_) and single
quotes (') in
field names in  'XXX_XXXX 4 AN 1-4'-type copybooks.
Wizard now removes the content of fields called FILLER* .
Wizard now copes with repeated single-fields, as well as GROUPED
OCCURS.
EBCDIC packed decimal fields can now have either a leading sign,
trailing
sign or no sign.
New option to trim leading spaces and zeroes from fields.
New option to only expand numeric fields - Alpha fields are left
unchanged.
This is useful when the target application can accept EBCDIC data
but can't
handle packed decimals.
Wizard can now cope with removing line numbers and commented
copybook lines
(those with a '* ' in column 7).
Wizard can now cope with field definitions spread over multiple
lines.
Wizard now remembers settings betting uses in a single session.
* EasyPatterns now produce optimized perl regex output. Added
EasyPattern
EBCDIC('') for matching EBCDIC values. Fixed parsing error with ASCII
()
function.
* Hex displays now all use '.' to replace space.
Query replace window now shows hex offsets for Hex Dump display.
* New File Shred filter to completely overwrite file contents.
* Split filter now can split at a pattern.
New Split Filter option to avoid overloading directories. When more
than
10000 files are created, TextPipe starts a new folder.
* Filter list tree now auto-scrolls.
Filter list tree now allows mass enable/disable of filters with
select and
right-click.
* New Filters to Add File Headers/Footers. These filters do not
output anything
when a restriction changes, so they only output once per file.
* Now can drag and drop filters between filter lists in different
windows.
* Filters Add Header/Footer/Left Margin/Right Margin now always
check for
@macros embedded in the text, regardless of whether the text comes
from the
memo or an external file.
* Fixed bug with search/replaces where an internal conversion from
ansi to
Unicode and back could result in high-ansi characters not being
mapped
correctly back to their original characters. In particular, the ansi
(tm)
symbol mapped back to TWO characters.




Regards,

Simon Carter, DataMystic          Melbourne, Australia
www.datamystic.com         +61.3.9886.6896 (GMT+10 hours)
TextPipe: Text Conversion, Transformation, Cleansing and Extraction
Workbench
   PCMAG - "The ultimate text conversion and manipulation tool"
Online Demo: www.datamystic.com/tpdemo

I'm trying to move the first line matching a pattern to a different
(and fixed) line position. For example, I would like to move line
number 4 to position number 3. How do I do this? I'm totally lost. Any
help would be highly appreciated.

Ciba Vision Contact Lenses
Ciba-Vision-Contact-Lenses-.html
<p class="headline1">Ciba Vision Contact Lenses </p>
Ciba vision contact lenses promise you healthy and clear eyesight,
which will help you devour all the beauties that life has in store for
you. Ciba vision contact lenses and lens care products are available in
70 countries worldwide, meeting the visual needs of millions of
customers who express great satisfaction after using them.
<p class="maincopy">Ciba vision contact lenses promise you healthy and
clear eyesight, which will help you devour all the beauties that life
has in store for you. Ciba vision contact lenses and lens care products
are available in 70 countries worldwide, meeting the visual needs of
millions of customers who express great satisfaction after using
them.</p>

We've just released TextPipe Pro 7.4 - the easiest way to
     fix, convert, transform or data mine text files.

     TextPipe can now convert to and from 150+ code pages, as well as
     Unicode and 145 other encodings.

     v7.4 has a new wizard to design filters for converting Mainframe
     Copybooks - this saves stacks of time. We have a new filter for
     capturing data so it can be re-output further down (eg report
     headers), and a variety of ease-of-use enhancements.

       ... more cool new features below ...

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

     Contents:

     1) TextPipe 7.4 New Features

     2) DataMystic Newsletter

     3) TextPipe Discussion Forum

     4) Tip 1 - Have You Heard About EasyPatterns?

     5) Tip 2 - Looking for Brand New Software? DownloadPipe.com

     6) WANTED: Professional Information Consultants to Resell
TextPipe

     7) RSS Feed For Notification of New Releases

     8) Download TextPipe 7.4

     9) Upgrades

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

     TEXTPIPE 7.4 NEW FEATURES

     Enhancements:

     * New filters for code page conversion.
     * Mainframe copybook wizard is now more flexible in the data it
matches, and
       handles COMP-3 field types, and handles numeric fields with
purely decimals
       (eg V999).
     * New filters for Unicode Compose and Decompose:
       NFC - Canonical Decomposition, followed by Canonical
Composition
       NFD - Canonical Decomposition
       NFKD - Compatibility Decomposition
       NFKC - Compatibility Decomposition followed by Canonical
Composition
       Canonical Compose.
     * Now supports Unicode command line parameters.
     * Now supports single quoted CSV data, quoted tab data, and
backslashes in
       quoted CSV or Tab data. Existing text delimiters are now
preserved on
       conversion between CSV and Tab formats. The EasyPattern
[tabfield] can now
       match quoted tab data.
     * The Restrict to HTML filter can now set the maximum match
size - to match
       very large sections of HTML or XML.
     * When files are dropped, TextPipe defaults files to 'no
subfolders'.
     * Simplified the Trial Run button - now it only performs a trial
run, and does
       not toggle back to the Filters to Apply tab.
     * Encode Hex filter now does not add line feeds.

     Usability enhancements:
     * Clarified examples in perl pattern right-click menus.
     * Right-click option Show Hex Dump now checks if the underlying
field is
       Unicode or not before displaying data. A toggle between UTF16-
LE and UTF16-BE
       is also available.
     * Run External Program filter now reports in the log if the
external program
       has a non-zero exit code. The output file handle is now
released on error.
     * The Unicode Map filter's 'Replace With Value' string now
supports special
       characters such as \t, \r, \n etc.

     Speed Improvements:
     * Speed optimization for interactive search/replace when
[Replace Job] chosen.
     * Reduced memory requirements of Database filter when SELECTing
data sets.

     Bug fixes:
     * XSLT filter now correctly flags modified text - so output
files get created
       when the 'Only Output Modified Files' flag is set. XSLT filter
now reports
       the error code and error reason to the log if an error occurs.
     * Fixed bug with Unicode exact match and Unicode pattern match
where search
       terms were not found.
     * Fixed database filter's handling of VarBinary (BLOB) data.
     * Database filter now handles subfilters correctly for encoding
VarBinary data.
     * Fixed bug when referencing a CSV or Tab search/replace list
where the
       replacement column was missing. A new error message now
provides the line
       number of any errors.
     * Fixed bug with inserting captured text as an HTML table row,
and added the
       ability to insert as an XML record.
     * Fixed bug with Input Filter, Prompt On Binary files setting,
if 'No To All'
       was chosen TextPipe skipped ALL remaining files, not just
binary files.
     * Fixed Unicode display of extended information in the Prompt on
Replace
       dialog. Note: Unicode patterns do not support capturing- only
$0 works.
     * Fixed Map filter not detecting Reset and Clear changes.
     * Fixed mismatch of 16 and 32-bit Unicode strings when
converting from ANSI or
       ASCII/OEM to Unicode and between code pages.

     ...and more - see:
       http://www.datamystic.com/textpipe/whatsnew.html

     As always, TextPipe will read filters from ALL old versions
without
     any changes being required.

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

     DATAMYSTIC NEWSLETTER

     If you haven't yet signed up for our newsletter, you just missed
     a fantastic issue on splitting files at words and patterns, and
     on changing the 'nth' occurrence with a search/replace. You can
     sign up for it by sending a blank email to
       mailto:datamystic-subscribe@yahoogroups.com
     For the archive, see:
       http://groups.yahoo.com/group/datamystic/

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

     TEXTPIPE DISCUSSION FORUM

     Did you know about our discussion forums? Ask questions, trade
     tips, and help other users -> Logon online at
       http://www.datamystic.com/forums

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

     TIP 1 - HAVE YOU HEARD ABOUT EASYPATTERNS?

     Have you tried EasyPatterns? These are the easiest way to learn
     text pattern matching - and the best thing is that you can use
     them in any third party product that supports perl-style
patterns!

     e.g. to reformat a date like 20042201 to 22-01-2004, just...

     Search for EasyPattern:
       [ capture(Year), capture(MonthNumber), capture(Day) ]
     Replace with:
       $2-$1-$3

     Download it from:
       http://www.datamystic.com/easypatternhelper.html

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

     TIP 2 - LOOKING FOR BRAND NEW SOFTWARE? - DOWNLOADPIPE.COM

     Our library has 52,000 products, updated HOURLY, powered by
     TextPipe technology.

       -> http://www.downloadpipe.com <- Bookmark now!

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

     PROFESSIONAL INFORMATION CONSULTANTS WANTED TO RESELL TEXTPIPE

     We'd love to hear from you if you have clients who may benefit
     from TextPipe. 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.datamystic.com/resellers

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

     RSS FEED FOR NOTIFICATION OF NEW RELEASES

     You can use an RSS Feed reader to receive timely updates about
     TextPipe releases. Checkout our RSS Feed page at
       http://www.datamystic.com/rss

     or use these feeds directly with your RSS Reader:
       http://www.datamystic.com/rss/news.php
       http://www.datamystic.com/rss/press.php
       http://www.datamystic.com/rss/papers.php

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

     DOWNLOAD TEXTPIPE 7.4

     You can download the new evaluation version from:
       http://www.datamystic.com/freetrials.html

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

     UPGRADES

     To download the upgrade, login to the Secure Area:
       http://www.datamystic.com/secure

     If you have lost your login password, please go to:
       http://www.datamystic.com/password.html

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

     TextPipe also comes in a home user's Web Edition, an
intermediate
     Standard Edition, a consultant's Run Time Edition (with editing
     disabled), and an application programmer's TextPipe Engine.

     Also:
       WordPipe ($699) - search and replace MS Word documents
       ExcelPipe ($499) - search and replace MS Excel spreadsheets
       DataPipe ($599) - search and replace database records
       PowerPointPipe ($499) - search and replace MS PowerPoint
presentations

       ** Save USD 300 with our great value bundles! **

     Purchase Now! - Go to
       http://www.datamystic.com/buy/textpipe.html

     Please tell your friends and colleagues about it!

     Thank you for supporting DataMystic!

     DataMystic Customer Service Team
     http://www.datamystic.com

Hi all,

We've just uploaded our new site design - we hope you like the new
look. Also, if you weren't aware of it, we changed from Crystal
Software to DataMystic back in February (please see
http://www.datamystic.com/datamystic.html for more details).

Please let us know if you discover any problems with the site:
   http://www.datamystic.com

Regards,

Your DataMystic Team
http://www.datamystic.com

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

Wednesday October 6, 2004

Several very busy months have passed since our last 'monthly'
newsletter; we're hoping to be a bit more regular.

If you have an interesting story, tip or use for TextPipe please
send it our way!

Regards,

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

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

THIS ISSUE INCLUDES:

1) Filter for Google Adwords

2) Make Global Changes to a Filter In Your Text Editor -
     and Migrate Filters To Older TextPipe Versions

3) Other Updates and New Products

4) WANTED: Professional Information Consultants to resell TextPipe

5) Download the Latest TextPipe Pro 7.1.2

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

FILTER FOR GOOGLE ADWORDS

If you're using Google Adwords, you may find it tedious to
generate all the broad match, phrase match and exact match terms.
e.g. from
   parse text
you want to generate
   [parse text]  and
   "parse text"

We've designed a filter to assist with this process! Simply
paste all your terms into the Trial Run area, run the filter,
and then Add all the new terms back. The filter also takes care
of removing duplicates, but Google does this as well.

Download now:
   http://www.crystalsoftware.com.au/textpipe/user_filters.html

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

MAKE GLOBAL CHANGES TO A FILTER IN YOUR TEXT EDITOR -
   AND MIGRATE FILTERS TO OLDER TEXTPIPE VERSIONS

It seems that only Power Users have found TextPipe's ability to
export code to VBScript and JScript from the File Menu\Export
function. This is really handy for creating filters on the fly
from within your own programs, or even for running TextPipe
from a simplified web page front end.

And there are other ways to use it too:

Let's say you need to make changes to a large number of TextPipe
filters. You could either do this by hand, or you could
1) File Menu\Export the filter to a .vbs or .js file
2) Edit the code using a text editor (or TextPipe!)
3) Use the modified .vbs or .js code to regenerate the filter
    in TextPipe. To do so, you'll need to add three lines to the
    end of the (.vbs) file:

   vb_connectTextPipe
   vb_TextPipeApp.visible = true
   vb_build_filter( vb_TPWindow )

4) When you double-click on the .vbs file, TextPipe will open,
    build the new filter, and then stay open for you to save it.

You can also use this approach to move a filter to an OLDER
copy of TextPipe. Simply export to .vbs or .js, edit the file back
to the API that the older version expects, then load it up. Note -
you'll need to run the old version prior to double-clicking on
the file, so that the old version registers itself in the registry
in preference to the newer version.

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

OTHER UPDATES AND NEW PRODUCTS

We've released PowerPointPipe - the companion tools to WordPipe
and ExcelPipe for search and replace in Office documents.

We've also released TextPipe Pro 7.1.2, and EasyPattern Helper
1.5 to go with it.

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

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

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

DOWNLOAD THE LATEST TEXTPIPE PRO 7.1.2

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

- to be announced shortly.

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

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

EasyPatterns are a user-friendly language to match text patterns
such as phone numbers, email addresses, prices, times, dates, IP
addresses, Zip codes and much more.

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

Contents:

1) EasyPatterns - What's New

2) EasyPattern Documentation

3) Discussion Forum

4) Use EasyPattern Helper to Generate Perl Patterns

5) Use EasyPatterns in Your Application

6) Download EasyPattern Helper 1.4


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

EASYPATTERNS - WHAT'S NEW?

*   EasyPatterns 1.4 is now 100% compatabile with TextPipe 7.0.7

*   We've changed the EasyPatterns for EmailAddress, HyperLink,
     PageNumber and DayOfYear so that the constituent parts are
     captured into $variables for later substitution.

*   We've fixed the EasyPattern for FormFeed.

We've introduced the EasyPattern Engine - a royalty free DLL
that you can include in your applications to make text matching
easier for your users. See
   http://www.crystalsoftware.com.au/easypattern/engine.html

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

EASYPATTERN DOCUMENTATION

Read the EasyPattern Primer:
   http://www.crystalsoftware.com.au/easypatterns_basics.html

See the EasyPattern Reference:
   http://www.crystalsoftware.com.au/easypatterns_reference.html

EasyPatterns are NOW available in TextPipe Pro 7.0,
available from
   http://www.crystalsoftware.com.au/textpipepro7.exe

   See Filters Menu\Replace\Find EasyPattern.

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

DISCUSSION FORUM

You can ask (and answer!) EasyPattern questions in the TextPipe
discussion forum - logon online at
   http://www.crystalsoftware.com.au/forums

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

USE EASYPATTERN HELPER TO GENERATE PERL PATTERNS

You don't EVER have to learn horrible perl patterns!

If you use programs that support perl patterns, you can use
EasyPattern Helper to design and test first, then convert from
an easy to understand EasyPattern to a difficult to understand
perl pattern.

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

USE EASYPATTERNS IN YOUR APPLICATION

If you're a developer, you can use the royalty-free EasyPattern
library in your own applications! See
   http://www.crystalsoftware.com.au/easypattern/engine.html

  - and let us know what you think of it!

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

DOWNLOAD EASYPATTERN HELPER 1.4 - FREE!

You can download the FREE program from:
   http://www.crystalsoftware.com.au/easypatternhelper.exe

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

Please tell your friends and colleagues about it!

Thank you for supporting Crystal Software!

Crystal Software Customer Service Team
http://www.crystalsoftware.com.au

TextPipe 7.0 has some amazing new features...read more below...

TextPipe Pro is the companion product to our other search and
replace tools
- WordPipe for Microsoft Word documents (*.doc)
- ExcelPipe for Microsoft Excel spreadsheets (*.xls)
- NEW! PowerPointPipe for Microsoft PowerPoint presentations (*.ppt)

Save up to USD 300 with our great bundle deals!
   http://www.crystalsoftware.com.au/buy

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

Contents:

1) TextPipe 7.0 New Features

2) Crystal Software Newsletter

3) TextPipe Discussion Forum

4) TIPS: Data Mining Web Sites / Report Mining / Mainframe Conversion

5) WANTED: Professional Information Consultants to Resell TextPipe

6) RSS Feed For Notification of New Releases

7) Our Fancy New Server

8) Download TextPipe 7.0

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

TEXTPIPE 7.0 NEW FEATURES

*   TextPipe is the FIRST application to offer *automated*
     Unicode search and replace, and automated Unicode pattern
     match and replace. It also includes options for space
     compression (treating multiple spaces as one) and for
     ignoring non-spacing characters (invisible characters)

*   Now it's even easier to figure out a file type without having
     to open it -> Use the file grid's new right-click menu items:

     - Analyze file - checks for various Unicode, XML, CSV and Tab
     delimited formats, Unix/PC/Mac end of line format and other types
     - Hex dump - displays a hex dump of the first 200 characters of
     the file

*   The Unicode conversion filter is now much simpler, as you just
     choose an input and output format in one easy step

*   We've added a new XSLT filter for all you XML-types, so you can
     manipulate XML without having to invoke a separate program.

And other GUI and performance enhancements:

*   We've added \x{...} Unicode character matching for exact matches.
     This is a great shortcut -> Instead of typing \x00\x00\x00\x20
     you just type \x00000020
*   Synchronized scrolling option for Trial Input and Output
*   You can now control if the Trial Input and/or Output are treated
     as Unicode
*   Optimized single byte maps for the special case of one output
     character for every input character
*   Better help contexts for the 9 different search/replace types.

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

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

CRYSTAL SOFTWARE NEWSLETTER

If you haven't yet signed up for our newsletter, you just missed
a fantastic issue. You can sign up for it by sending a blank
email to
   mailto:crystalsoftware-subscribe@yahoogroups.com

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

TEXTPIPE DISCUSSION FORUM

Did you know about our discussion forums? Ask questions, trade
tips, and help other users -> Logon online at
   http://www.crystalsoftware.com.au/forums

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

TIP 1: RESTRICTIONS & SUB FILTERS

If you don't know what restrictions and sub filters are, you're
missing all the fun and most of the power of TextPipe.

TIP 2: DATA MINING WEB SITES

The new filters in TextPipe 7.0 make extracting data from web
sites easy! This white paper describes techniques to handle
various data mining tasks - including sample filters for removing
ads, images, formatting and colors, and for converting HTML tables
to CSV formatted data.

TIP 3: REPORT MINING

How to do report mining step-by-step...

TIP 4: MAINFRAME FILE CONVERSION

And we didn't forget you mainframe users! One white paper to rule
them all, with info on expanding EBCDIC packed and zoned decimal
fields, 132 column reports, and Variable width CMS files.

Download these white papers and more here:
   http://www.crystalsoftware.com.au/docs

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

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

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

RSS FEED FOR NOTIFICATION OF NEW RELEASES

You can use an RSS Feed reader to receive timely updates about
TextPipe releases, and avoid worrying if your anti-spam filter
has stopped our all-important emails.

Checkout our RSS Feed page at
   http://www.crystalsoftware.com.au/rss

or use these feeds directly with your RSS Reader:
   http://www.crystalsoftware.com.au/rss/news.php
   http://www.crystalsoftware.com.au/rss/press.php
   http://www.crystalsoftware.com.au/rss/papers.php

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

OUR FANCY NEW SERVER

We've just migrated to a fancy new dedicated server to end
problems with evaluation key emails and update notification emails
not being sent. Performance is also much quicker as we're not
sharing CPU with 100 other sites.

If this is the first email you've seen from us in a while, make
sure you check out the latest features - and get ready to drool...

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

DOWNLOAD TEXTPIPE 7.0

You can download the new evaluation version from:
   http://www.crystalsoftware.com.au/freetrials.html

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

TextPipe also comes in a home user's Web Edition, an intermediate
Standard Edition, a consultant's Run Time Edition (with editing
disabled), and an application programmer's TextPipe Engine.

Also:
   WordPipe ($699) - search and replace MS Word documents
   ExcelPipe ($499) - search and replace MS Excel spreadsheets
   PowerPointPipe ($499) - search and replace MS PowerPoint
presentations

   ** We now have great value bundle deals! **

Purchase Now! - Go to
   http://www.crystalsoftware.com.au/buy

Please tell your friends and colleagues about it!

Thank you for supporting Crystal Software!

Crystal Software Customer Service Team
http://www.crystalsoftware.com.au

You can restrict a replacement or set of changes to a single section
of a .INI file. The trick is to use a search/replace as the
restriction. The example below converts a .INI file section starting
with [TmainForm] to lowercase. This can be easily changed to perform
a search/replace, or to remove matching lines, or to add new lines
with an Add Footer filter.

EasyPattern [[ mustBeginWith( '[TmainForm]', cr, lf, ),  1+ char,
mustEndWith( cr, lf, '[' ) ]] with [$0]
|  [ ] Match case
|  [ ] Whole words only
|  [ ] Case sensitive replace
|  [X] Prompt on replace
|  [ ] Skip prompt if identical
|  [ ] First only
|  [ ] Extract matches
|  Maximum text buffer size 4096
|
+--Convert to lowercase

If the .INI file section will be longer than 4Kbytes, increase the
maximum text buffer size to suit.

Hi there Textpipe Guru's

I have a problem for you all which I have been unable to solve ...
I want to be able to scan a document and update an acronym list and
the input document - here is a brief scenario.

Acronym List (Which is Input File 1):-
LOL : Laughs Out Loud
TLA : Three Letter Acronym


Document (Whis is Input File 2):-
This filter should detect all Three Letter Acronym in a document and
give an Acronym Table Output (ATO) which is an updated Three Letter
Acronym list.

OK, what I am aiming at is a filter which results in the
following .....

Acronym List becomes:-
ATO : Acronym Table Output
LOL : Laughs Out Loud
TLA : Three Letter Acronym

and Output File is:-
This filter should detect all Three Letter Acronym (TLA) in a
document and give an Acronym Table Output (ATO) which is an updated
TLA list.

NOTE: Any phrae with an Acronym (eg Three Letter Acronym) should only
be spelled out on the first occurence. Every subsequent occurence
should have only the Acronym (TLA).

It's a challenge !! First one to get it right wins a prize (Oh, and
the cheque is in the mail!).

Thanks guys (and girls)

Mike

Dear TextPipe-Discuss Group Member,

TextPipe 6.7 has been released - and it's our best ever!
Don't miss out on this new version!

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

Contents:

1) TextPipe Pro 6.7 New Features

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

3) Special Offer - BlackMagic

4) Crystal Software Newsletter

5) TextPipe Discussion Forum

6) WANTED: Professional Information Consultants to resell TextPipe

7) Download TextPipe 6.7

8) Upgrades

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

TEXTPIPE PRO 6.7 NEW FEATURES

*   EasyPatterns - English-like text patterns for mere mortals e.g.
     to match phone numbers, use
       [3 digits, punctuation, 3 digits, punctuation, 4 digits]

     Read more about EasyPatterns:
       http://www.crystalsoftware.com.au/easypatterns.html

*   Many fantastic new HTML and XML filters!
     * Restrict a search/replace or other filters to an XML element,
     attribute or to text between XML tag pairs

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

*   New Restrict To Filename filter. This allows you to search and
     replace inside filenames, number and rename files and much more!

*   Very powerful new debugging feature - selective trial runs. You
     can select which filters are being tested without having to
     clone a piece of the filter. You can perform a Trial Run on:
     * Entire Filter List (current behaviour, default)
     * Selected Filter Only
     * Selected Filter and Sub-Filters
     * Filter List up to and including Selected Filter
     To see these new options, right-click on a filter in the tree
     view.

*   New Backup Mode - renames original files to .BAK. Easily restore
     originals with a single click in the Results window.

*   New Convert Word documents to text files filter.

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

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

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]

(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 check the status line (at the bottom of
the screen) to see where TextPipe is going to add it.

You can combine restrictions by putting one restriction inside
another.

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

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

SPECIAL OFFER - BLACK MAGIC

BlackMagic may be used to colorize Black & White, Sepia, or IR
(infrared) photos. It may also be used to color-correct/re-color
photos with dull, faded, or inappropriate hues. Creating
professional quality colorized photos with BlackMagic is child's
play, yet a photo artist's envy - the results look as if the
photo had actually been 'shot' in color.

Read more:
   http://www.neuraltek.com/bmagic/

Use the tracking code "crystal" when you order for 20% discount!

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

CRYSTAL SOFTWARE NEWSLETTER

If you haven't yet signed up for our newsletter, you just missed
a fantastic inaugural issue. You can sign up for it by sending a
blank email to
   mailto:crystalsoftware-subscribe@yahoogroups.com

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

TEXTPIPE DISCUSSION FORUM

Did you know about our discussion forums? Logon online at
   http://www.crystalsoftware.com.au/forums

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

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

You can download the new evaluation version from:
   http://www.crystalsoftware.com.au/freetrials.html

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

UPGRADES

To download the upgrade, login to the Secure Area:
   http://www.crystalsoftware.com.au/secure

If you have lost your login password, please go to:
   http://www.crystalsoftware.com.au/password.html


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

We have a range of TextPipe solutions for you:
   TextPipe Web ($40) - for fixing home web sites
   TextPipe Standard ($99) - for program source code and more advanced
editing
   TextPipe Pro ($279) - for data mining, data cleansing and
reformatting
   TextPipe Pro 10 Days Only ($50) - for small jobs and short project
use
   TextPipe Pro Run Time ($199) - editing disabled - to install at
client sites
   TextPipe for askSam ($89) - search free-form data with askSam
     See http://www.crystalsoftware.com.au/asksam.html
   TextPipe Engine ($CALL)- embeddable DLL for your own applications
Also:
   DataPipe ($590) - search and replace inside databases
   WordPipe ($50) - search and replace Word documents

To purchase now, please visit:
   http://www.crystalsoftware.com.au/buy

For Annual Renewals, login to the Secure Area:
   http://www.crystalsoftware.com.au/secure

If you have lost your login password, please go to:
   http://www.crystalsoftware.com.au/password.html

We know you'll enjoy the new TextPipe - it's our best version yet!

Please tell your friends and colleagues about it!

We're very proud that TextPipe won the 2003 International
SIA "Best Application" award! See
   http://www.crystalsoftware.com.au/press/20030719.html


Thank you for supporting Crystal Software!

Crystal Software Customer Service Team
http://www.crystalsoftware.com.au



......................................................................
Crystal Software respects your online time and Internet privacy. If
you would prefer not to receive information or special offers from us,
please reply to this email to unsubscribe.
......................................................................

================================================================
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.

Ok - we won't kill the group - it has over 600 members after all!

Spam has become a real pain for most people (us included), so the forums
provide a useful alternative that does not rely on giving away your
email address.

Regards,

Simon Carter, Crystal Software            Melbourne, Australia
http://www.crystalsoftware.com.au         (+61) 3 9888 3104 (GMT+10
hours)
TextPipe: Text Conversion, Transformation, Cleansing and Extraction
Workbench
Winner 2003 Shareware Industry Awards - Best Application
http://www.downloadpipe.com.au - Australia's largest download site


-----Original Message-----
From: Dan Bashaw [mailto:dan.bashaw@...]
Sent: Wednesday, 3 December 2003 6:26 AM
To: textpipe-discuss@yahoogroups.com
Subject: RE: [textpipe-discuss] forums at www.crystalsoftware.com.au/


Hi Simon and TextPipers;

A Yahoo Group 'push' of information works far better for occasional
TextPipe users with busy schedules than a forum that would have to be
intentionally visited... If nothing else the emails remind me that I
really should upgrade again soon. :-)

Please don't kill the Yahoo group for TextPipe!

Thanks;

Dan
_____________________________________
Dan Bashaw
TM NewMedia
Systems Development Specialist
250-475-0808
http://www.tmnewmedia.com/



This group has been superceded by the TextPipe forums at
   http://www.crystalsoftware.com.au/forums

Please sign up there for the latest in TextPipe Questions and Answers!

To unsubscribe from this Yahoo group, please send a blank email to:
   textpipe-discuss-unsubscribe@yahoogroups.com

For frequently asked questions, please see the TextPipe Pro FAQ and
viewlets at
   http://www.crystalsoftware.com.au/textpipe/faq.html

To search previously asked questions, please use the search facilities
at
   http://groups.yahoo.com/group/textpipe-discuss/messages


Your use of Yahoo! Groups is subject to
http://docs.yahoo.com/info/terms/

Hi Simon and TextPipers;

A Yahoo Group 'push' of information works far better for occasional
TextPipe users with busy schedules than a forum that would have to be
intentionally visited... If nothing else the emails remind me that I
really should upgrade again soon. :-)

Please don't kill the Yahoo group for TextPipe!

Thanks;

Dan
_____________________________________
Dan Bashaw
TM NewMedia
Systems Development Specialist
250-475-0808
http://www.tmnewmedia.com/

Hi Fran,

That's easy. Try a search replace pattern like this:

|
|--Perl pattern [ <base loc="en" >(.*)</base>\r\n <tran loc="fr"
origin=""></tran>] with [ <base loc="en" >$1</base>\r\n <tran loc="fr"
origin="">$1</tran>]
|     [ ] Match case
|     [ ] Whole words only
|     [ ] Case sensitive replace
|     [X] Prompt on replace
|     [ ] Skip prompt if identical
|     [ ] First only
|     [ ] Extract matches
|     Maximum text buffer size 4096
|     [ ] Maximum match (greedy)
|     [ ] Allow comments
|     [X] '.' matches newline
|     [ ] UTF-8 Support
|



Regards,

Simon Carter, Crystal Software, www.crystalsoftware.com.au, (+61) 3 9888
3104 (GMT+10 hours)
TextPipe Pro - Industrial strength text transformation workbench
Winner of SIA 2003 'Best Application' award
DataPipe - Swiss army knife for fixing database data
www.downloadpipe.com.au - Australia's largest download site


-----Original Message-----
From: franrpc [mailto:frarquit@...]
Sent: Friday, 19 September 2003 2:09 AM
To: textpipe-discuss@yahoogroups.com
Subject: [textpipe-discuss] Can Textpipe do this??


I´ve got a XML file with over 2000 pairs of lines with the following
structure:

  <base loc="en" >TEXT TO COPY</base>
  <tran loc="fr" origin=""></tran>

and I need to copy the text between the "base" tags into the "tran"
tags, like this:

  <base loc="en" >TEXT TO COPY</base>
  <tran loc="fr" origin="">TEXT TO COPY</tran>

In each one of the 2000+ pairs the text is different.

Is textpipe what I need? If anyone can throw a brief explanation, I´d
be most thankful


Fran




This is the TextPipe Pro discussion group.

To unsubscribe from this group, please send a blank email to:
   textpipe-discuss-unsubscribe@yahoogroups.com

For frequently asked questions, please see the TextPipe Pro FAQ and
viewlets at
   http://www.crystalsoftware.com.au/textpipe/faq.html

To search previously asked questions, please use the search facilities
at
   http://groups.yahoo.com/group/textpipe-discuss/messages


Your use of Yahoo! Groups is subject to
http://docs.yahoo.com/info/terms/

Hi Marc,

That's not too hard, but it will take a little time. We can pickup that
consulting work for you.

Regards,

Simon Carter, Crystal Software, www.crystalsoftware.com.au, (+61) 3 9888
3104 (GMT+10 hours)
TextPipe Pro - Industrial strength text transformation workbench
Winner of SIA 2003 'Best Application' award
DataPipe - Swiss army knife for fixing database data
www.downloadpipe.com.au - Australia's largest download site


-----Original Message-----
From: marclaclear [mailto:marclaclear@...]
Sent: Wednesday, 30 July 2003 4:16 AM
To: textpipe-discuss@yahoogroups.com
Subject: [textpipe-discuss] text extraction


I am trying to extract info from a text file.

I need to extract the solitiation number, Posted date, classification
code, the lines under the contracting office address until
description and lastly all the text after description until Original
Point of Contact.  My knowledge of scripts and filters is limited so
please dont be to technical.  I need it in CSV with each field going
accross in rows.
Here is some sample text.
Thanks for any suggestions
Marc

General Information


Document Type:  Presolicitation Notice
Solicitation Number: F24604-03-R-0005
Posted Date: Mar 06, 2003
Original Response Date:
Original Archive Date:
Current Archive Date:
Classification Code: Z -- Maintenance, repair, and alteration of real
property

Contracting Office Address
Department of the Air Force, Air Force Space Command, 341CONS, 7015
Goddard Drive, Malmstrom AFB, MT, 59402-6863
Description
Work consists of providing all items, articles, materials,
operations, or methods listed, mentioned or scheduled on the drawings
and/or as specified herein, including labor, materials, equipment,
and incidentals necessary and required for completion of Renovation
of Dormitory 735 including dormitory alteration to include the
installation of air conditioning and lawn sprinkler systems. Force
Protection is included in the landscaping. The Request for Proposal
will be available on or about 24 April 2003. Request for Proposal
will close on or about 23 May 2003. Performance period is 365 days
after issuance of Notice to Proceed. This acquisition is open to both
Large and Small business in accordance with the Small Business
Competitive Demonstration Program. The Request for Proposal is
available by electronic transmission ONLY. Potential contractors must
be registered in the Central Contractor Registry to be eligible for
award. (See internet site: hptt://www.ccr.dlsc.dla.mil) All
responsible sources may submit a proposal which shall be considered
by the agency. The magnitude of this project is between $1,000,000
and $5,000,000. The North American Classification System code is
236118. Size standard is $28.5M.
Original Point of Contact





This is the TextPipe Pro discussion group.

To unsubscribe from this group, please send a blank email to:
   textpipe-discuss-unsubscribe@yahoogroups.com

For frequently asked questions, please see the TextPipe Pro FAQ and
viewlets at
   http://www.crystalsoftware.com.au/textpipe/faq.html

To search previously asked questions, please use the search facilities
at
   http://groups.yahoo.com/group/textpipe-discuss/messages


Your use of Yahoo! Groups is subject to
http://docs.yahoo.com/info/terms/

-----Original Message-----
From: paul granger [mailto:pdgfalmouth@...]
Sent: Saturday, 4 October 2003 2:33 AM
To: textpipe-discuss@yahoogroups.com
Subject: [textpipe-discuss] EXCEL Text Generated Files

I am trying textpipe on a trial basis.  I need something that can take an EXCEL spreadsheet and write it out in a text format that retains the field spacing.  For example; when I have a 40 byte description field that contains only 15 characters I need it to maintain the full 40 bytes and not start the next field after the 15th character.  I'm moving the text file onto a mainframe and need to have fixed lenght fields for processing on the mainframe.  Seems like textpipe should handle that, not sure if it actually can and what product I would need to use to do that function.  Anyhelp pointing me in the right direction would be appreciated.  Thanks

---

Do you Yahoo!?
The New Yahoo! Shopping - with improved product search

This is the TextPipe Pro discussion group.

To unsubscribe from this group, please send a blank email to:
  textpipe-discuss-unsubscribe@yahoogroups.com

For frequently asked questions, please see the TextPipe Pro FAQ and viewlets at
  http://www.crystalsoftware.com.au/textpipe/faq.html

To search previously asked questions, please use the search facilities at
  http://groups.yahoo.com/group/textpipe-discuss/messages


Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.

Hi Simon,

I'm surprised that the new forums haven't taken off. i think they
knock spots off yahoo Groups any day especially as they are being
hosted on your site.

May I could suggest that Yahoo groups discussion has a deadline and
then TX over to your own forums. makes sense i think.

Best regards, Mark Spooner.


--- In textpipe-discuss@yahoogroups.com, "Simon Carter, Crystal
Software" <mail@c...> wrote:
> Hi TextPipers,
>
> Attached is a filter to convert zoned decimal to ASCII.
>
> Since the forums at www.crystalsoftware.com.au/forums haven't
exactly
> taken off, we will be continuing this yahoogroup indefinitely.
>
> Regards,
>
> Simon Carter, Crystal Software,
<http://www.crystalsoftware.com.au/>
> www.crystalsoftware.com.au, (+61) 3 9888 3104 (GMT+10 hours)
> TextPipe Pro - Industrial strength text transformation workbench
> Winner of SIA 2003 'Best Application' award
> DataPipe - Swiss army knife for fixing database data
> www.downloadpipe.com.au <http://www.downloadpipe.com.au/>  -
Australia's
> largest download site

I´ve got a XML file with over 2000 pairs of lines with the following
structure:

  <base loc="en" >TEXT TO COPY</base>
  <tran loc="fr" origin=""></tran>

and I need to copy the text between the "base" tags into the "tran"
tags, like this:

  <base loc="en" >TEXT TO COPY</base>
  <tran loc="fr" origin="">TEXT TO COPY</tran>

In each one of the 2000+ pairs the text is different.

Is textpipe what I need? If anyone can throw a brief explanation, I´d
be most thankful


Fran

Hi Tim,

Try searching for the pattern

   \\[\r\n]*

Replace with nothing.

Regards,

Simon Carter, Crystal Software, www.crystalsoftware.com.au, (+61) 3 9888
3104 (GMT+10 hours)
TextPipe Pro - Industrial strength text transformation workbench
Winner of SIA 2003 'Best Application' award
DataPipe - Swiss army knife for fixing database data
www.downloadpipe.com.au - Australia's largest download site


-----Original Message-----
From: ohiotim2 [mailto:tweaver@...]
Sent: Wednesday, 20 August 2003 6:32 AM
To: textpipe-discuss@yahoogroups.com
Subject: [textpipe-discuss] Delete from character to end of line...


Ok, am I trying to overthink this? I have multiple lines that
contain the character "\". I simply want to delete the backslash and
everything after it until I reach the end of the line. Any
suggestions?
Tim



This is the TextPipe Pro discussion group.

To unsubscribe from this group, please send a blank email to:
   textpipe-discuss-unsubscribe@yahoogroups.com

For frequently asked questions, please see the TextPipe Pro FAQ and
viewlets at
   http://www.crystalsoftware.com.au/textpipe/faq.html

To search previously asked questions, please use the search facilities
at
   http://groups.yahoo.com/group/textpipe-discuss/messages


Your use of Yahoo! Groups is subject to
http://docs.yahoo.com/info/terms/

I am trying to extract info from a text file.

I need to extract the solitiation number, Posted date, classification
code, the lines under the contracting office address until
description and lastly all the text after description until Original
Point of Contact.  My knowledge of scripts and filters is limited so
please dont be to technical.  I need it in CSV with each field going
accross in rows.
Here is some sample text.
Thanks for any suggestions
Marc

General Information


Document Type:  Presolicitation Notice
Solicitation Number: F24604-03-R-0005
Posted Date: Mar 06, 2003
Original Response Date:
Original Archive Date:
Current Archive Date:
Classification Code: Z -- Maintenance, repair, and alteration of real
property

Contracting Office Address
Department of the Air Force, Air Force Space Command, 341CONS, 7015
Goddard Drive, Malmstrom AFB, MT, 59402-6863
Description
Work consists of providing all items, articles, materials,
operations, or methods listed, mentioned or scheduled on the drawings
and/or as specified herein, including labor, materials, equipment,
and incidentals necessary and required for completion of Renovation
of Dormitory 735 including dormitory alteration to include the
installation of air conditioning and lawn sprinkler systems. Force
Protection is included in the landscaping. The Request for Proposal
will be available on or about 24 April 2003. Request for Proposal
will close on or about 23 May 2003. Performance period is 365 days
after issuance of Notice to Proceed. This acquisition is open to both
Large and Small business in accordance with the Small Business
Competitive Demonstration Program. The Request for Proposal is
available by electronic transmission ONLY. Potential contractors must
be registered in the Central Contractor Registry to be eligible for
award. (See internet site: hptt://www.ccr.dlsc.dla.mil) All
responsible sources may submit a proposal which shall be considered
by the agency. The magnitude of this project is between $1,000,000
and $5,000,000. The North American Classification System code is
236118. Size standard is $28.5M.
Original Point of Contact

Ok, am I trying to overthink this? I have multiple lines that
contain the character "\". I simply want to delete the backslash and
everything after it until I reach the end of the line. Any
suggestions?
Tim