MATLAB: Extract specific rows or columns containing letters (xxx) From dat File in Matlab

.csv fileextract from dat filematlab script

looking to come up with a script in matlab.the script should extract rows and columns containing/starting with letters xxx only in a dat file. This should be repeated for a number of DAT files. I have attached example xlsx file. for this example file I would like to extract any data that has the letters NSV. Any assist is welcomed. thanks in advance.

Best Answer

The code below reads the xlsx file as a table t using readtable and converts it to a cell array C with table2cell . It uses cellfun and regexp to determine which cells in C contain 'NSV'. Find is used to determine the row and column of each entry in tokens in the cell array C.

If you need to match three different combinations of letters, replace 'NSV' in the regexp with said combination. If you need to do it programmatically, you can use strcat to obtain the expression string used for the regexp.

 t = readtable('dta.xlsx','ReadVariableNames',false);
 C = table2cell(t);
 [tokens,matches] = cellfun(@(x) (regexp((x),'(.+)(?<=NSV)(.+)','match','tokens')),C,'un',0);
 [row,col] = find(cellfun(@(x) ~isempty(x),tokens));
 data = C(row:end,col);

The first row of data is the char vectors which contain 'NSV', where the following rows contain all the corresponding data.

Sample output, first column of data:

 'BCS_PHY/FUN_OUT/ENV/HYD_NSV1_COIL1_CURRENT_OVERRIDE_OUTPUT'
 '0'
 '0'
 '0.012293'
 '0.012293'
 '-0.024586'
 ...
 ...
 ...

Sample output, second column of data:

 'BCS_PHY/FUN_OUT/ENV/HYD_NSV1_COIL2_CURRENT_OVERRIDE_OUTPUT'
 '0.012305'
 '0'
 '0.012305'
 '0'
 '-0.024611'
 ...
 ...
 ...

Related Solutions

MATLAB: Invalid input argument type or size such as observation, reward, isdone or loggedSignals. (Reinforcement learning toolbox)

Hello,

It's challenging to reproduce this without having access to a reproduction model (including the environment definition).

I would recommend comparing your code with this example which is similar in nature (has multiple discrete actions) and particularly lines 237-248 in RocketLander.m. Make sure each element in your cell array has appropriate dimensions whether that's 1x2 or 2x1.

If this does not work, check the dimensions of the IsDone and reward signal as well and make sure these are scalars.

MATLAB: How to Get a Structure as an Output from a Function

You did not define your function to have any output:

function []=filesort(x)
         ^^ no output argument!

Also your code is much longer and much more complicated than it needs to be. Try this (I just tested it):

function otpS = filesort(inpS)
C = {'Z1P','Z2P','Z1G','Z2G','Z3K','Z4K','Z5K','Z3M','Z4M','Z5M','Z6MS','Z7PR','Z7PR1'};
N = {inpS.name};
otpS = struct();
for k = 1:numel(C)
    idx = cellfun('isempty',regexp(N,C{k},'once'));
    otpS.(C{k}) = inpS(~idx);
end
end

Tip: computers are only good at doing one thing: repeatedly doing small stupid tasks. So when you find yourself copy-and-pasting code like that, and repeating the same code over and over again, then you are doing the computer's job. Instead of wasting your life, get the computer to do it: use a loop.

Best Answer

Related Solutions

MATLAB: Invalid input argument type or size such as observation, reward, isdone or loggedSignals. (Reinforcement learning toolbox)

MATLAB: How to Get a Structure as an Output from a Function

Related Question