Hi There. We need to have two possibly three VBScript functions modified to read fixed limit delimited text files which are output from a testing system, then build SQL statements to insert them into an Oracle database. We are using a proprietary system that uses VBScript and the system takes care of all the database connections, so that isn't something you need to worry about on our end. As long as you have a similar type database, and can create the three simple tables with 5 exact same columns each, to get the script functioning properly, we will insert the proper db connections using existing functionality in our script. Currently the VBScript function (and would appreciate it staying VBScript) reads comma delimited text files for a similarly related legacy system's output files, so the script is mostly written. With my less complex scripting ability, I made some attempts, but need a more proficient expert to finish and get the script functioning properly. For the right person, this shouldn't take more than an hour or two. We do need this done quickly to avoid minimal downtime.
I have attached the Script to be modified and the two types of files it needs to read and insert into the database tables.
this is the script
2nd test file
1st test file