Loop through 2D Array

[Jewtus]

 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?

[BrewManNH]

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.

[Jewtus]

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.

[BrewManNH]

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

[Jewtus]

Using the open file strategy worked (and it also allowed me to get rid of my create file line).

Thanks!