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.
16 freelance font une offre moyenne de $131 pour ce travail
We can help in your project, please check PMB and our ratings/reviews to get idea of our experience.
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
Hi, its done but only for text files in a folder at the moment. That is once you click the "From Folder" button, select the folder where the text files are and think done!. I have done it in Excel VBA. Individual text Plus