Reading all text from specific cell from .csv file.

4 次查看（过去 30 天）
Shivam Upadhyay
Shivam Upadhyay 2020-2-17
评论： Shivam Upadhyay 2020-2-24
Actually I am new to matlab. I actually want to read specific code from the excel sheet(which is one column having all the specific code) and then want to print the information associated with that specific code(which is in another column). So what should I do.
Below is the sample csv data.
Specific Code DTC_display DTCType Information
'0x000100' 'P0001-00' 'CD' 'Fuel Volume Regulator "A" Control Circuit/Open'
'0x000200' 'P0002-00' 'CD' 'Fuel Volume Regulator "A" Control Circuit Range/Performance'
'0x000300' 'P0003-00' 'C' 'Fuel Volume Regulator "A" Control Circuit Low'
'0x000400' 'P0004-00' 'C' 'Fuel Volume Regulator "A" Control Circuit High'
Simply. If user enter specific code then I will search from the first column and then if I found the inputted value in first column then I will print the information associated with it(present in the column with header Information).
  4 个评论
显示 2更早的评论
Jakob B. Nielsen
Jakob B. Nielsen 2020-2-17
CSV is comma separated values, but it looks like yours are tab separated. Can you try to attach the file, so we can see exactly what format we are working with?

请先登录，再进行评论。

请先登录，再回答此问题。

采纳的回答

Giuseppe Inghilterra
编辑：Giuseppe Inghilterra 2020-2-21
Hi,
try to run following code, you should obtain what you have asked:
close all
clear all
clc
filename = 'dtc_table.csv';
T = readtable(filename,'ReadVariableNames',false);
T.Properties.VariableNames = {'SpecificCode' 'DTCDisplay' 'DTCType' 'Information'};
prompt = 'Enter Code: ';
UserCodeInput = input(prompt,'s'); %ask user for specific code as string
[r,c] = size(T);
CodeIsFound = false;
for ii = 1:r
if strcmp(UserCodeInput,T.SpecificCode{ii,1}) % if code is found display information
CodeIsFound = true;
disp(T.Information{ii,1})
end
end
if CodeIsFound == false % if code is not found at all display "not found"
disp('Specific Code not found')
end
The user input is considered as a string and strcmp function is used to compare strings. If code is found, associated information is displayed.
Example:
Hope this helps.

更多回答（0 个）

类别

在 Help Center 和 File Exchange 中查找有关 Spreadsheets 的更多信息

标签

产品


版本

R2018a

Community Treasure Hunt

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

Start Hunting!

Translated by