How to extract column data of text from a csv file in vectors

1 view (last 30 days)
Hello, I have csv files, here the data are similar to the extract of a file attached as an example. I want to extract the data of some of the columns with text, say column 2 in vectors
For the numbers I use, for example and it works:
DT= C{3}(2:end);
ob_hour_count = str2double(C{4}(2:end));
it does not work for text though, it gives me NaN. How can I extract the text? Note that the text is not the same word along the column as it is in the example.
thanks, Katerina
  1 Comment
per isakson
per isakson on 24 Nov 2014
" file attached as an example" &nbsp is missing. Both [Choose file] and [Attach File] are required

Sign in to comment.

Answers (1)

Darek
Darek on 24 Nov 2014
Can you post an example file?

Categories

Find more on Text Data Preparation in Help Center and File Exchange

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!