Forum Discussion

krkarthik_info's avatar
krkarthik_info
Frequent Contributor
9 years ago

How to compare the cell value in excel file?

Hi All,   I am having two excel files with column Formula. Columns having the data like below   Formula in Excel 1 Formula in Excel 2 C₂₁H₂₁O₆ C21H21O6 C₂₂H₂₂O₂F³²S C22H22O2F[32]S ...
  • krkarthik_info's avatar
    krkarthik_info
    9 years ago

    Hi All, 

     

    I have come with a workaround to compare the value character by character, by getting its Unicode character. Figured out the below Unicode characters for digits, subscript digits and superscript digits as below:

     

    For Digits[1-9]:

    1 – 49, 2 – 50, 3 – 51, 4 – 52, 5 – 53, 6 – 54, 7 – 55, 8 – 56, 9 – 57

     

    For Subscript Digits[1-9]:

    1 – 8321, 2 – 8322, 3 – 8323, 4 – 8324, 5 – 8325, 6 – 8326, 7 – 8327, 8 – 8328, 9 – 8329

     

    For Superscript Digits[1-9]:

    1 – 185, 2 – 178, 3 – 179, 4 – 8308, 5 – 8309, 6 – 8310, 7 – 8311, 8 – 8312, 9 – 8313

     

    Thanks all for the suggestions.

     

    Thanks,

    Karthik K R

Colin_McCrae's avatar
Colin_McCrae
Community Hero

So you're reading in the value and then comparing them? So probably as strings? (I suspect that depends how the cells in Excel are formatted)

 

In which case, my original answer stands, you're going to have to do some standardisation of the notation if you want a simple string compare to work. A bunch of "Replace" type statements would work, but it feels like there should be a more efficient way? But nothing is immediately coming to mind ....

krkarthik_info's avatar
krkarthik_info
Frequent Contributor
9 years ago

Yes. You are right Colin.

 

I am also thinking for a different solution to solve this.

 

Thanks,

Karthik K R