Extracting file from a folder

3 次查看（过去 30 天）
Alexandra Philip
Alexandra Philip 2020-8-12
编辑： Harshendra Shah 2020-8-19
I am having some trouble with updating the table to only display the rows that have something in their cells in the 8th column.
So I attempted to use:
columnData=CopyofEGIYieldDataJuly202073020(2056:2098,:)
Filefolder=find(~isempty(columnData(:,8)))
EGIdataMike=columnData(Filefolder,:)
And am trying filter out the rows with nothing in between the quotation marks in the cell in the 8th column like this:
That would just leave the rows that actually have something in between the quotations marks in the table.
I then am trying to extract the file folder link in the 8th column, look inside them and save the first file in that folder to another path, and then copy the path for that file and place it into a variable such as:
data1553IN=parseWingsSavFull('C:\AP\34209200-W0S5-()_65474_2020Jul21_010802_EGI Thermal_1553In.HSR','EGI.mdb');
Any suggestions or applications of corrections?

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

回答（1 个）

Harshendra Shah
Harshendra Shah 2020-8-19
编辑：Harshendra Shah 2020-8-19
Hi,
You can use rmmissing function.
R = rmmissing(A,'DataVariables',{'VarName8'}) % A is Input data, specified as a vector,
% matrix, table, or timetable.
Regards,
Harshendra

类别

在 Help Center 和 File Exchange 中查找有关 Tables 的更多信息

标签

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by