Filtering words from an excel sheet

조회 수: 6 (최근 30일)
James Paltani
James Paltani 2020년 4월 29일
댓글: Adam Danz 2020년 4월 29일
Hello,
I am new to matlab and only have basic (Visual Basic) programming knowledge. I am trying to write a code that will filter out specific words from columns in an excel sheet (1), and output those matched words (coupled) and corresponfing row data to a seperate excel sheet (2).
Info:
Excel sheet (1) file name: "DI_export_HB_RB_May-Nov_2019"
Excel sheet (2) file name: "Templete"
Column (B1) name in which i want to find a keyword: "Anatomy"
Keyword in "Anatomy" column i want to filter: "ABDOMEN"
Column (C1) name in which i want to find a keyword: "View"
Keyword in "View" column i want to filter: "antero-posterior"
Want to filter out certain columns (I1, K1, L1, M1, N1) in the matced row of data that has BOTH "ABDOMEN" and ""antero-posterior" keywords under "Anatomy" and "View" columns, respectively.
Column (I1) name in which i want data under, exported: "Speed"
Column (K1) name in which i want data under, exported: "uAs"
Column (L1) name in which i want data under, exported: "kVp"
Column (M1) name in which i want data under, exported: "SID(mm)"
Column (N1) name in which i want data under, exported: "Grid"
Excel sheet (2) column i want "Speed" data listed: G3 and down
Excel sheet (2) column i want "uAs" data listed: K3 and down
Excel sheet (2) column i want "kVp" data listed: O3 and down
Excel sheet (2) column i want "SID(mm)" data listed: S3 and down
Excel sheet (2) column i want "Grid" data listed: W3 and down
  댓글 수: 2
darova
darova 2020년 4월 29일
Too much explanations. What does 'filter' mean? Here how i understand you question:
  • i have a string 'hello world' and i want to replace 'hello' world with 'bye'
Is it correct?
Adam Danz
Adam Danz 2020년 4월 29일
I agree with darova. Make it easier for people to understand the query and what you want to do.

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

답변 (0개)

카테고리

Help CenterFile Exchange에서 Data Import from MATLAB에 대해 자세히 알아보기

제품


릴리스

R2018a

Community Treasure Hunt

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

Start Hunting!

Translated by