DataMystic

Hi,

As previously mentioned, I am new to textpipe. I am formatting a delimitted file (just one file at a time). I would like to add a footer with a tally of a specific type of line.

Say file looks like so:

Header|fdsfdas|dsads
D|xxxx|yyyy
D|xxxx|yyyy
D|xxxx|yyyy
Footer|linecount|

I need to tally the lines beginning with D|

Is it possible to store this value as a global variable?

Any help would be greatly appreciated.

Yes - use a Filters\Restrict\Matching lines (grep) so that you only count matching lines, and INSIDE this, add a Filters\Special\Script (VBScript,JScript...) to simply keep a tally of the number of lines.

Then at the bottom of your filter list, add another Filters\Special\Script (VBScript,JScript...), but this time to output the count in the endFile() function.