Hi,
i’m really lost
This is the array structure i got:
Array [ Array[17], Array[17], Array[17], Array[17], Array[17], Array[17], Array[17], Array[17], Array[17], Array[17], 13484 more… ]
This is generated out of a .csv file. So for every line an array with the same structure.
Where on index [9] is a serialnumber, at position[10] a CODE and on [13] is a date as string (“dd.mm.yyyy”).
Serialnumber is sometimes number, sometimes string (mixed numbers and letters)
I would like to put all entries with the same serialnumber into one array. After sorting by creating that new array the next task is to check for the most recent date for all entries where the CODE [10] is eqal and write that again into an new array.
Now i should be left with the same structured arrays as of the beginning, just less data.
Last step would be to take each array and check again for [10] and [13]. Now select the oldest date for every [10]
and grab the content out of [14] (meter-read) and put it into an array.
The final Array should still have the same structure, just added more values in between started at [15].
example:
Array [ Array[19], Array[19], Array[19], Array[19],…]
Hope somebody is willing to help me out here.