Reading all text from specific cell from .csv file.

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).

[Walter Roberson]

Is it an excel sheet or is it a csv file? If it is a text file then is it comma separated or space or tab separated?

[Shivam Upadhyay]

It is csv file I am showing the table to you.

[Jakob B. Nielsen]

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]

CSV File is attached in this comment.

Answer 1

[Giuseppe Inghilterra]

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.

[Shivam Upadhyay]

Thanks brother.