MATLAB Central Newsreader - seperating numbers from a cell array

Re: seperating numbers from a cell array

Pekka — Tue, 13 Nov 2007 08:23:00 -0500

"us " <us@neurol.unizh.ch> wrote in message
<f8n801$343$1@fred.mathworks.com>...
> Sachitha Obeysekara:
> <SNIP down to gruesome ML atrocity...
>
> > here's what i'm using:
> > regEx = '%s';
> > for i = 1:(numFieldsOut-1)
> > regEx = [regEx '%n'];
> > end
> > b=textscan(b,regEx,'delimiter',',');
> > output = '[';
> > for i = 2:numFieldsOut
> > output = [output 'b{1,' num2str(i) '} '];
> > end
> > output = [output ']'];
> > output = eval(output);
>
> WHY not simply use what you were given above?!...
>
> % some data
> b={
> 'T1,1,20,300,4000,00256.964'
> 'T10,1,20,300,4000,00356.964'
> 'TT1,10,200,3000,40000,00456'
> };
> nf=5; % #floats...
> % the engine
> fmt=['%s',repmat('%f',1,nf)];
> r=textscan(char(b).',fmt,'delimiter',',');
> r=cat(2,r{:,2:end});
> % the result
> b
> r
>
> us

Hi, the example above works fine.
But if I have only numbers in my cell of characters, I get
weird results.

b={
'10,20,3'
'4,7,23'
'9,6,1'}
nf = 3;
fmt=[repmat('%f',1,nf)];
r=textscan(char(b).',fmt,'delimiter',',')
>> r{1}

ans =

    10
     7
     6

>> r{2}

ans =

    20
    23
     1

>> r{3}

ans =

    34
     9

For some reason the last character of the first row is
combined with the first one on the second row. But that
doesn't happen on other rows.
However if I add a fourth cell, it works right, for example

>> b={
'10,20,3'
'4,7,2'
'9,6,1'
'45,765,3'}
r=textscan(char(b).',fmt,'delimiter',',','collectoutput',1)
>> r{1}

ans =

    10 20 3
     4 7 2
     9 6 1
    45 765 3

The mysterious connection of the first and last rows also
occurs if I have only two cells in b.

Is there something special in textscan for 3 or 2 lines of
numbers or what is going on here?
I'm using 2007b

Re: seperating numbers from a cell array

us — Tue, 31 Jul 2007 11:55:45 -0400

Sachitha Obeysekara:
<SNIP down to gruesome ML atrocity...

> here's what i'm using:
> regEx = '%s';
> for i = 1:(numFieldsOut-1)
> regEx = [regEx '%n'];
> end
> b=textscan(b,regEx,'delimiter',',');
> output = '[';
> for i = 2:numFieldsOut
> output = [output 'b{1,' num2str(i) '} '];
> end
> output = [output ']'];
> output = eval(output);

WHY not simply use what you were given above?!...

% some data
     b={
          'T1,1,20,300,4000,00256.964'
          'T10,1,20,300,4000,00356.964'
          'TT1,10,200,3000,40000,00456'
     };
     nf=5; % #floats...
% the engine
     fmt=['%s',repmat('%f',1,nf)];
     r=textscan(char(b).',fmt,'delimiter',',');
     r=cat(2,r{:,2:end});
% the result
     b
     r

us

Re: seperating numbers from a cell array

Sachitha Obeysekara — Tue, 31 Jul 2007 11:09:28 -0400

thanks

here's what i'm using:

regEx = '%s';
for i = 1:(numFieldsOut-1)
regEx = [regEx '%n'];
end

b=textscan(b,regEx,'delimiter',',');

output = '[';
for i = 2:numFieldsOut
output = [output 'b{1,' num2str(i) '} '];
end
output = [output ']'];

output = eval(output);

seperating numbers from a cell array

Sachitha Obeysekara — Mon, 30 Jul 2007 11:15:10 -0400

hi,
i have a cell array:

b =

T1,0,0,0,0,00256.964
T1,0,0,0,0,00256.656
T1,0,0,0,0,00256.869
T1,0,0,0,0,00257.666
T1,0,1,1,0,00246.296
...and so on

how do i seperate out so that i have a array like this:
c =

0 0 0 0 00256.964
0 0 0 0 00256.656
0 0 0 0 00256.869
0 0 0 0 00257.666
0 1 1 0 00246.296
..and so on

the T1 field can be discarded

Cheers

Re: seperating numbers from a cell array

JWagberg — Mon, 30 Jul 2007 04:38:13 -0400

On Jul 30, 1:15 pm, "Sachitha Obeysekara" <sachitha.
2.obeysek...@gsk.com> wrote:
> hi,
> i have a cell array:
>
> b =
>
> T1,0,0,0,0,00256.964
> T1,0,0,0,0,00256.656
> T1,0,0,0,0,00256.869
> T1,0,0,0,0,00257.666
> T1,0,1,1,0,00246.296
> ...and so on
>
> how do i seperate out so that i have a array like this:
> c =
>
> 0 0 0 0 00256.964
> 0 0 0 0 00256.656
> 0 0 0 0 00256.869
> 0 0 0 0 00257.666
> 0 1 1 0 00246.296
> ..and so on
>
> the T1 field can be discarded
>
> Cheers

One of many solutions:

tmp=textscan(char(b)','%*s%n%n%n%n%n','delimiter',',');
c=cat(2,C{:});

The above solution has some generality but must be modified if the
number of fields changes.

HTH,

jewa & wagberg , net (Modify the obvious)