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

1 visualizzazione (ultimi 30 giorni)
hedia gzr
hedia gzr il 24 Mag 2019
Commentato: hedia gzr il 27 Mag 2019
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 Commento
Rik
Rik il 24 Mag 2019
What have you tried so far?
Hint: useful functions in this case include xlsread, fileread (and/or fopen, fread, and fclose), ismember, and xlswrite.

Accedi per commentare.

Accedi per rispondere a questa domanda.

Risposta accettata

KSSV
KSSV il 24 Mag 2019
  1. Load bot the data into MATLAB using xlsread.
  2. Get the common strings using ismemebr, contains

Più risposte (0)

Categorie

Scopri di più su File Operations in Help Center e File Exchange

Tag

Community Treasure Hunt

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

Start Hunting!

Translated by