Split and Merging files

Get help with installation and running here.

Moderators: DataMystic Support, Moderators

Post Reply

Split and Merging files

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

Post by 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

Post Reply

Who is online

Users browsing this forum: No registered users and 2 guests