We have a small number of files of format [url removed, login to view] on our web server.
We want a script in which we can specify the file names of the files. Specify the column delimiter (e.g. tab or pipe). Specify the columns that we want deleted. This info would be permanently stored in the script. Then when we run the script, it deletes the specified columns from the files. We are doing this to reduce unwanted data in the files and make their size more managable.
The second thing we want the script to do is to divide the file in to more than one file of X number of rows each. We should be able to specify X. So if we enter 10000 in the script then the file is divide in to files of 10000 rows each. The last file will ofcourse be less than 10000 rows.