Reading a complete Colum of a multidimensional array at once

Question

0.00/5 (No votes)

See more:

Hi all, i was wounding if anybody can help with this I will be really grateful
I am working on a piece of software to read a comma separated text files with thousands of lines each line has around 32 word separated with a comma
What my code does at the moment it reads the file line by line choose 11 words out of the 32 and outputs them into a new file. This is actually time consuming although i used threads and a progress bar my manager still not happy.
So i was thinking if i can read the whole text file into a 2 dimensional array and then choose certain Colums to output on the new file that will make it work much faster. But i dont know how to read a whole colum from a 2 dimensional array. And let us say for example the array is gonna be like array(9500)(32) where the first argument representing the number of lines and the second represents the number of fields in each line.
Is there any way to access it like this array(all lines)(15)
I am using vb.net 2008

Many thanks

Posted 8-Nov-10 23:20pm

Mahmoud209

Add a Solution

Comments

CPallini 9-Nov-10 5:42am

Maybe your code is not efficient. Can we have a look at?

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

E.F. Nijboer · Accepted Answer · 2010-11-08T23:44:00

Solution 1

No this isn't possible because the value of each item in the same column is 31 items apart from each other. The values are sequential in memory for each row, but not for each column. You would have to transpose (columns to rows and rows to columns) it but that would give the same overhead.

Good luck!

Posted 8-Nov-10 23:44pm

E.F. Nijboer

Comments

Mahmoud209 9-Nov-10 6:21am

thanks i think u r true

Dave Kreskowiak · Accepted Answer · 2010-11-10T11:05:00

Solution 2

It's not possible. You'd still have to read each line, parse it into individual words, adding them to your array. You're not saving anyn time here.

There's no "automatic" way of doing it, though you might get a bit of a performance improvement using a RegEx to do the parsing.

Posted 10-Nov-10 11:05am

Dave Kreskowiak