column Question

brittonalmy · Post by **brittonalmy** » Sun Apr 22, 2007 7:22 am

I have a file with multiple columns and I would like to split it into multiple files after every fifth column.

Any help is appreaciated.

Post by **DataMystic Support** » Thu Apr 26, 2007 9:29 am

You will need to do this in multiple steps, with the Filters\Remove\Columns to remove a different set of unwanted columns each time.

brittonalmy · Post by **brittonalmy** » Thu Apr 26, 2007 12:42 pm

I understand the overall process of splitting the columns, I am having difficulty export the columns I split to a new file. Any suggestions.

Post by **DataMystic Support** » Thu Apr 26, 2007 12:53 pm

File A goes to a different output file each time - just change the Output Filter setting to direct output to a new file.

This process can be automated from a JScript script - see File Menu\Export for the options.