Split and Merging files

mccrackr · Post by **mccrackr** » Sat Mar 12, 2005 2:34 pm

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

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.