Filtering words from an excel sheet

2 vues (au cours des 30 derniers jours)
James Paltani
James Paltani le 29 Avr 2020
Commenté : Adam Danz le 29 Avr 2020
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 commentaires
darova
darova le 29 Avr 2020
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 le 29 Avr 2020
I agree with darova. Make it easier for people to understand the query and what you want to do.

Connectez-vous pour commenter.

Réponses (0)

Produits


Version

R2018a

Community Treasure Hunt

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

Start Hunting!

Translated by