Convert One Text File to Many Excel Files

Hi people, how is it going all? Start your BID writing: "TXT to XLSX" to know you are not a bot. I'll filter bids reading this. I need a fast turnaround this time. I'll hire someone who has the right skills (and experience) for next tasks: - Convert one Text File to Excel format (the Excel files need to have at the most, 200K rows (200.000 rows) each one. - For example, if the Text File has 1.345.000 lines, I will expect 7 Excel files with 200k each one, except the last one which will have 145.000 rows. - Check the file "[login to view URL]" to see how the Text File will be presented. This attached file is just a sample with few lines inside. The right candidate will receive the complete file then. - You can get the Excel attached here, called "[login to view URL]" to know how should be presented each Excel file. The Text File has fields separated by "|" (pipe). - Please, trim all empty spaces to the left (start of the string) and to the right (end of the string) of each field before to generate the excel files. - Finally, get the file attached here, called "[login to view URL]" and do a simple join using first column ID and update the corresponding column in the Excel files (you should do this before to convert it to Excel, guess is better for you). Ask me for this point to be sure you can do it. I will expect this task completed today, in no more than 2 hours of time (if you know what you are doing). It is simple task, just many data to manipulate. ** My MAX Budget is $ 35. ** Thanks, and good luck for everyone.