split value in table two columns
조회 수: 1 (최근 30일)
이전 댓글 표시
Table look this in matlab(attached the table). another table looks like below
I want to separate 2nd colum into two columns.
one column before comma
another column after comma
Could any one please help me with it?
댓글 수: 0
채택된 답변
Image Analyst
2021년 12월 13일
편집: Image Analyst
2021년 12월 13일
I see a lot of unaccepted answers in your post posting history. You might want to accept some of them to award the people who helped you "reputation points."
This works:
data = readcell('Freq_complex.txt')
[rows, columns] = size(data)
counter = 0;
for row = 1 : rows
thisCellContents = data{row, 1};
if contains(thisCellContents, 'Freq')
% Skip a text line in the middle of all the data.
continue;
end
counter = counter + 1;
column1(counter) = str2double(thisCellContents(1:21));
column2(counter) = str2double(thisCellContents(23:end-1));
column3(counter) = data{row, 2};
end
fprintf('Done parsing %d lines of data to get %d numbers per vector.\n', rows, counter)
댓글 수: 0
추가 답변 (0개)
참고 항목
카테고리
Help Center 및 File Exchange에서 Text Data Preparation에 대해 자세히 알아보기
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!