Issue with _filereadtoarray

[Milas]

hello

im trying to get info from a csv file into a 2d array. im not sure exactly where I am going wrong. I can get it into a 1d array but the 2d part is really troubling for some reason. can anyone pint me in the right direction. I provided my code.

Inventory (test).au3

[Melba23]

Milas,

You are adding an extra "," at the end of each line. As this is not present in the first line of the files (the titles), the function fails because there are dissimilar numbers of fields in the lines - you should be getting error set to 3 in the MsgBox.

Change the code to read as follows and all will work:

Func Submit($array)
    If Not FileExists($sDataFilePath) Then
        FileWriteLine($sDataFilePath, "Date,Rank,Last,First,Middle,Serial,ECN,MAC,Clinical,Make,Model,Department")
    EndIf

    For $i = 0 To 11
        Switch $i
            Case 0
                FileWrite($sDataFilePath, "" & @MON & "/" & @MDAY & ",")
            Case 1 To 10
                FileWrite($sDataFilePath, $array[0][$i] & ",")
            Case 11
                FileWrite($sDataFilePath, $array[0][$i])
        EndSwitch
    Next
    FileWriteLine($sDataFilePath, "")

EndFunc   ;==>Submit

Now there is no final "," and the function works as you expected.

M23

[Milas]

so I did as u said but the func that I have reading the file still only creates it as a 1D array. I try to use the comma as a delimiter to separate everything in to their own cell to make it a 2d array but errors out every time

 

thank you for your help by the way I really appreciate it

 

 

 

[Melba23]

Milas,

It works for me when I test - I get a nice 2D array displayed. Can you please post an example of the csv file that you create so I can take a look.

M23

[Milas]

Thank you for your help. your response made me realize it was the csv file I was using witht he old data in it. i deleted that csv file and had it create a new one. everything works perfectly with the new file. Thank you very much. If no one tells you that you are amazing just remember this day that i told you

you are amazing

Edited December 9, 2015 by Milas

[Melba23]

Milas,

the csv file I was using witht he old data in it

I thought that might be the case - hence my request. Delighted it now works and glad I could help,

M23