Reading all text from specific cell from .csv file.

Question

Shivam Upadhyay 2020-2-17

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/505879-reading-all-text-from-specific-cell-from-csv-file

评论： 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更早的评论隐藏 2更早的评论

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?

Shivam Upadhyay 2020-2-17

dtc_table.csv

CSV File is attached in this comment.

请先登录，再进行评论。

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

Answer 1

Giuseppe Inghilterra 2020-2-21

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/505879-reading-all-text-from-specific-cell-from-csv-file#answer_416763

编辑：Giuseppe Inghilterra 2020-2-21

在 MATLAB Online 中打开

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