DataMystic

I need textpipe to output a file where it populates the first column NAME with the last populated first column NAME above it wherever the first column is -----.

I receive an excel file with three columns follows:
Peter Knives 2
------ Forks 3
------ Spoons 1
Mark Forks 1
John Knives 4
------ Spoons 2
Bruce Forks 1

I need it to come out of textpipe as:
Peter Knives 2
Peter Forks 3
Peter Spoons 1
Mark Forks 1
John Knives 4
John Spoons 2
Bruce Forks 1

However, the file only populates a row if someone used the silverware that day so that changes how many rows it has each day. Here is the second days file:
Peter Knives 2
Mark Knives 1
------ Forks 3
------- Spoons 1
John Knives 4
------ Spoons 2
------ Forks 3
Bruce Knives 2


Which should look like this after going through textpipe:
Peter Knives 2
Mark Knives 1
Mark Forks 3
Mark Spoons 1
John Knives 4
John Spoons 2
John Forks 3
Burce Knives 2

Can textpipe manipulate a file in this way?
I use Textpipe Pro 8.1.7

Using TextPipe 8.9.5 (the current version), you can use a Capture Filter to capture the value in the first column and then re-output it.

Let me know when you've upgraded and we can send you the script for it - your version is too old to support this.