Need a PowerShell or batch file solution to merge tab delimited text files file into a single file tab delimited output file. For example, if File1 has 6 records, File2 has 600, and File3 has 60, the output file will have 666 records. Include system requirements in your proposal.
Requirements:
1) the batch/PS file will be located in the same directory as the text files.
2) the output file should be named ReadyToLoad
3) the output file should be located in the same directory as the input files
4) merge only the input files which have a header row that exactly matches the headers in the tab delimited text file, [login to view URL]
5) the output file should have a single header row, i.e. it should not include a header row from each input file
6) if a file is rejected because it doesn't exactly match the text file, [login to view URL], the file should be moved into a subdirectory of the current directory.
a. that subdirectory should be named NoMatch
b. if the directory doesn't exist, create it.
7) provide documentation of
a. how the code works in detail for a nontechnical audience.
b. step by step instructions for deploying your batch/PS file.
The project is not complete until this documentation is received.
System information:
Windows 10 Pro
Major minor build revison
Powershell: 5 1 14393 1198
Background:
>>The text files to be merged are located on a remote server.
>>Currently each directory has >100 files to merge.
>>Each directory has it's own [login to view URL] file.
>>The number of headers in each tab delimited headers file ranges from as few as 10 to over 50.
>>Input files range in size from 2,000 KB to 565,000 KB
Included:
>>I have included a sample [login to view URL] file.
>>You will need to generate your own input files for testing.
Questions:
Please ask if I haven't been clear or complete.
Hi. I have read the description. I can create a PHP script that will follow the same logic to perform the same file merging operations. PHP scripts can also be run locally on PC by installing PHP, or WAMP/XAMP. Please let me know if interested. I can also provide the documentation. Thanks.
Regards
Ahsan
Hi
I can provide another solution to merge the files. I can implement a desktop application in c# that can read all files and merge them. Work can be finished in few hours. Thanks
Relevant Skills and Experience
Programming
Stay tuned, I'm is still working on this proposal.
Dear, I am Microsoft Certified Professional (MCP) and Microsoft Certified Trainer (MCT), I can create the script, quickly
Relevant Skills and Experience
powershell or batch file
Proposed Milestones
$200 USD - Script