Windows Batch File or Excel VBA for Text File Splitting Large TXT File
Budget: $30 – $250 USD
I'm looking for a Windows batch file solution that can split a large text file, approximately 900K lines, into smaller text files of 10K lines each. Each of these smaller files should contain the headers from the source file. Additionally, the solution should automatically submit all the created files to a designated FTP location.
Key requirements:
- The solution can be created with Python, Node.JS, Powershell, or and exe program but will need to be triggered using a Windows batch command or VBA. Original source txt file is built from an excel worksheet, so an alternate solution can be building files as described via excel VBA from existing excel spreadsheet as long as it includes a PUT command to the FTP location for all built files.
Ideal skills for this project include:
- Proficiency in writing Windows batch files.
- Excel VBA.
- Experience with file handling and FTP in a Windows environment.
I have an FTP location and credentials ready. Files should retain the original filename with a numeric suffix (e.g., originalfile_1.txt, originalfile_2.txt).
Will supply example of full source file and/or original excel file for a VBA solution. The header in the source file is a single line.
The batch file should create a final smaller file if the lines are not a multiple of 10K. The batch file should submit all new files to the FTP location immediately after they are created.
Key requirements:
- The solution can be created with Python, Node.JS, Powershell, or and exe program but will need to be triggered using a Windows batch command or VBA. Original source txt file is built from an excel worksheet, so an alternate solution can be building files as described via excel VBA from existing excel spreadsheet as long as it includes a PUT command to the FTP location for all built files.
Ideal skills for this project include:
- Proficiency in writing Windows batch files.
- Excel VBA.
- Experience with file handling and FTP in a Windows environment.
I have an FTP location and credentials ready. Files should retain the original filename with a numeric suffix (e.g., originalfile_1.txt, originalfile_2.txt).
Will supply example of full source file and/or original excel file for a VBA solution. The header in the source file is a single line.
The batch file should create a final smaller file if the lines are not a multiple of 10K. The batch file should submit all new files to the FTP location immediately after they are created.