In Excel divide the single column into three columns

Question

nada 2017-12-23

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/374293-in-excel-divide-the-single-column-into-three-columns

评论： nada 2017-12-26

Hi...In an Excel table, I want to divide the single column into three columns containing data from the first column,Select from A3 the three columns Tide Amplitude Phase

buffer=fileread('RasTanura 1980 AllYear._AnalysisLog.txt');
data= textscan(buffer, '%s %*f %f %f %f %f %f %f','delimiter','#');  
data= [data{1},num2cell([data{2:end}])];
xlswrite('RasTanura 1980 AllYear.xlsx',data);

2 个评论
显示无隐藏无

dpb 2017-12-23

Attach a short section of the original input file -- looks like should be able to just read it directly if you skip the three header lines. If you want to keep the three data values shown above, I don't understand why you would have written the format string you did???

nada 2017-12-24

file1.xls

Converted file txt to xls by code >>now i want Divide the column into three columns containing the (Tide, Amplitude, Phase) and divide columns into four at the row A34 containing (JDay(LST),Observed, Predicted, Residual) datas.

Please help me .. to find a solution

请先登录，再进行评论。

请先登录，再回答此问题。

Answer 1

Walter Roberson 2017-12-24

1
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/374293-in-excel-divide-the-single-column-into-three-columns#answer_297559

在 MATLAB Online 中打开

 [~, txt] = xlsread('file1.xls');
 TAP_cell = regexp(txt(4:29), '(?<Tide>\S+)\s+(?<Amplitude>\S+)\s+(?<Phase>\S+)', 'names', 'once');
 TAP = vertcat(TAP_cell{:});
 Tides = {TAP.Tide};
 Amplitudes = str2double({TAP.Amplitude});
 Phases = str2double({TAP.Phase});
 JOPR_cells = regexp(txt(35:end), '\s+', 'split');
 JOPR_cell = vertcat(JOPR_cells{:});
 JOPR = str2double(JOPR_cell);
 JDay_LSTs = JOPR(:,1);
 Observeds = JOPR(:,2);
 Predicteds = JOPR(:,3);
 Residuals = JOPR(:,4);

6 个评论
显示 4更早的评论隐藏 4更早的评论

nada 2017-12-25

编辑：Walter Roberson 2017-12-25

在 MATLAB Online 中打开

how can i convert cell (Tides) to double..

i want sort one table content T1+T2.. withe write Text=char(d,d2)

[~, txt] = xlsread('file1.xls');
ch1=txt(1:2);ch2=txt(31:33);d=char(ch1);d2=char(ch2);
Text=char(d,d2);
 TAP_cell = regexp(txt(4:30), '(?<Tide>\S+)\s+(?<Amplitude>\S+)\s+(?<Phase>\S+)', 'names', 'once');
 TAP = vertcat(TAP_cell{:});
 Tides = {TAP.Tide};Tides=Tides';
Tides=(cellfun(@str2double, Tides)) ;
 Amplitudes = str2double({TAP.Amplitude});Amplitudes=Amplitudes';
 Phases = str2double({TAP.Phase});Phases=Phases';
   JOPR_cells = regexp(txt(35:end),'\s+', 'split');
   JOPR_cell = vertcat(JOPR_cells{:});
   JOPR = str2double(JOPR_cell);
   JDay_LSTs = JOPR(:,1);
   Observeds = JOPR(:,2);
   Predicteds = JOPR(:,3);
   Residuals = JOPR(:,4);
   T1=[Amplitudes,Phases];
   T2=[ JDay_LSTs,Observeds,Predicteds,Residuals];
   A = array2table(T1, 'VariableNames', {'Amplitude','Phase'});
  B = array2table(T2, 'VariableNames', {'JDay_LSTs','Observeds','Predicteds','Residuals'});
  writetable(A,'tabel3.xls')
  writetable(B,'tabel4.xls')
  %N = vertcat(A,B);

Walter Roberson 2017-12-25

在 MATLAB Online 中打开

Remove the

Tides=(cellfun(@str2double, Tides)) ;

and use

T1 = cell2table( [Tides(:), num2cell(Amplitudes(:)), num2cell(Phases(:))], 'VariableNames', {'Tide', 'Amplitude', 'Phase'});

The problem is in trying to convert the Tide to numeric, since it is text.

nada 2017-12-26

| | | | Thank you again||||*

请先登录，再进行评论。

In Excel divide the single column into three columns

2 个评论
显示无隐藏无

采纳的回答

6 个评论
显示 4更早的评论隐藏 4更早的评论

更多回答（0 个）

另请参阅

类别

标签

Community Treasure Hunt

In Excel divide the single column into three columns

2 个评论 显示 无隐藏 无

采纳的回答

6 个评论 显示 4更早的评论隐藏 4更早的评论

更多回答（0 个）

另请参阅

类别

标签

Community Treasure Hunt

2 个评论
显示无隐藏无

6 个评论
显示 4更早的评论隐藏 4更早的评论