NaN ouput on using string2double function for an OCR-ed output string

I have attached a snapshot of file showing undesirable result, as when I use string2double function the output I am getting is NaN...

I want to compare this string with a string obtained from excel sheet.

Kindly help where I am going wrong with this...

I am new to this so... any help would be greatly appreciated.

Thanks again.

[madhan ravi]

Duplicate - https://in.mathworks.com/matlabcentral/answers/461056-how-to-extract-data-from-an-excel-file-to-be-compared-with-an-output-of-an-ocr-ed-image

Answer 1

[Sulaymon Eshkabilov]

Hi,

Usually when you import/read data from the Excel spreadsheet, empty cells/boxes of the Excel Spreadsheet from where you are importing your data appears to have NaN (non a number) that can be eliminated by substituting with 0's. E.g. if your imported data variable into MATLAB workspace is called: acntColm contains NaN's and thus, you should use the followings to remove NaN's and substitute them with 0's.

>>IND = find(isnan(acntColm));

>> acntColm(IND) =0;

These substitute all NaN's with 0's.

Good luck.