Stipping header & footer

Automise Discussion
1

I'm working on a project to strip the header and footer off a file after verifying the footer contains the correct record count in the file. I thought this would be fairly simple to do a File Contents Iterator or List Iterator, checking the ListItem Index for the first and last Index to prevent writing those two records to a new file.

I can't seem to get a reference the the Action.ListOfItems.Count property on the Iterator action to know when I'm at the footer record.

Any suggestions?

JM

2

Hi Joel

You will need to use some script on this one. Add an Automise project variable to hold the count, then on the File Contents Iterator, select the select the Script Editor tab and switch to the OnFirstRun script, and add the following (Javascript)

MYCOUNTVARIABLE = Action.IterationCount;

Then you can reference the MYCOUNTVARIABLE in other actions.