This project will take an existing spreadsheet (samples included in .xls and .txt tab delimited format) and split the information into many cells. It will also create a new field based on the information and order within the cells. The resulting file can be .txt, .xls, .csv.
Coders must deliver an executable file or program that will allow me to run this code on the full files on my own computer. In addition to the file, very specific instructions must be sent on how to run the file/expected results/etc. (i.e. instructions suitable for a computer novice)
Please note that this is not an appropriate project for data entry. The actual files are extremely large (>100,000 records that must be split in the original files; results will create files of >500,000 records).
I have included a sample of the file as well as detailed instructions in the attached .zip file.
## Deliverables
Please see attached files for more detailed description and instruction.