Transpose array - I don't understand

[Jewtus]

Hello everyone,

Please forgive me if this is a dumb question, I'm very new to autoit.

I'm trying to extract a table from a web portal and I have most of the script working.

Local $oTable = _IETableGetCollection($oIE, 1)
Local $aTableData = _IETableWriteToArray($oTable)

I tried writing the output to a file, which worked... sort of

Local $sFilePath = "C:\Automation\AutoIt\Example.csv"
_FileWriteFromArray($sFilePath, $aTableData, 1)

The file seems all sorts of messed up, so I tried using 

_ArrayDisplay($aTableData)

And that is when I figured out it was grabbing the table transposed. I have an output 7 rows 51 columns.

I've been trying to transpose them, but I'm not sure I understand the syntax.

Local $test [7][51] = _ArrayTranspose( ByRef $aTableData)
_ArrayDisplay($test)

Can someone steer me in the right direction? I'd like to ultimately output the file to CSV (or pipe it directly into SQLite) but I'm having some trouble figuring out how to actually transpose the data.

 

[Gianni]

Hi Jewtus

have you tried to use the "transpose" parameter directly in the _IETableWriteToArray() statement?

Local $oTable = _IETableGetCollection($oIE, 1)
Local $aTableData = _IETableWriteToArray($oTable, True) ; <-- add True here

also,

 if you want to use the _ArrayTranspose statement, you should use it like this:

_ArrayTranspose( $aTableData)
_ArrayDisplay($aTableData)

Edited April 23, 2014 by PincoPanco

[Jewtus]

 

Hi Jewtus

have you tried to use the "transpose" parameter directly in the _IETableWriteToArray() statement?

Local $oTable = _IETableGetCollection($oIE, 1)
Local $aTableData = _IETableWriteToArray($oTable, True) ; <-- add True here

I didn't know that was even a thing... THANK YOU!!!

[Gianni]

You are welcome