Column to new text file and back

Get help with installation and running here.

Moderators: DataMystic Support, Moderators

Ronbot_1
Posts: 2
Joined: Sun May 08, 2011 3:59 am

Column to new text file and back

Postby Ronbot_1 » Sun May 08, 2011 4:10 am

Hello,
A work with large text coded files were each position in a line has distinctive meaning. The file is not csv.
I need to copy the content of 2 specific colums to a new file (preferably a csv, say e.g. tmp.csv) , use that in Excel to make changes and then insert these back into the same file, replacing the original content in those columns.

I have been able to select the correct lines and colums without any problem.

Restrict to lines matching [^04]
Copy columns:10 columns starting at column 85 copy to 15

but cannot export to a external file and then import the changes.

How can Texpipe help ?

Regards
Ron

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

Re: Column to new text file and back

Postby DataMystic Support » Mon May 09, 2011 11:34 am

Hi Ron,

You can use Filters\Special\Secondary output filter to send the output to a new file.

What changes do you need to make in Excel? You should be able to use Filters\Special\Script (VBScript,JScript...) to make any changes, perform calculations etc, or even search/replace filters inside the restriction.
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

Ronbot_1
Posts: 2
Joined: Sun May 08, 2011 3:59 am

Re: Column to new text file and back

Postby Ronbot_1 » Tue May 10, 2011 4:31 am

DataMystic Support wrote:Hi Ron,

You can use Filters\Special\Secondary output filter to send the output to a new file.

What changes do you need to make in Excel? You should be able to use Filters\Special\Script (VBScript,JScript...) to make any changes, perform calculations etc, or even search/replace filters inside the restriction.


Thanks for the reply. I've used the above filter to output to a file. Now I have trouble getting the changed columns back into the original file (I can't find an ADD columns from file filter). Is there any other way ?

The Excel output is only temporary. I must be able to make random changes to specific parts. Once I get more acquinted I can start using the jscripts.

Regards
Ron

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

Re: Column to new text file and back

Postby DataMystic Support » Tue May 10, 2011 9:01 am

Hi Ron,

Your best bet is to output every line, not just matching ones, and then use the Filters\Add\Add text side-by-side to add the changes back in.

You will then need to Filters\Remove\Columns the original columns, and Filters\Special\Move columns/fields\Move columns into the right position.
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: No registered users and 2 guests