How to extract column data of text from a csv file in vectors
1 view (last 30 days)
Show older comments
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
on 24 Nov 2014
" file attached as an example"   is missing. Both [Choose file] and [Attach File] are required
Answers (1)
See Also
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!