Thread Subject: .csv - file with numbers & text

Hy,

My problem:
Is there a way to upload a .csv file into matlab with
contains numbers and text? (e.g. row 1, 2, 4 contains only
numbers, row 3,5,6 only text)


Thanks

On Jul 24, 8:27=A0pm, "Daniel Miller" <bestell...@espenmoos-buch.ch>
wrote:
> Hy,
>
> My problem:
> Is there a way to upload a .csv file into matlab with
> contains numbers and text? (e.g. row 1, 2, 4 contains only
> numbers, row 3,5,6 only text)
>
> Thanks

One way is to save it as an Excel file and load using xlsread.
Then the numbers will be in an array and the text in a cell array.

Otherwise, you need to read it line by line using fgetl, for example.

"Daniel Miller":
<SNIP mixed blessing...

> Is there a way to upload a .csv file into matlab with
> contains numbers and text...

one of the (other) solutions

% assume this is the contents of your .csv
%{
1,2,3
abc,def,ghi
4,5,6
x,yy,zzz
%}

% the engine
     c=textread('foo.csf','%s');
     n=cellfun(@(x) sscanf(x,'%g,').',a,'uni',false);
     ie=cellfun(@isempty,n);
     n=cat(1,n{~ie});
     s=regexp(c(ie),',','split');
     s=cat(1,s{:});
% the result
     disp(n);
     disp(s);
%{
     1 2 3
     4 5 6
     'abc' 'def' 'ghi'
     'x' 'yy' 'zzz'
%}

us

"us ":
<SNIP made a stupid typo in his/her last reply...

> "Daniel Miller":
> <SNIP mixed blessing...

the correct snippet...

% assume this is the contents of your .csv
%{
1,2,3
abc,def,ghi
4,5,6
x,yy,zzz
%}

% the engine
     c=textread('foo.csv','%s');
     n=cellfun(@(x) sscanf(x,'%g,').',c,'uni',false);
     ie=cellfun(@isempty,n);
     n=cat(1,n{~ie});
     s=regexp(c(ie),',','split');
     s=cat(1,s{:});
% the result
     disp(n);
     disp(s);
%{
     1 2 3
     4 5 6
     'abc' 'def' 'ghi'
     'x' 'yy' 'zzz'
%}

sorry...
us