Extracting file from a folder

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?

[Walter Roberson]

rmmissing() ?

Answer 1

[Harshendra Shah]

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