- i have a string 'hello world' and i want to replace 'hello' world with 'bye'
Filtering words from an excel sheet
5 visualizaciones (últimos 30 días)
Mostrar comentarios más antiguos
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
el 29 de Abr. de 2020
Too much explanations. What does 'filter' mean? Here how i understand you question:
Is it correct?
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.
Respuestas (0)
Ver también
Categorías
Más información sobre Data Import from MATLAB en Help Center y File Exchange.
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!