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.
Noob Question - Line Count
Moderators: DataMystic Support, Moderators, DataMystic Support, Moderators, DataMystic Support, Moderators
- DataMystic Support
- Site Admin
- Posts: 2227
- Joined: Mon Jun 30, 2003 12:32 pm
- Location: Melbourne, Australia
- Contact:
Re: Noob Question - Line Count
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.
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.