c0z420

Ok...i have a little dilemma here @ my job that i'm trying to figure out how to solve. So here goes...

We run a job in a Reflections Session that produces reports. After they are finished the reports are tranfer out of their to a place on our network in "txt" documents. We then run a program that will post them on a part of our Intranet for our business office to view. The problem is, we (Computer Operators) @ night have to look @ about 3 of the reports and make sure there are No errros between figures. So for example we have a Beginning AR, a Net Change, and an Ending AR on one report that we have to actually open an EXCEL document and put those figures into. WE have to do this for a few other reports into another excel document. The thing is, we would like to Automate this somehow that it can check to see if there are any Errors in Figures and then post them into an excel or even access database automatically for archiving. Any suggestions...??? At our last meeting one of the guys suggested doing it all in VB. I tried doing Macros in Excel and tried fiddling with Access but it really wasnt working much. Let see how many ideas we can get flowing, i'll take any suggestions.

Jason

Dameon

Cross posting is against the forum rules. Notice that I am not cross posting this message.

__________________
MD5(sig) = bcef75433db02e9ad9bf81d6f7c5c270

c0z420

Sorry, I just didnt reallly know what category to put this topic in since I really dont know what programming i should use ?

Ghost

What type of errors are you looking for? Data Corruption or what? I mean if you have a program just compare the same wrong numbers to each other then what would that do other than make your company look foolish?

I think you need to think concerning this issue again and have a well documented mission statement on what you would like to accomplish, because as it, you would have people just institute telling you to code it like this or that when really you have not provided any of use with an adequate amount of information to make an knowledgeable retort.

c0z420

It actually is not as Hard as it sounds or complicated for that matter. My company wont look foolish if some figures are wrong or anything because our company outsources those duties to a vendor which would take care of the problem. The reason we check to see if the figures are off is so they can fix the problem if they are.

Ok, so there is a Folder on our network that has all these reports in TXT docs, it has all the information we need in them. Mostly all mathematical currencys under headings. What I'm really asking is, is there a way to open a report......find these exact figures i want.....lets say 3 differnt figures from 3 different columns on the same line. So i wanted the begginning AR, the net change, and the Ending AR.... All i want to do with them is put them into a program such as excel automatically but the touch of a button or with a simple VB program. Its not that this isnt well thought out, i just am a newbie programmer obviously and I dont know how to go about grabbing something I need from a speicific spot in a txt doc. Then i know i could put just a simple formula in the program or either the excel doc making a field to check like this

Beginning AR - Net Change = Ending Ar

Then there is another one that compares 3 totals.....

AR summary report, AR Summary Cycle Day Aging , and AR Summary By STMT Aging. These should all have the same exact total at the end of each report....so if there were a way to grab the 3 totals and have something like.... if they all equal to zero....end of program and all is good, and if not then there is a problem.

I dunno, i probably just confused u all more but it sounds clear to me, i just need a way of gathering the data thats already there.

Ghost

Well there would be a problem reading the text documents as a grid since they are just characters and you would need to know the exact character count or unique string to id that portation of the file you wish to parse from the TXT doc.

I assume you have a program that creates these reports and I asume it was programmed to use the same values that rep the data, so my statement above saying that why compair all wrong data together is because if the program things that the Beginning AR is 1500 and in the report it says 1500 then this program you wish to create is going to compair 1500 to 1500 and it will check just fine, I suppose I do not understand you completely, so if you could try to explain it more that would be nice.

__________________
People who click "images" that end with .exe shouldn't have computers.

Arevos

It might be possible to do all this from Excel. If you try to open a text file in Excel, it'll pop up with a dialog asking you how you want to import it. You can specify how the columns are delimited, whether fixed-width or by a special character (such as a comma or a tab), and Excel will create a spreadsheet for you from this.

It's limited, but as long as your text-files are in a simple format, it should be quite possible to import them into Excel directly.

c0z420

Thanks for the advice. I wish i could do it all from excel but the problem is, theres alot of data that we really dont need in these output files....we only need like 1 line of data out of like 5-6 pages of reports. So i'm just wondering how we can get the numbers we want from the reports....compare the numbers....make sure there are no errors in the figures....which means that the difference will be 0, and the last report u compare 3 differnt reports and make sure all the grand totals match and are the same value.

Ghost

String Parsing.

__________________
People who click "images" that end with .exe shouldn't have computers.