Search results for query: *

Any help with this as it doesn't seem to work.. Const ForReading = 1, ForWriting = 2 Set objDictionary = CreateObject("Scripting.Dictionary") ' Declare the dictionaries. Dim Dict1 Dim Dict2 'Set txt files Set objFSO = CreateObject("Scripting.FileSystemObject") Set objTextFile =...

I really need this quickly and will post out 3 Xbox 360 games to the first person who can give me the solution I need, as a big thank you! :)

Here's the original file I have which only lists the differences I have in file 1: Const ForReading = 1, ForWriting = 2 Dim fso, OracleFile, HyperionFile, strLine1, strLine2, strMatch Set fso = CreateObject("Scripting.FileSystemObject") Set OracleFile = fso.OpenTextFile("OracleFile.txt"...

Hi, I'm really new to vbscript need some help in writing the results from a validation of 2 txt files. Both files are in the same format 5DigitAccountNo Space Value e.g 40000 -190000.00 40100 2000.00 40200 50000.00 etc I can do the basics like read each line in file one and match it with...

Hey Paul, for efficiency purposes if one vbscript can pull data from 2 sources, then validate the data and send an email, this would be the ideal solution. It's one job on one server that needs to be run and maintained. Running this from Excel from another server means relying on another...

Thanks for your responses. The text files are being validated against each other. Both are tables in essence but table 2 has the account descriptions next to the account. Unfortunately the server we are performing this on does not have office otherwise it would be an easy solve with vba. I'm...

Hi, New to VBScripting and hope someone can help. I have 2 text files from different sources and the idea is to automate the validation for them. Basically I need to read both files line by line and match the values for each account. Sounds simple but there's a twist and that's where I am...

It's Ok I figured it out this morning. ResultsFile.WriteLine rows("ACCT") & vbTab & rows("PERIOD_BALANCE") For some reason when I use rows.Fields( it doesn't work properly, but taking fields away works like a charm. Now I gotta figure out how to write the whole data to another file. Cheers...

Hey Tsuji, By that I mean that I think the SQL query is working but the script is only writing te first line to the ResultsFile. When I run the SQL query in SQL Developer I get 610,000 records returned. In the results file from this script I only get the first line but as I have selected to...

Thanks tsuji. I actually formatted the sql code so it was easier for people to read it. Also took out the Logfile to shorten the code and focus on what I'm asking. Sorry for the confusion. The SQL query seems to work fine and appreciate your tip as I was putting it all on one line to make it...

Hi, I'm fairly new to VBScript and I've bene trying really hard to pick it up over the last few weeks to get my project completed. Basically we load data from oracle to essbase and I wanted to create something to validate the data. I'm trying to pul data from Oracle and put it in an easy...