Filtering words from an excel sheet

5 visualizaciones (últimos 30 días)
James Paltani
James Paltani el 29 de Abr. de 2020
Comentada: Adam Danz el 29 de Abr. de 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 comentarios
darova
darova el 29 de Abr. de 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 el 29 de Abr. de 2020
I agree with darova. Make it easier for people to understand the query and what you want to do.

Iniciar sesión para comentar.

Respuestas (0)

Categorías

Más información sobre Data Import from MATLAB en Help Center y File Exchange.

Productos


Versión

R2018a

Community Treasure Hunt

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

Start Hunting!

Translated by