Import data from a text file into Excel spreedsheets.
1. A series of text files for a phone registry, are grouped together in a folder.
Each file must be parsed into an excel template file and get saved by text file designation, for example, "[url removed, login to view]", "[url removed, login to view]", and so on.
Each text file has header-row data and user-defined data. Please see the text files attached "[url removed, login to view]", "[url removed, login to view]", etc.
The text file contains many fields of which only "Last Name","First Name","Middle
Initial","Address","Phone","SolicitFlag" are needed.
The data must be parsed into an excel spreadsheet template, please see "Registry-
[url removed, login to view]" for an ilustration of how the data in each text file should be parsed onto the excel spreadsheet.
The format of the spread sheet file should be preserved.
The program should also be able to process multiple text files as input, as in a batch process, aside from also allowing single text files to be used as input.
Further information will be provided, as requested. Feel free to contact me.
Décerné à :
17 freelance ont fait une offre moyenne de 129 $ pour ce travail
Hi, I have ready made code for your requirement. I can modify ready the prototype for you. I am good at excel processing. Ready to start immediately. Thank you, Pavan