emacs-orgmode
[Top][All Lists]
Advanced

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

[O] how to compare strings of two columns for huge tables


From: Uwe Brauer
Subject: [O] how to compare strings of two columns for huge tables
Date: Wed, 13 Jun 2018 22:34:36 +0200
User-agent: Gnus/5.13 (Gnus v5.13) Emacs/26.0.50 (gnu/linux)


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




reply via email to

[Prev in Thread] Current Thread [Next in Thread]