is there any idea on how to compare an .xls file and .csv file?

조회 수: 1 (최근 30일)
hedia gzr
hedia gzr 2019년 5월 24일
댓글: hedia gzr 2019년 5월 27일
Hello,
I'm trying to compare two files, .xls(screenshot1) and .csv(screenshot2). It should verify that every word contained on .csv is present on .xls file. and write in column B (of File1) OK if the word exist in both files.
I am a beginner in matlab, any help would be much appreciated.
Thanks!
  댓글 수: 1
Rik
Rik 2019년 5월 24일
What have you tried so far?
Hint: useful functions in this case include xlsread, fileread (and/or fopen, fread, and fclose), ismember, and xlswrite.

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

이 질문에 답변하려면 로그인하십시오.

채택된 답변

KSSV
KSSV 2019년 5월 24일
  1. Load bot the data into MATLAB using xlsread.
  2. Get the common strings using ismemebr, contains

추가 답변 (0개)

카테고리

Help Center 및 File Exchange에서 File Operations에 대해 자세히 알아보기

태그

Community Treasure Hunt

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

Start Hunting!

Translated by