Textpipe File manipulation

Get help with installation and running here.

Moderators: DataMystic Support, Moderators, DataMystic Support, Moderators, DataMystic Support, Moderators

Post Reply
Unifocus
Posts: 1
Joined: Wed Sep 07, 2011 12:07 am

Textpipe File manipulation

Post by Unifocus »

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
User avatar
DataMystic Support
Site Admin
Posts: 2227
Joined: Mon Jun 30, 2003 12:32 pm
Location: Melbourne, Australia
Contact:

Re: Textpipe File manipulation

Post by DataMystic Support »

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.
Post Reply