Copy and paste/insert

Get help with installation and running here.

Moderators: DataMystic Support, Moderators

access1denied
Posts: 10
Joined: Wed Apr 03, 2013 4:40 am

Copy and paste/insert

Postby access1denied » Sat Feb 04, 2017 10:24 am

I have a file that contains data in the in the following order

12345 Data Data Data Data Data Data Data Data Data Data Data Data Data Data Data Data
Data Data Data Data Data Data Data Data Data Data Data Data Data Data Data Data
Data Data Data Data Data Data Data Data Data Data Data Data Data Data Data Data
Data Data Data Data Data Data Data Data Data Data Data Data Data Data Data Data
Data Data Data Data Data Data Data Data Data Data Data Data Data Data Data Data
------------------------------------------------------------------------------------------------------------------------------------------------------------------------
45454 Data Data Data Data Data Data Data Data Data Data Data Data Data Data Data Data
Data Data Data Data Data Data Data Data Data Data Data Data Data Data Data Data
Data Data Data Data Data Data Data Data Data Data Data Data Data Data Data Data
Data Data Data Data Data Data Data Data Data Data Data Data Data Data Data Data
Data Data Data Data Data Data Data Data Data Data Data Data Data Data Data Data
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------

I need to use textpipe to copy column 1-5 and paste (insert) it at each line until the end of the dashes ------- then loop the process again so the result will be:

12345 Data Data Data Data Data Data Data Data Data Data Data Data Data Data Data Data
12345 Data Data Data Data Data Data Data Data Data Data Data Data Data Data Data Data
12345 Data Data Data Data Data Data Data Data Data Data Data Data Data Data Data Data
12345 Data Data Data Data Data Data Data Data Data Data Data Data Data Data Data Data
12345 Data Data Data Data Data Data Data Data Data Data Data Data Data Data Data Data
------------------------------------------------------------------------------------------------------------------------------------------------------------------------
45454 Data Data Data Data Data Data Data Data Data Data Data Data Data Data Data Data
45454 Data Data Data Data Data Data Data Data Data Data Data Data Data Data Data Data
45454 Data Data Data Data Data Data Data Data Data Data Data Data Data Data Data Data
45454 Data Data Data Data Data Data Data Data Data Data Data Data Data Data Data Data
45454 Data Data Data Data Data Data Data Data Data Data Data Data Data Data Data Data

access1denied
Posts: 10
Joined: Wed Apr 03, 2013 4:40 am

Re: Copy and paste/insert

Postby access1denied » Mon Feb 06, 2017 3:32 pm

I was informed that TextPipe is not able to handle such a complex process... Still a good product

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

Re: Copy and paste/insert

Postby DataMystic Support » Tue Feb 14, 2017 7:24 am

That's incorrect, not sure who told you that.

TextPipe can easily handle this by grouping all the lines together between dashes, extracting the first 5 characters, and adding a left margin.

Are you a current customer?
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: Bing [Bot] and 3 guests