Reading comma delimited files

If all of the data in the file are numeric except possibly row and column labels , then you may want to coerce the result into a matrix. You would do that with something like:.

The year was automatically selected as the row names in the example. In this case, it is a pretty good choice, but you can control which data, if any, is selected to be the row names. When you are reading data from one place to another, there is always the chance of miscommunication.

There are many ways that such misunderstandings can arise. The start of Circle 8. Portfolio Probe Burns Statistics Investment technology for the 21st century.

Search for:. Loop through the fields in the file. If any lines are corrupt, report an error and continue parsing. The following code loops through the file, displaying each field in turn and reporting any fields that are formatted incorrectly.

A row cannot be parsed using the specified format MalformedLineException. The exception message specifies the line causing the exception, while the ErrorLine property is assigned the text contained in the line.

The specified file does not exist FileNotFoundException. A partial-trust situation in which the user does not have sufficient permissions to access the file. The path is too long PathTooLongException. The user does not have sufficient permissions to access the file UnauthorizedAccessException. ReadToEnd ; reader1. Close ; reader1. Split ",". Parse Convert.

Improve this question. Arshiya Gm Arshiya Gm 63 3 3 gold badges 3 3 silver badges 7 7 bronze badges. Is this homework? PLease show what you have tried so far, some code.. This is a solved problem. Check for libraries that parse csv files e. Add a comment.

Active Oldest Votes. OpenRead "data. ReadFields ; fileContent. Improve this answer. Kobi Kobi k 41 41 gold badges silver badges bronze badges. Thanks for pointing this out Kobi. Use the String. Split ','. Erich Horak Erich Horak 3 3 silver badges 10 10 bronze badges. This should get you started. Community Bot 1 1 1 silver badge. OpenText "myfile. Parse fields[0]. Chris Fulstow Chris Fulstow