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

Hi John,

If the lines of characters between the matches is more than 4k long, you
will need to increase the maximum match size expected (under the perl
pattern options) to a larger value.

Regards,

Simon Carter, Crystal Software, www.crystalsoftware.com.au, (+61) 3 9888
3104 (GMT+10 hours)
TextPipe Pro - Industrial strength text transformation workbench
DataPipe - Swiss army knife for fixing database data
DetachPipe - Remove or save unwanted attachments


-----Original Message-----
From: John Ford [mailto:johnf@...]
Sent: Monday, 28 July 2003 8:58 AM
To: Textpipe-Discuss@Yahoogroups. Com
Subject: [textpipe-discuss] Request: Deleting Lines Between Two Known
Lines


I am processing some email data and would like to delete lines as
follows.
I have two reliable markers within the text.  These are lines containing
the
two strings below (with no other text on the lines):

ZZMatchQuoteZZ
Respond to this note

I would like to match the line "ZZMatchQuoteZZ", then delete it and all
lines following it until the "Respond to this note" line is encountered.
This line I would like to keep.

I have been trying to do this with a search replace command looking for
a
Pattern (perl) expression.  It searches for "\nZZMatchQuoteZZ[.*]Respond
to
this note\n" and attempts to replace it with "\nRespond to this note\n".
I
have tried this with both greedy and non-greedy match and varying the ".
matches newline" and "permit comments" options as well.  It fails to
find a
match.

Any help would be appreciated, especially if it can be implemented in
TextPipe 6.2.1.

Regards,
John Ford



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 processing some email data and would like to delete lines as follows.
I have two reliable markers within the text.  These are lines containing the
two strings below (with no other text on the lines):

ZZMatchQuoteZZ
Respond to this note

I would like to match the line "ZZMatchQuoteZZ", then delete it and all
lines following it until the "Respond to this note" line is encountered.
This line I would like to keep.

I have been trying to do this with a search replace command looking for a
Pattern (perl) expression.  It searches for "\nZZMatchQuoteZZ[.*]Respond to
this note\n" and attempts to replace it with "\nRespond to this note\n".  I
have tried this with both greedy and non-greedy match and varying the ".
matches newline" and "permit comments" options as well.  It fails to find a
match.

Any help would be appreciated, especially if it can be implemented in
TextPipe 6.2.1.

Regards,
John Ford

Just use the pattern

   c.(\d{1,4}?)

With the 'Extract' option on, and a replace pattern of

   C.$1\r\n

Regards,

Simon Carter, Crystal Software, www.crystalsoftware.com.au, (+61) 3 9888
3104 (GMT+10 hours)
TextPipe Pro - Industrial strength text transformation workbench
DataPipe - Swiss army knife for fixing database data
DetachPipe - Remove or save unwanted attachments


-----Original Message-----
From: nodfs [mailto:aaron.wagner@...]
Sent: Wednesday, 23 July 2003 4:23 AM
To: textpipe-discuss@yahoogroups.com
Subject: [textpipe-discuss] Strange 'Search & Replace' behavior


I am trying to extract a relatively simple pattern out of each line
in a file but come up with wierd results.  I think I got lucky and
made an expression that works but do not understand why it does not
work in a simpler method.  Both methods are below.

SAMPLE:
T01c.001 F001 S40
T02 C.002F002 S40
T03C.003F003 S40
T04   C.004   F004 S40
T05F005c.005 S40
T06 F006 c.006 S40

Perl pattern Search:
t\d+\D*.*c.(\d\d\d\d|\d\d\d|\d\d|\d)\D+.+.$

Replaces with:
C.$1

Output (desired):
C.001
C.002
C.003
C.004
C.005
C.006


I dont understand why the S&R pattern below does not work.

Perl pattern Search:
t\d+\D*.*c.(\d+).*

Replaces with ("-" used to troubleshoot/see capture):
C.-$1-

Output (undesired):
C.-0-01 F001 S40
C.-0-02F002 S40
C.-0-03F003 S40
C.-0-04 F004 S40
C.-0-05 S40
C.-0-06 S40


Please explain why the capture is not getting the whole set of digits
and why the end of the like is not dropping off.

Thanks so much!!





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 a relatively simple pattern out of each line
in a file but come up with wierd results.  I think I got lucky and
made an expression that works but do not understand why it does not
work in a simpler method.  Both methods are below.

SAMPLE:
T01c.001 F001 S40
T02 C.002F002 S40
T03C.003F003 S40
T04   C.004   F004 S40
T05F005c.005 S40
T06 F006 c.006 S40

Perl pattern Search:
t\d+\D*.*c.(\d\d\d\d|\d\d\d|\d\d|\d)\D+.+.$

Replaces with:
C.$1

Output (desired):
C.001
C.002
C.003
C.004
C.005
C.006


I dont understand why the S&R pattern below does not work.

Perl pattern Search:
t\d+\D*.*c.(\d+).*

Replaces with ("-" used to troubleshoot/see capture):
C.-$1-

Output (undesired):
C.-0-01 F001 S40
C.-0-02F002 S40
C.-0-03F003 S40
C.-0-04 F004 S40
C.-0-05 S40
C.-0-06 S40


Please explain why the capture is not getting the whole set of digits
and why the end of the like is not dropping off.

Thanks so much!!

Hi Lisa,

Do you mean quotes or commas? Can you please attach a small sample file?

Regards,

Simon Carter, Crystal Software, www.crystalsoftware.com.au, (+61) 3 9888
3104 (GMT+10 hours)
TextPipe Pro - Industrial strength text transformation workbench
DataPipe - Swiss army knife for fixing database data
DetachPipe - Remove or save unwanted attachments


-----Original Message-----
From: lmendis2002 [mailto:lmendis2002@...]
Sent: Saturday, 12 July 2003 12:19 AM
To: textpipe-discuss@yahoogroups.com
Subject: [textpipe-discuss] Excel file


When saving Excel files as Unicode text, Excel puts a comma around
any cells that already had commas in them.  I'm a new TextPipe user
and would like to be able to auto filter out these quotes.  How do I
do this?

Also, is there a way to change the file's code page to UTF8 vs the
default Unicode text page which I think is UTF16.  Any ideas?

Thanks
Lisa Mendis



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/

When saving Excel files as Unicode text, Excel puts a comma around
any cells that already had commas in them.  I'm a new TextPipe user
and would like to be able to auto filter out these quotes.  How do I
do this?

Also, is there a way to change the file's code page to UTF8 vs the
default Unicode text page which I think is UTF16.  Any ideas?

Thanks
Lisa Mendis

Hi José,

The Allow RTF tags feature is only designed for use with text that
consists of normal words - not with text that already contains a
pattern. You should be able to use the pattern without using Allow RTF
tags.

[Please ensure that your reply address is set to
simon.carter@...]

Regards,

Simon Carter, Crystal Software, www.crystalsoftware.com.au, (+61) 3 9888
3104 (GMT+10 hours)
TextPipe Pro - Search and replace on steroids!
DataPipe - Swiss army knife for fixing database data
DetachPipe - Remove or save unwanted attachments



-----Original Message-----
From: José Angel [mailto:joseangel@...]
Sent: Thursday, 10 July 2003 12:51 PM
To: textpipe-discuss@yahoogroups.com
Subject: [textpipe-discuss] allow rtf tags


Hello,

I want to do some search and replace in RTF files. This is the
pattern (perl, greedy, other options unselected) I look for:

[^\.]+

ie all text between periods. If I run that TextPipe modifies the RTF
tags, so I need to apply "allow rtf tags" to the search pattern,
right? Well, this is the result:

[(?:(?:\\[0-9a-z]+)+ )?^(?:(?:\\[0-9a-z]+)+ )?\(?:(?:\\[0-9a-z]+)
+ )?.]

And if I try to run that I get the warning msg: "unmatched
parentheses"

What am I doing wrong?

Regards,

José Ángel



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/

Hello,

I want to do some search and replace in RTF files. This is the
pattern (perl, greedy, other options unselected) I look for:

[^\.]+

ie all text between periods. If I run that TextPipe modifies the RTF
tags, so I need to apply "allow rtf tags" to the search pattern,
right? Well, this is the result:

[(?:(?:\\[0-9a-z]+)+ )?^(?:(?:\\[0-9a-z]+)+ )?\(?:(?:\\[0-9a-z]+)
+ )?.]

And if I try to run that I get the warning msg: "unmatched
parentheses"

What am I doing wrong?

Regards,

José Ángel

Try replacing pattern

   :\d{4}

With nothing.

Regards,

Simon Carter, Crystal Software, www.crystalsoftware.com.au, (+61) 3 9888
3104 (GMT+10 hours)
TextPipe Pro - Search and replace on steroids!
DataPipe - Swiss army knife for fixing database data
DetachPipe - Remove or save unwanted attachments



-----Original Message-----
From: Sup W [mailto:sup_w2002@...]
Sent: Tuesday, 8 July 2003 3:57 PM
To: textpipe-discuss@yahoogroups.com
Subject: [textpipe-discuss] Noob needs help with replace filters


I'm trying to setup a filter to remove the last 5
charactors of every line....example


  ($l!eNt_De@^H), xx.146.xx.225:3486
  ($l!eNt_De@^H), xx.146.xx.225:3493
  ($l!eNt_De@^H), xx.146.xx.225:3497
  ($l!eNt_De@^H), xx.146.xx.225:3506
  ($l!eNt_De@^H), xx.146.xx.225:3513
  ($l!eNt_De@^H), xx.146.xx.225:3519
  ($l!eNt_De@^H), xx.146.xx.225:3524
  ($l!eNt_De@^H), xx.146.xx.225:3739
  ($l!eNt_De@^H), xx.146.xx.225:3744
  ($l!eNt_De@^H), xx.146.xx.225:3747
  ($l!eNt_De@^H), xx.146.xx.225:3756

I xx'd the IP but they'er all the same i want to be
able to remove the :#### port number making all the
lines the same inorder to remove dup. lines.
Maybe I overlooked how to use wildcards for find, and
replace with none. Can someone please help?

__________________________________
Do you Yahoo!?
SBC Yahoo! DSL - Now only $29.95 per month!
http://sbc.yahoo.com



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'm trying to setup a filter to remove the last 5
charactors of every line....example


  ($l!eNt_De@^H), xx.146.xx.225:3486
  ($l!eNt_De@^H), xx.146.xx.225:3493
  ($l!eNt_De@^H), xx.146.xx.225:3497
  ($l!eNt_De@^H), xx.146.xx.225:3506
  ($l!eNt_De@^H), xx.146.xx.225:3513
  ($l!eNt_De@^H), xx.146.xx.225:3519
  ($l!eNt_De@^H), xx.146.xx.225:3524
  ($l!eNt_De@^H), xx.146.xx.225:3739
  ($l!eNt_De@^H), xx.146.xx.225:3744
  ($l!eNt_De@^H), xx.146.xx.225:3747
  ($l!eNt_De@^H), xx.146.xx.225:3756

I xx'd the IP but they'er all the same i want to be
able to remove the :#### port number making all the
lines the same inorder to remove dup. lines.
Maybe I overlooked how to use wildcards for find, and
replace with none. Can someone please help?

__________________________________
Do you Yahoo!?
SBC Yahoo! DSL - Now only $29.95 per month!
http://sbc.yahoo.com

Simon,

On the 'Files to Process Tab', when working with all files (*.*) in a folder, it
would be helpful to ONLY look at files modified after a certain date.   I think
the easiest implementation in TextPipe Pro would be to provide a BETWEEN set of
dates to look at files from.  E.g. only look at files MODIFIED between 6 June
2003 and 7 July 2003.


If want to make even nicer:
a) Default the end date of peroid to the current date of operating system
b) Allow option to specify, in addition to 'files MODIFIED', a choice of either
'files MODIFIED', 'files CREATED' or 'files ACCESSED'.

If you think this would be useful, please consider this enhancement.

Cheers,
Allan

Hi Phil,

TextPipe Pro will do this.

First eliminate the REF lines with a Remove matching lines filter.

Then use a series of pattern match replaces to isolate the data you
need. I assume you want all the BIG items on the same line as the
preceding GS record? It shouldn't take too much effort to do this.

Regards,

Simon Carter, Crystal Software, www.crystalsoftware.com.au, (+61) 3 9888
3104 (GMT+10 hours)
TextPipe Pro - Industrial strength text transformation workbench
DataPipe - Swiss army knife for fixing database data
DetachPipe - Remove or save unwanted attachments


-----Original Message-----
From: surfsideflip [mailto:surfsideflip@...]
Sent: Saturday, 28 June 2003 7:39 AM
To: textpipe-discuss@yahoogroups.com
Subject: [textpipe-discuss] Extracting from Multiple Patterns &
Repeating SubPatterns


Afternoon All,

I acquired TextPro only a couple of days ago but already recognize
what an extraordinary tool it is.  I have a problem that I'm not
sure can be solved via pattern matching, replacing, etc.  I have an
EDI file which appears as follows:

         GS*xx*xxx*xxx*YYYYMMDD*xxx*xxxx*x*xxxxxx
         ST*xxx*xxxxxxxxx
--->    BIG*xxxxxxxx*AA12345.01A**xxxxxxx***xx
         REF*xx*xxxxxx
--->    BIG*xxxxxxxx*AA12346.01A**xxxxxxx***xx
         REF*xx*xxxxxx
--->    BIG*xxxxxxxx*AA12347.01A**xxxxxxx***xx
         REF*xx*xxxxxx


I have used "x" as a filler for unimportant alpha-numeric data.
The "*" (asterisks) are literals but could obviously be replaced.
Note the repeating groups initiated by "BIG".  This is simply a
classic header/detail type of layout.

There is piece of data on the line initiated by "GS" that I need to
capture.  In addition, there is data on line(s) initiated by "BIG"
that I need to capture.  The number of times the "BIG" line (or
group) will repeat is 1 or more.  The number of repetitions is
unknown and will vary from one file to the next.

Can TextPro handle this?  I'm not against split/merge techniques or
anything that might accomplish this.

Thanks for your time,

Phil






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/

Phil,

    We are working on your question and you will be answered very soon.

Thanks,
Pedro
GKG SUPPORT







textpipe-discuss@yahoogroups.com wrote (Sat, Jun 28 2003 02:28:26):

> Afternoon All,
>
> I acquired TextPro only a couple of days ago but already recognize
> what an extraordinary tool it is.  I have a problem that I'm not
> sure can be solved via pattern matching, replacing, etc.  I have an
> EDI file which appears as follows:
>
>         GS*xx*xxx*xxx*YYYYMMDD*xxx*xxxx*x*xxxxxx
>         ST*xxx*xxxxxxxxx
> --->    BIG*xxxxxxxx*AA12345.01A**xxxxxxx***xx
>         REF*xx*xxxxxx
> --->    BIG*xxxxxxxx*AA12346.01A**xxxxxxx***xx
>         REF*xx*xxxxxx
> --->    BIG*xxxxxxxx*AA12347.01A**xxxxxxx***xx
>         REF*xx*xxxxxx
>
>
> I have used "x" as a filler for unimportant alpha-numeric data.
> The "*" (asterisks) are literals but could obviously be replaced.
> Note the repeating groups initiated by "BIG".  This is simply a
> classic header/detail type of layout.
>
> There is piece of data on the line initiated by "GS" that I need to
> capture.  In addition, there is data on line(s) initiated by "BIG"
> that I need to capture.  The number of times the "BIG" line (or
> group) will repeat is 1 or more.  The number of repetitions is
> unknown and will vary from one file to the next.
>
> Can TextPro handle this?  I'm not against split/merge techniques or
> anything that might accomplish this.
>
> Thanks for your time,
>
> Phil

Afternoon All,

I acquired TextPro only a couple of days ago but already recognize
what an extraordinary tool it is.  I have a problem that I'm not
sure can be solved via pattern matching, replacing, etc.  I have an
EDI file which appears as follows:

         GS*xx*xxx*xxx*YYYYMMDD*xxx*xxxx*x*xxxxxx
         ST*xxx*xxxxxxxxx
--->    BIG*xxxxxxxx*AA12345.01A**xxxxxxx***xx
         REF*xx*xxxxxx
--->    BIG*xxxxxxxx*AA12346.01A**xxxxxxx***xx
         REF*xx*xxxxxx
--->    BIG*xxxxxxxx*AA12347.01A**xxxxxxx***xx
         REF*xx*xxxxxx


I have used "x" as a filler for unimportant alpha-numeric data.
The "*" (asterisks) are literals but could obviously be replaced.
Note the repeating groups initiated by "BIG".  This is simply a
classic header/detail type of layout.

There is piece of data on the line initiated by "GS" that I need to
capture.  In addition, there is data on line(s) initiated by "BIG"
that I need to capture.  The number of times the "BIG" line (or
group) will repeat is 1 or more.  The number of repetitions is
unknown and will vary from one file to the next.

Can TextPro handle this?  I'm not against split/merge techniques or
anything that might accomplish this.

Thanks for your time,

Phil

Hi Alex,

All filters run simultaneously. That is why TextPipe doesn't need to use
temporary files at all.

It looks like you will have to run the two scripts independantly,
writing data somewhere else (like in the system registry, or a data
file) to maintain state information between them.

Script filters (different to subfilters) are given data line by line,
because that's usually the easiest way to process it. If you want to
process the whole file in one shot you will have to buffer it yourself
inside the script (there are examples of this in the VBScript folder).
Restriction filters often but not always pass data to their subfilters
line-by-line.

Regards,

Simon Carter, Crystal Software, www.crystalsoftware.com.au, (+61) 3 9888
3104 (GMT+10 hours)
TextPipe Pro - Industrial strength text transformation workbench
DataPipe - Swiss army knife for fixing database data
DetachPipe - Remove or save unwanted attachments


-----Original Message-----
From: Alex [mailto:bravomanaok@...]
Sent: Saturday, 7 June 2003 12:34 AM
To: textpipe-discuss@yahoogroups.com
Subject: [textpipe-discuss] Re: Can I dinamically create split file
filters in text pipe?


I created 2 VB scripts now and 1 split script:

1. Collects misc data, identifies what lines should be file splits.
After processing (EndJob event) I save information in global variable.

2. Reads global variable (StartJob event) and goes through the file
to populate file splits.

3. Split filter reads file split marks and breaks up the file.

Here's the problem that I'm having:
1 & 2 script run simultaniously. Even through this is the order I
have scripts in the filters view screen, both VB scripts run together
line, by line. That's why 2nd script doesn't populate file breaks
(because variable it's trying to read isn't populated yet) and file
never gets split up.

What do I have to do to make 2nd script run only after 1st script is
finished processing?

PS. It seems that subfilters can only process line by line. And I
need whole file to be processed after I'm done with processing it 1st
time.


--- In textpipe-discuss@yahoogroups.com, "Simon Carter, Crystal
Software" <mail@c...> wrote:
> Hi Alex,
>
> You can't split the file using the VBScript filter, although we have
> been considering requests to be able to split and/or rename the file
> from VB. Sounds like it will happen, although exactly how is the
> question :-)
>
> If you use VB to identify where to split the file, you could get
that VB
> script to load up a second filter and modify the file. Remember
that TP
> can be controlled from a script as well, so you could use the Script
> filter to control another TP filter.
>
> Regards,
>
> Simon Carter, Crystal Software, www.crystalsoftware.com.au, (+61) 3
9888
> 3104 (GMT+10 hours)
> TextPipe Pro - Industrial strength text transformation workbench
> DataPipe - Swiss army knife for fixing database data
> DetachPipe - Remove or save unwanted attachments
>
>
> -----Original Message-----
> From: Alex [mailto:bravomanaok@y...]
> Sent: Friday, 6 June 2003 1:42 AM
> To: textpipe-discuss@yahoogroups.com
> Subject: [textpipe-discuss] Can I dinamically create split file
filters
> in text pipe?
>
>
> I need to be able to read through the file identify what lines
should
> I use to split the file, then I need to create n number of split
> filters and break up original file. I don't know if I can do it all
> in the textpipe VBScript filter?..
>
> Anybody has any ideas? Samples?
>
> As an alternative I thought of using Textpipe to identify where I
> will split files and save that information in some kind of INI
file.
> And then in VB using Textpipe Com interface break up that file
using
> information stored in INI file.
>
>
>
> 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/



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 created 2 VB scripts now and 1 split script:

1. Collects misc data, identifies what lines should be file splits.
After processing (EndJob event) I save information in global variable.

2. Reads global variable (StartJob event) and goes through the file
to populate file splits.

3. Split filter reads file split marks and breaks up the file.

Here's the problem that I'm having:
1 & 2 script run simultaniously. Even through this is the order I
have scripts in the filters view screen, both VB scripts run together
line, by line. That's why 2nd script doesn't populate file breaks
(because variable it's trying to read isn't populated yet) and file
never gets split up.

What do I have to do to make 2nd script run only after 1st script is
finished processing?

PS. It seems that subfilters can only process line by line. And I
need whole file to be processed after I'm done with processing it 1st
time.


--- In textpipe-discuss@yahoogroups.com, "Simon Carter, Crystal
Software" <mail@c...> wrote:
> Hi Alex,
>
> You can't split the file using the VBScript filter, although we have
> been considering requests to be able to split and/or rename the file
> from VB. Sounds like it will happen, although exactly how is the
> question :-)
>
> If you use VB to identify where to split the file, you could get
that VB
> script to load up a second filter and modify the file. Remember
that TP
> can be controlled from a script as well, so you could use the Script
> filter to control another TP filter.
>
> Regards,
>
> Simon Carter, Crystal Software, www.crystalsoftware.com.au, (+61) 3
9888
> 3104 (GMT+10 hours)
> TextPipe Pro - Industrial strength text transformation workbench
> DataPipe - Swiss army knife for fixing database data
> DetachPipe - Remove or save unwanted attachments
>
>
> -----Original Message-----
> From: Alex [mailto:bravomanaok@y...]
> Sent: Friday, 6 June 2003 1:42 AM
> To: textpipe-discuss@yahoogroups.com
> Subject: [textpipe-discuss] Can I dinamically create split file
filters
> in text pipe?
>
>
> I need to be able to read through the file identify what lines
should
> I use to split the file, then I need to create n number of split
> filters and break up original file. I don't know if I can do it all
> in the textpipe VBScript filter?..
>
> Anybody has any ideas? Samples?
>
> As an alternative I thought of using Textpipe to identify where I
> will split files and save that information in some kind of INI
file.
> And then in VB using Textpipe Com interface break up that file
using
> information stored in INI file.
>
>
>
> 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 Alex,

You can't split the file using the VBScript filter, although we have
been considering requests to be able to split and/or rename the file
from VB. Sounds like it will happen, although exactly how is the
question :-)

If you use VB to identify where to split the file, you could get that VB
script to load up a second filter and modify the file. Remember that TP
can be controlled from a script as well, so you could use the Script
filter to control another TP filter.

Regards,

Simon Carter, Crystal Software, www.crystalsoftware.com.au, (+61) 3 9888
3104 (GMT+10 hours)
TextPipe Pro - Industrial strength text transformation workbench
DataPipe - Swiss army knife for fixing database data
DetachPipe - Remove or save unwanted attachments


-----Original Message-----
From: Alex [mailto:bravomanaok@...]
Sent: Friday, 6 June 2003 1:42 AM
To: textpipe-discuss@yahoogroups.com
Subject: [textpipe-discuss] Can I dinamically create split file filters
in text pipe?


I need to be able to read through the file identify what lines should
I use to split the file, then I need to create n number of split
filters and break up original file. I don't know if I can do it all
in the textpipe VBScript filter?..

Anybody has any ideas? Samples?

As an alternative I thought of using Textpipe to identify where I
will split files and save that information in some kind of INI file.
And then in VB using Textpipe Com interface break up that file using
information stored in INI file.



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 need to be able to read through the file identify what lines should
I use to split the file, then I need to create n number of split
filters and break up original file. I don't know if I can do it all
in the textpipe VBScript filter?..

Anybody has any ideas? Samples?

As an alternative I thought of using Textpipe to identify where I
will split files and save that information in some kind of INI file.
And then in VB using Textpipe Com interface break up that file using
information stored in INI file.

Hi Sean,

Are you using TextPipe 6.5.1?

Regards,

Simon Carter, Crystal Software, www.crystalsoftware.com.au, (+61) 3 9888
3104 (GMT+10 hours)
TextPipe Pro - Industrial strength text transformation workbench
DataPipe - Swiss army knife for fixing database data
DetachPipe - Remove or save unwanted attachments


-----Original Message-----
From: slewis1200 [mailto:slewis@...]
Sent: Thursday, 29 May 2003 12:14 AM
To: textpipe-discuss@yahoogroups.com
Subject: [textpipe-discuss] Re: moving lines of text


Simon,

Thanks for your help but when I try to open the filter you sent I
get an error message that reads:

Error reading TFilterList.FilterList: Errpr reading
TVersion.Version: Invalid property value

Do you have any suggestions as to what I should do?

Thanks,
Sean


--- In textpipe-discuss@yahoogroups.com, "Simon Carter, Crystal
Software" <mail@c...> wrote:
> Hi Shawn,
>
> The basic approach is to use a line restriction filter to copy the
lines
> into a global variable (using a VBScript sub filter). Then you
have to
> use another VBScript filter to buffer the entire document, and at
the
> end (in the endFile() function), output the entire file with the
desired
> lines at the top.
>
> The attached filter is very similar, except that
> 1) It uses a pattern to gather text into a global variable (you
need a
> line restriction filter)
> 2) It outputs the global variable as a left margin (you need it at
the
> top of the file)
>
> Regards,
>
> Simon Carter, Crystal Software, www.crystalsoftware.com.au, (+61)
3 9888
> 3104 (GMT+10 hours)
> TextPipe Pro - Industrial strength text transformation workbench
> DataPipe - Swiss army knife for fixing database data
> DetachPipe - Remove or save unwanted attachments
>
>
> -----Original Message-----
> From: slewis1200 [mailto:slewis@i...]
> Sent: Wednesday, 21 May 2003 6:21 AM
> To: textpipe-discuss@yahoogroups.com
> Subject: [textpipe-discuss] moving lines of text
>
>
> Does anyone know how to select certain lines of text and move them
> to the top of the document?  Thanks for your help.



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/

Simon,

Thanks for your help but when I try to open the filter you sent I
get an error message that reads:

Error reading TFilterList.FilterList: Errpr reading
TVersion.Version: Invalid property value

Do you have any suggestions as to what I should do?

Thanks,
Sean


--- In textpipe-discuss@yahoogroups.com, "Simon Carter, Crystal
Software" <mail@c...> wrote:
> Hi Shawn,
>
> The basic approach is to use a line restriction filter to copy the
lines
> into a global variable (using a VBScript sub filter). Then you
have to
> use another VBScript filter to buffer the entire document, and at
the
> end (in the endFile() function), output the entire file with the
desired
> lines at the top.
>
> The attached filter is very similar, except that
> 1) It uses a pattern to gather text into a global variable (you
need a
> line restriction filter)
> 2) It outputs the global variable as a left margin (you need it at
the
> top of the file)
>
> Regards,
>
> Simon Carter, Crystal Software, www.crystalsoftware.com.au, (+61)
3 9888
> 3104 (GMT+10 hours)
> TextPipe Pro - Industrial strength text transformation workbench
> DataPipe - Swiss army knife for fixing database data
> DetachPipe - Remove or save unwanted attachments
>
>
> -----Original Message-----
> From: slewis1200 [mailto:slewis@i...]
> Sent: Wednesday, 21 May 2003 6:21 AM
> To: textpipe-discuss@yahoogroups.com
> Subject: [textpipe-discuss] moving lines of text
>
>
> Does anyone know how to select certain lines of text and move them
> to the top of the document?  Thanks for your help.

hello i have see this
answer for my probleme
what is the way for
converting this fot textpipe
thanks

> #!/usr/bin/perl -w
> %f2e = (
> R => K,
> D => Q,
> T => R,
> F => B,
> C => N
> );
>
> while (<>) {
>     s/([RDTFC])([a-h1-8]?x?[a-h][1-8])/$f2e{$1}$2/g;
>     s/([a-h][18]=)([DTFC])/$1$f2e{$2}/g;
>     print;
> }

Hi Aimee,

If you plan to retain your original Word document format, then you can't
use TextPipe for this.

However, if you first convert the Word documents to RTF format then
there is a good chance that you can use TextPipe to do this. If you're
importing into askSam, I believe the documents get converted to RTF
anyway, so you could use our Word macro to convert all the documents to
RTF first.

As for the date field, you'll have to send me a copy of one of your Word
documents (to me directly, not to the group), and I will see how it can
be done.

If you want the resulting documents in Word format, you can use TextPipe
Pro (not TextPipe for askSam) combined with our WordPipe product - this
will allow you to convert DOC->RTF, run TextPipe Pro over the RTF, and
the convert RTF->Word.

Regards,

Simon Carter, Crystal Software, www.crystalsoftware.com.au, (+61) 3 9888
3104 (GMT+10 hours)
TextPipe Pro - Industrial strength text transformation workbench
DataPipe - Swiss army knife for fixing database data
DetachPipe - Remove or save unwanted attachments


-----Original Message-----
From: aimeefitz [mailto:afitzgerald@...]
Sent: Friday, 23 May 2003 1:21 AM
To: textpipe-discuss@yahoogroups.com
Subject: [textpipe-discuss] Re: File Date swapping with embedded dates


Troy -

Thanks for the comment - hmm.  That will be a problem.  I thought
that the created date was a fixed date.  Here's my concern:  say a
file created in 1998 was accessed in 2000, and the person saved the
file at that time.  The data in the file is 1998 data, but the
modified date will show 2000.  When you open the file, the dates in
the report will reflect today's date.

It's a mess - the person creating the research template did not
understand the way Word handles those date fields!

Anyway, thanks again for the food for thought.

Cheers,

Aimee :)

--- In textpipe-discuss@yahoogroups.com, "Troy Larson"
<ntevidence@a...> wrote:
> Aimee,
>
> I can't help you with the Textpipe filter, but I will point out
that you
> probably do not want to use the file creation date to establish the
original
> date in the Word document.
>
> The creation date can be updated by copying or moving the files, so
it may
> not reflect the real creation date of a Word document.
>
> The more accurate date to use would be the last modified date.  The
last
> modified date denotes to last time the file was saved.
>
> Troy Larson
>
> -----Original Message-----
> From: aimeefitz [mailto:afitzgerald@l...]
> Sent: Wednesday, May 21, 2003 4:01 PM
> To: textpipe-discuss@yahoogroups.com
> Subject: [textpipe-discuss] File Date swapping with embedded dates
>
>
> Hi everyone -
>
> I just installed TextPipe yesterday to go with my new AskSam
> database!  I am now thinking that TextPipe won't let me do what I
had
> hoped, based on the filters I saw available in the software.
>
> We have hundreds of research reports in Word that have
the "current"
> date field in them, rather than the date they were actually
created.
> The creates a problem because whenever they're opened, however old
> they are, the date fields update to today's date. When we find this
> manually, we go in, delete that date field and enter the date based
> on the file creation date in the properties.
>
> I would like to automate this across the board - can TextPipe
> identify the date from the properties then apply that date where
> there is a "current" date field?
>
> How would I go about creating that filter?
>
> Thank you,
>
> Aimee :)
>
> Aimee S. Fitzgerald, MLIS
> Director of Prospect Research
> Loyola Marymount University
> One LMU Drive
> University Hall, Suite 2800
> Los Angeles, CA 90045-2659
> (310) 338-1830
> afitzgerald@l...
>
>
>
> Yahoo! Groups Sponsor
>
>
<http://rd.yahoo.com/M=251812.3170658.4537139.1261774/D=egroupweb/S=17
051447
> 08:HM/A=1564416/R=0/*http://www.netflix.com/Default?
mqso=60164797&partid=317
> 0658>
>
> <http://us.adserver.yahoo.com/l?
M=251812.3170658.4537139.1261774/D=egroupmai
> l/S=:HM/A=1564416/rand=798257805>
>
> 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
> <http://docs.yahoo.com/info/terms/> .



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/

Troy -

Thanks for the comment - hmm.  That will be a problem.  I thought
that the created date was a fixed date.  Here's my concern:  say a
file created in 1998 was accessed in 2000, and the person saved the
file at that time.  The data in the file is 1998 data, but the
modified date will show 2000.  When you open the file, the dates in
the report will reflect today's date.

It's a mess - the person creating the research template did not
understand the way Word handles those date fields!

Anyway, thanks again for the food for thought.

Cheers,

Aimee :)

--- In textpipe-discuss@yahoogroups.com, "Troy Larson"
<ntevidence@a...> wrote:
> Aimee,
>
> I can't help you with the Textpipe filter, but I will point out
that you
> probably do not want to use the file creation date to establish the
original
> date in the Word document.
>
> The creation date can be updated by copying or moving the files, so
it may
> not reflect the real creation date of a Word document.
>
> The more accurate date to use would be the last modified date.  The
last
> modified date denotes to last time the file was saved.
>
> Troy Larson
>
> -----Original Message-----
> From: aimeefitz [mailto:afitzgerald@l...]
> Sent: Wednesday, May 21, 2003 4:01 PM
> To: textpipe-discuss@yahoogroups.com
> Subject: [textpipe-discuss] File Date swapping with embedded dates
>
>
> Hi everyone -
>
> I just installed TextPipe yesterday to go with my new AskSam
> database!  I am now thinking that TextPipe won't let me do what I
had
> hoped, based on the filters I saw available in the software.
>
> We have hundreds of research reports in Word that have
the "current"
> date field in them, rather than the date they were actually
created.
> The creates a problem because whenever they're opened, however old
> they are, the date fields update to today's date. When we find this
> manually, we go in, delete that date field and enter the date based
> on the file creation date in the properties.
>
> I would like to automate this across the board - can TextPipe
> identify the date from the properties then apply that date where
> there is a "current" date field?
>
> How would I go about creating that filter?
>
> Thank you,
>
> Aimee :)
>
> Aimee S. Fitzgerald, MLIS
> Director of Prospect Research
> Loyola Marymount University
> One LMU Drive
> University Hall, Suite 2800
> Los Angeles, CA 90045-2659
> (310) 338-1830
> afitzgerald@l...
>
>
>
> Yahoo! Groups Sponsor
>
>
<http://rd.yahoo.com/M=251812.3170658.4537139.1261774/D=egroupweb/S=17
051447
> 08:HM/A=1564416/R=0/*http://www.netflix.com/Default?
mqso=60164797&partid=317
> 0658>
>
> <http://us.adserver.yahoo.com/l?
M=251812.3170658.4537139.1261774/D=egroupmai
> l/S=:HM/A=1564416/rand=798257805>
>
> 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
> <http://docs.yahoo.com/info/terms/> .

Hi Shawn,

The basic approach is to use a line restriction filter to copy the lines
into a global variable (using a VBScript sub filter). Then you have to
use another VBScript filter to buffer the entire document, and at the
end (in the endFile() function), output the entire file with the desired
lines at the top.

The attached filter is very similar, except that
1) It uses a pattern to gather text into a global variable (you need a
line restriction filter)
2) It outputs the global variable as a left margin (you need it at the
top of the file)

Regards,

Simon Carter, Crystal Software, www.crystalsoftware.com.au, (+61) 3 9888
3104 (GMT+10 hours)
TextPipe Pro - Industrial strength text transformation workbench
DataPipe - Swiss army knife for fixing database data
DetachPipe - Remove or save unwanted attachments


-----Original Message-----
From: slewis1200 [mailto:slewis@...]
Sent: Wednesday, 21 May 2003 6:21 AM
To: textpipe-discuss@yahoogroups.com
Subject: [textpipe-discuss] moving lines of text


Does anyone know how to select certain lines of text and move them
to the top of the document?  Thanks for your help.

-----Original Message-----
From: aimeefitz [mailto:afitzgerald@...]
Sent: Wednesday, May 21, 2003 4:01 PM
To: textpipe-discuss@yahoogroups.com
Subject: [textpipe-discuss] File Date swapping with embedded dates

Hi everyone -

I just installed TextPipe yesterday to go with my new AskSam
database!  I am now thinking that TextPipe won't let me do what I had
hoped, based on the filters I saw available in the software.

We have hundreds of research reports in Word that have the "current"
date field in them, rather than the date they were actually created.
The creates a problem because whenever they're opened, however old
they are, the date fields update to today's date. When we find this
manually, we go in, delete that date field and enter the date based
on the file creation date in the properties.

I would like to automate this across the board - can TextPipe
identify the date from the properties then apply that date where
there is a "current" date field?

How would I go about creating that filter?

Thank you,

Aimee :)

Aimee S. Fitzgerald, MLIS
Director of Prospect Research
Loyola Marymount University
One LMU Drive
University Hall, Suite 2800
Los Angeles, CA 90045-2659
(310) 338-1830
afitzgerald@...



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 everyone -

I just installed TextPipe yesterday to go with my new AskSam
database!  I am now thinking that TextPipe won't let me do what I had
hoped, based on the filters I saw available in the software.

We have hundreds of research reports in Word that have the "current"
date field in them, rather than the date they were actually created.
The creates a problem because whenever they're opened, however old
they are, the date fields update to today's date. When we find this
manually, we go in, delete that date field and enter the date based
on the file creation date in the properties.

I would like to automate this across the board - can TextPipe
identify the date from the properties then apply that date where
there is a "current" date field?

How would I go about creating that filter?

Thank you,

Aimee :)

Aimee S. Fitzgerald, MLIS
Director of Prospect Research
Loyola Marymount University
One LMU Drive
University Hall, Suite 2800
Los Angeles, CA 90045-2659
(310) 338-1830
afitzgerald@...