Processing text files

FinalBuilder Discussion
1

Hi,

I'm very new to FinalBuilder 7 so this may be a dumb question but here goes anyway:

As part of my product build I need to run a whole load of SQL statements in a particular order. The way we've done this is to have an @order.txt file in each folder which tells our current application what order to process the files in.

The file in the root folder contains the names of the folders that we need to process.

So I've created a "Read Text File" action that parses the folder list. What I need to do now is for each entry I need to then run another action that will:

1. Open the @order.txt file in the folder that is being processed;

2. Read the lines and execute the SQL script <-- this bit I can do using the OnReadLine event.

 

The problem I'm having is that I can't figure out how to create the second action that will take an input from the first action and process - and do this until there are no rows left in the first action. If that makes any sense at all?

Any help would be greatly appreciated.

Cheers,

Dan.

2

You can use a List Iterator action to process the lines, so Read Text File into a variable, the List iterator with the list of items set to %yourvariable% where yourvariable is the variable you read the text file into. Then place any actions you want to execute on each line as children of the iterator action.

3

I have attached a simple example.