Textpipe File manipulation

Get help with installation and running here.

Moderators: DataMystic Support, Moderators

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

Textpipe File manipulation

Postby Unifocus » Wed Sep 07, 2011 12:34 am

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: 2154
Joined: Mon Jun 30, 2003 12:32 pm
Location: Melbourne, Australia
Contact:

Re: Textpipe File manipulation

Postby DataMystic Support » Thu Sep 08, 2011 10:29 am

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.
Regards,

Simon Carter, http://DataMystic.com/forums/index.php
http://PredictBGL.com - Insulin dose calculator for Type 1 diabetes
http://DownloadPipe.com - 250,000 free software downloads
http://DetachPipe.com - send huge email attachments


Return to “TextPipe Tips and Tricks, Questions and Support”

Who is online

Users browsing this forum: Baidu [Spider] and 1 guest