Consolidating data into a couple of lines

Get help with installation and running here.

Moderators: DataMystic Support, Moderators

Tractebel

Consolidating data into a couple of lines

Postby Tractebel » Thu Sep 30, 2004 4:59 am

We have a csv file broken out into multiple sections......

Hour,1,2,3,4,5
Temp,50,51,52,53

Hour,6,7,8,9,10
Temp,50,51,52,53

Hour,11,12,13,14,15
Temp,50,51,52,53

Id like to move the data to be only on two lines.

Hour,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15
Temp,50,51,52,53,50,51,52,53,50,51,52,53

Is there an existing template or something to do this? We have the registered pro version of textpipe pro fyi if that matters.

-Tractebel

User avatar
DataMystic Support
Site Admin
Posts: 2138
Joined: Mon Jun 30, 2003 12:32 pm
Location: Melbourne, Australia
Contact:

Postby DataMystic Support » Wed Oct 06, 2004 11:51 am

The best way would be to sort all the lines so all the hours/Temp go together, then use an EasyPattern to restrict to all lines starting with 'Hour', and inside it, remove all
'Hour', repalce all line feeds with commas, then add a Header to put 'Hour' back in again. Do the same for Temp.
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: Yahoo [Bot] and 2 guests