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.
column Question
Moderators: DataMystic Support, Moderators
- DataMystic Support
- Site Admin
- Posts: 2229
- Joined: Mon Jun 30, 2003 12:32 pm
- Location: Melbourne, Australia
- Contact:
You will need to do this in multiple steps, with the Filters\Remove\Columns to remove a different set of unwanted columns each time.
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
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
-
- Posts: 2
- Joined: Sun Apr 22, 2007 7:03 am
Columns
I understand the overall process of splitting the columns, I am having difficulty export the columns I split to a new file. Any suggestions.
- DataMystic Support
- Site Admin
- Posts: 2229
- Joined: Mon Jun 30, 2003 12:32 pm
- Location: Melbourne, Australia
- Contact:
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.
This process can be automated from a JScript script - see File Menu\Export for the options.
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
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