Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. dreamscapeuk

    Write results from 2 files

    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 =...
  2. dreamscapeuk

    Write results from 2 files

    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! :)
  3. dreamscapeuk

    Write results from 2 files

    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"...
  4. dreamscapeuk

    Write results from 2 files

    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...
  5. dreamscapeuk

    Help with comparing 2 txt files

    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...
  6. dreamscapeuk

    Help with comparing 2 txt files

    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...
  7. dreamscapeuk

    Help with comparing 2 txt files

    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...
  8. dreamscapeuk

    Help with writing results from query

    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...
  9. dreamscapeuk

    Help with writing results from query

    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...
  10. dreamscapeuk

    Help with writing results from query

    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...
  11. dreamscapeuk

    Help with writing results from query

    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...

Part and Inventory Search

Back
Top