convert char to double

I really appreciate someone tell me how can I convert attached file to double.

Thanks in advance.

Answer 1

[Geoff Hayes]

Farshid - try using cellfun. It seems that the pn is a cell array with 38 elements and each element is a 8x1 char array. You haven't mentioned if each of the 8 characters is a single number or if all 8 combine to one (I'll assume the latter).

>> myData = load('example.mat');
>> numericData = cellfun(@(x)str2double(x'), myData.pn);

[Farshid Daryabor]

Please check array 16 "numericData(16)" it is array I have problem. Please take a look at myData.pn(16).

[Geoff Hayes]

I'm not sure what your question is? The data looks like

>> myData.pn{16}

ans =

66
99
00
11
99
65
29

That is how it is in your example.mat file. And the way I've coded this is so that this gets converted to 66990011996529. Are you expecting two numbers like 6901962 and 6901959?

[Farshid Daryabor]

Are you expecting two numbers like 6901962 and 6901959? YES, I expect to be in two different column

[Geoff Hayes]

sigh. you can do something like

>> myData = load('example.mat');
>> numericData = cell2mat(cellfun(@(y)arrayfun(@(x)str2double(y(:,x)'),1:size(y,2))', myData.pn,'UniformOutput',false));

which works for this data set but I don't know if it will work for other sets. It uses cellfun to evaluate each cell in your myData.pn cell array. This evaluation uses arrayfun to evaluate each column in the char array - first taking the transpose of the column and then converting it to a double.

[Farshid Daryabor]

Dear Geoff,

It's working, but I want to keep a size something like 2*38. please see the form of the 'lon' attached. Since the each array of 'pn' (platform number) should be assigned to the one longitude and latitude correspondingly.

I really appreciate any comment to improve.

[Farshid Daryabor]

should be in two row exactly same form of lon and lat

[Geoff Hayes]

Farshid - it probably would have been easier if you had just asked for that format in the first place.

myData = load('example.mat');
myOutputData = nan(2,length(myData.pn));
for k = 1:length(myData.pn)
    data = myData.pn{k};
    myOutputData(1,k) = str2double(data(:,1)');
    if size(data,2) == 2
        myOutputData(2,k) = str2double(data(:,2)');
    end
end

[Farshid Daryabor]

Dear Geoff,

I really appreciate, veryyyyygoodddddddddd