[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
- [O] how to compare strings of two columns for huge tables,
Uwe Brauer <=