DataMystic

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

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.