Split and Merging files

Get help with installation and running here.

Moderators: DataMystic Support, Moderators


Split and Merging files

Postby mccrackr » Sat Mar 12, 2005 2:34 pm


Is it possible to

1) Split an input file into 2 files where each file has a portion of the data for each input record. i.e., column 1-5 in file 1 and column 6-10 in file 2

2) Combine 2 files, record by record, based on a matching key


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

Postby DataMystic Support » Sat Mar 12, 2005 9:05 pm

1. Only by using 2 filters - one to output columns 1-5, and discard columns 6-10, and a second filter to do the opposite.

2. Only using VBScript.

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