Jump to content

Loop through 2D Array


Go to solution Solved by BrewManNH,

Recommended Posts

 I have a 2D array that I'm trying to use to run a loop:

For $i=0 to UBound($aProcess) -1
    _IENavigate($oIE, "https://192.168.0.10:1234/Id=" & $aProcess[$i][0])
    $oMeta= _IETableGetCollection ($oIE, 4)
    $aMeta= _IETableWriteToArray ($oMeta, True)
    $sRange= StringRegExpReplace ($aMeta[9][0],"through","|")
    $sAccounts=$aMeta[7][0]
    MsgBox(0,"",$aProcess[$i][0] & "|" & $sRange & "|" & $sAccounts & @CRLF)
    $fMetadata= @scriptdir "\db\log\reformed.csv"
    $cLines=_FileCountLines($fMetadata)
    _FileWriteToLine($fMetadata,$cLines+1,$aProcess[$i][0] & "|" & $sRange & "|" & $sAccounts & @CRLF)
Next

When I run this, everything seems to be functional through the MsgBox, but when I try to append the content of the msg box to the end of a file, it doesn't do anything.

I've checked and $clines does increment so I'm not sure why this is failing to create/append to the specified file.

Anyone know what I'm doing wrong here?

Link to comment
Share on other sites

  • Solution

What errors, if any, are you getting from _FileWriteToLine? My guess is that you're trying to write to a line that doesn't exist, so it fails. Try using FileOpen with the append parameter and FileWriteLine instead.

If I posted any code, assume that code was written using the latest release version unless stated otherwise. Also, if it doesn't work on XP I can't help with that because I don't have access to XP, and I'm not going to.
Give a programmer the correct code and he can do his work for a day. Teach a programmer to debug and he can do his work for a lifetime - by Chirag Gude
How to ask questions the smart way!

I hereby grant any person the right to use any code I post, that I am the original author of, on the autoitscript.com forums, unless I've specifically stated otherwise in the code or the thread post. If you do use my code all I ask, as a courtesy, is to make note of where you got it from.

Back up and restore Windows user files _Array.au3 - Modified array functions that include support for 2D arrays.  -  ColorChooser - An add-on for SciTE that pops up a color dialog so you can select and paste a color code into a script.  -  Customizable Splashscreen GUI w/Progress Bar - Create a custom "splash screen" GUI with a progress bar and custom label.  -  _FileGetProperty - Retrieve the properties of a file  -  SciTE Toolbar - A toolbar demo for use with the SciTE editor  -  GUIRegisterMsg demo - Demo script to show how to use the Windows messages to interact with controls and your GUI.  -   Latin Square password generator

Link to comment
Share on other sites

The file does exist. I did look at the error and its en error 4 (4 - $iLine is invalid)

Would this fail because the file was blank? When it tries to write the first line it would be trying to write line 1 and not line 0 given the code I'm using.

I tried:

$fMetadata=@ScriptDir & "\db\log\reformed.csv"
_FileWriteToLine($fMetadata,0,"ID|StartDate|EndDate|Account" & @CRLF,1)
For $i=0 to UBound($aProcess) -1
    _IENavigate($oIE, "https://192.168.0.10:1234/Id=" & $aProcess[$i][0])
    $oMeta= _IETableGetCollection ($oIE, 4)
    $aMeta= _IETableWriteToArray ($oMeta, True)
    $sRange= StringRegExpReplace ($aMeta[9][0],"through","|")
    $sAccounts=$aMeta[7][0]
    MsgBox(0,"",$aProcess[$i][0] & "|" & $sRange & "|" & $sAccounts)
    $cLines=_FileCountLines($fMetadata)
    _FileWriteToLine($fMetadata,$cLines,$aProcess[$i][0] & "|" & $sRange & "|" & $sAccounts & @CRLF)
Next

and I get an error 4 on the _filewritetoline before it starts the loop.

I'll look into the open command while I await others input.

Link to comment
Share on other sites

The line number can not be zero or less than zero.

If I posted any code, assume that code was written using the latest release version unless stated otherwise. Also, if it doesn't work on XP I can't help with that because I don't have access to XP, and I'm not going to.
Give a programmer the correct code and he can do his work for a day. Teach a programmer to debug and he can do his work for a lifetime - by Chirag Gude
How to ask questions the smart way!

I hereby grant any person the right to use any code I post, that I am the original author of, on the autoitscript.com forums, unless I've specifically stated otherwise in the code or the thread post. If you do use my code all I ask, as a courtesy, is to make note of where you got it from.

Back up and restore Windows user files _Array.au3 - Modified array functions that include support for 2D arrays.  -  ColorChooser - An add-on for SciTE that pops up a color dialog so you can select and paste a color code into a script.  -  Customizable Splashscreen GUI w/Progress Bar - Create a custom "splash screen" GUI with a progress bar and custom label.  -  _FileGetProperty - Retrieve the properties of a file  -  SciTE Toolbar - A toolbar demo for use with the SciTE editor  -  GUIRegisterMsg demo - Demo script to show how to use the Windows messages to interact with controls and your GUI.  -   Latin Square password generator

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

  • Recently Browsing   0 members

    • No registered users viewing this page.
×
×
  • Create New...