Reading CSV file into 2-dimensional array - How To? 1

• Sep 6, 2022

• #2

Andrzejek

Programmer

Jan 10, 2006

8,578

US

Hopefully someone will correct me if I am wrong, but…
You can declare a 2-dimension array (you do know first dimension, which is 10) and – after you find out the number of lines (records) in your CSV file – you can ReDim the second dimension.


---- Andy

"Hmm...they have the internet on computers now"--Homer Simpson

 

Upvote 0 Downvote

• Sep 6, 2022

• Thread starter
• #3

IlyaRabyy

Programmer

Nov 9, 2010

572

US

Thank you, Andy but it ain't working:

If it's

Code:

Dim laData()
laData = File.ReadAllLines(lcPath2CSV)
ReDim Preserve laData(liRows, 10)

then

If it's

Code:

Dim laData(0, 10) As String
laData = File.ReadAllLines(lcPath2CSV)
Dim liRows As Integer = laData.GetLength(0), liCols As Integer = 10, lsCSV As String = "", lcFld As String = ""
ReDim Preserve laData(liRows, 10)

then

Any other suggestions?
TIA!

Regards,

Ilya

 

Upvote 0 Downvote

• Sep 6, 2022

• #4

strongm

MIS

May 24, 2001

20,264

GB

The error message is accurate - you are trying to change the number of dimensions of the array (from 1 to 2), and Redim cannot do that (and isn't what Andy was suggesting, he's really outlining a method for the solution you yourself outline in your original post). Also, you are trying to use Preserve - and if you use Preserve you can only resize of the last dimension of the array

>hope there's some other built-in .NET function that reads CSV into 2-dimensional array

Not that I am aware of

 

Upvote 0 Downvote

• Sep 7, 2022

• #5

M

mintjulep

Technical User

Aug 20, 2004

1,562

JP

Why not this?

https://docs.microsoft.com/en-us/do...s/how-to-read-from-comma-delimited-text-files

 

Upvote 0 Downvote

• Sep 7, 2022

1
• #6

Andrzejek

Programmer

Jan 10, 2006

8,578

US

I was thinking more of the way like:

Code:

Dim intNoOfLines As Integer
Dim aryMyArray(10, 1) As String

intNoOfLines = 20   [green]'Get the number of records from your CSV file[/green]

ReDim aryMyArray(10, intNoOfLines)[green]
'Populate your array here[/green]

---- Andy

"Hmm...they have the internet on computers now"--Homer Simpson

 

Upvote 0 Downvote

• Sep 7, 2022

• Thread starter
• #7

IlyaRabyy

Programmer

Nov 9, 2010

572

US

ReDim aryMyArray(10, intNoOfLines)
Right!
Years of working with tables misled me to believe that I can add a record (row) to an array, whereas I can add only a field (column). I forgot about this shortcoming of VB.
Thank you for reminding me!
Other than that (which is mea culpa!) - great post!


Regards,

Ilya

 

Upvote 0 Downvote

• Sep 7, 2022

• #8

Andrzejek

Programmer

Jan 10, 2006

8,578

US

I can add a record (row) to an array" - Yes, you can.
If you have an array [tt]aryMyArray(10, [red]20[/red])[/tt], you can add 'a record (row)' by:

[tt]ReDim Preserve aryMyArray(10, [red]21[/red])[/tt]

What you actually doing is - making a copy of the original array with an additional 'empty piece', but you can only do that with the last dimension

You cannot do: [tt]ReDim Preserve aryMyArray([highlight #FCE94F]15[/highlight], 20)[/tt]

Just realized - that all depends on what you consider a 'row' and a 'column' in an array...

---- Andy

"Hmm...they have the internet on computers now"--Homer Simpson

 

Upvote 0 Downvote

• Sep 7, 2022

• #9

mikrom

Programmer

Mar 27, 2002

3,020

SK

If you are not comfortable with REDIM then you can do that as I'm used to do it in Fortran

Code:

'1) read the file 1.time for counting the lines, and setting intNoOfLines

'2) declare the array
Dim MyArray(10, intNoOfLines)

'3) Read the CSV file 2.time and populate MyArray

 

Upvote 0 Downvote

• Sep 7, 2022

• #10

strongm

MIS

May 24, 2001

20,264

GB

>this shortcoming of VB

I'd point out that the limitation is actually the underlying datatype that VB uses, which is an Ole SafeArray. So blame Ole, not VB ...

 

Upvote 0 Downvote