MATLAB Answers

Extracting file from a folder

1 view (last 30 days)
Alexandra Philip
Alexandra Philip on 12 Aug 2020
Edited: Harshendra Shah on 19 Aug 2020
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 Comment

Sign in to comment.

Answers (1)

Harshendra Shah
Harshendra Shah on 19 Aug 2020
Edited: Harshendra Shah on 19 Aug 2020
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

  0 Comments

Sign in to comment.

Community Treasure Hunt

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

Start Hunting!