Split and Merging files

Get help with installation and running here.

Moderators: DataMystic Support, Moderators, DataMystic Support, Moderators, DataMystic Support, Moderators

Post Reply
mccrackr

Split and Merging files

Post by mccrackr »

Hello,

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

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

Post by DataMystic Support »

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.
Regards,

Simon Carter, https://www.DataMystic.com
https://www.JadeDiabetes.com - Insulin dose calculator for Type 1 diabetes
https://www.DownloadPipe.com - 250,000 free software downloads
Post Reply