Array Question

[xcaliber13]

Hello,

       I am having an issue with pulling a file into an Array.  I have a pipe | delimited text file.   Now I can pull that file into excel with no issues.  All the columns and rows are good.  Now with no issue pulling that file into excel shouldn't I be able to file read to array using the pipe | delimiter?   But I cannot get this file into an array using the pipe delimiter. 

_FileReadToArray("C:\OPATemp\temp.txt", $avArray, $FRTA_NOCOUNT, "|")  ;No array created.  @error 1  $avArray is not an array
_FileReadToArray("C:\OPATemp\temp.txt", $avArray, $FRTA_NOCOUNT)       ;Creates an array but all in one column
_FileReadToArray("C:\OPATemp\temp.txt", $avArray, $FRTA_NOCOUNT + $FRTA_INTARRAYS, "|")  ; Creates an array of arrays

It is with this last one that I noticed the issue.  The array of arrays are different lengths.   But that is what is confusing me.   How can that be if I am able to pull into excel with no issues?   Thank you for any help

[Nine]

There must be an error in your file, you must have too many delimiters on some lines, compare to others.  They need to be perfectly identical in each line.  That is probably why it is working for array of arrays...

Upload the file if you can't find the discrepancies

 

[xcaliber13]

Nine Thank you for the reply.   Yes I do know that they need to be perfectly identical in each line but wouldn't that be the same to pull the file into Excel?   File pulls into Excel using the pipe delimiter with no issues. 

[iamtheky]

can you upload one of these files, or a reasonable snippet thereof?

[Nine]

19 minutes ago, xcaliber13 said:

but wouldn't that be the same to pull the file into Excel?

No it is not a requirement in Excel.  It will pull whatever there is in the file.  In autoit, that is why you have array of arrays, in case each lines don't respect the same number of delimiters...Look at a trailing useless delimiter 

Edited December 31, 2018 by Nine