How to delete in a table a row which contains a specific word
24 views (last 30 days)
Hello, I'm writing to you for this particular modification of my table that I extracted from a long .csv file using the function readtable
I have a very big table of data 56644x8 (some colums are number/coordinates, others contain words).
I'm interested to eliminate the rows which contain the word "Alignment" at the 7th column.
The more difficult step is that I would create a code that recognize words like Allignment, Allignment_test, Alignment_ecc, Alignment2 because I don't know if the input data could change in the future.
I'll appreciate all type of helps, thank you very much
Edit: I attached a similar file to mine, hope it will be helpful
Arif Hoq on 13 Apr 2022
try with this:
C(row,:)=; % eleminating row that contains "Alignment_Pin"
C(:,[2 3])= % eleminating column 2 and 3