- i have a string 'hello world' and i want to replace 'hello' world with 'bye'
Filtering words from an excel sheet
5 ビュー (過去 30 日間)
古いコメントを表示
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
2020 年 4 月 29 日
Too much explanations. What does 'filter' mean? Here how i understand you question:
Is it correct?
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 Center および File Exchange で Data Import from MATLAB についてさらに検索
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!