Search through CSV to find certain words/numbers in cell

조회 수: 6 (최근 30일)
new2matlab
new2matlab 2020년 1월 27일
댓글: new2matlab 2020년 2월 19일
I have a large CSV file containing various columns of names, numbers, links, etc and want to search through each row to find the ones that contain a certain time (so that I can later delete the others and run the program with the variables, or rows, that I choose. Not sure where to begin, but maybe:
  • list the rows that contain the requested cell info?
  • instantly delete the rows that dont contain this?
  • only run the rows with it?
  댓글 수: 2
Mohammad Sami
Mohammad Sami 2020년 1월 28일
편집: Mohammad Sami 2020년 1월 28일
If you have time I would recommend you to complete the Matlab onramp course.
For reading csv files, either use the GUI to import and generate import function, or use the readtable function.
For searching columns containing text, use the function contains. It will return you all rows which contain the specified word(s).
For finding exact values use the ismember function with the values you want to find.
new2matlab
new2matlab 2020년 2월 19일
Will do! Thank you!

댓글을 달려면 로그인하십시오.

답변 (0개)

카테고리

Help CenterFile Exchange에서 File Operations에 대해 자세히 알아보기

Community Treasure Hunt

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

Start Hunting!

Translated by