[O] [SOLVED?] (was: how to compare strings of two columns for huge tables)

[Uwe Brauer]

>>> "Uwe" == Uwe Brauer <address@hidden> writes:

   > Hi

   > I have tables (several hundred rows) like this


   > | 03217428 |  3217428 |   |
   > | 71310606 | 71310606 |   |
   > | 05944371 |  5944371 |   |
   > | 70086251 | 70086251 |   |
   > | 50325182 | 50325182 |   |
   > | 04559101 |  4559101 |   |
   > | 51005420 | 51005420 |   |
   > | 51141846 | 51141846 |   |
   > | 05448640 |  5448640 |   |
   > | 06602597 |  6602597 |   |

   > #+TBLFM: $3=if("$1" == "$2", string("OK"))

   > So I would like to add a new column, which would return OK, if the
   > strings of each row of the to columns coincide. I tried 

   > #+TBLFM: $3=if("$1" == "$2", string("OK"))

   > But it did not work. I googled and looked up the manual, no help.

   > It seems a common problem for spreadsheet so I presume there must be an
   > solution but I am unable to find it and would appreciate any help.

   > Thanks 

   > Uwe Brauer


The following seems to work 

|   03217428 |    3217428 | NO |
|   71310606 |   71310606 | OK |
|   05944371 |    5944371 | NO |
|   70086251 |   70086251 | OK |
|   50325182 |   50325182 | OK |
|   04559101 |    4559101 | NO |
|   51005420 |   51005420 | OK |
|   51141846 |   51141846 | OK |
|   05448640 |    5448640 | NO |
|   06602597 |    6602597 | NO |
|          8 |          9 | NO |
| Hallo This | Hallo This | OK |
#+TBLFM: $3=if("$1" == "$2", OK, string("NO"))

smime.p7s
Description: S/MIME cryptographic signature