3

I am not sure how to describe this problem so I am giving some example

Without Semi-colon

| John | Snow | John Snow |
| John | Doe  | John Doe  |
| Mery | Jane | Mery Jane |
#+TBLFM: $3='(concat $1 " " $2)

The result is as expected

With Semi-colon

| John | Snow | " $2) |
| John | Doe  | " $2) |
| Mery | Jane | " $2) |
#+TBLFM: $3='(concat $1 ";" $2)

What I expected was -

| John | Snow | John;Snow |
| John | Doe  | John;Doe  |
| Mery | Jane | Mery;Jane |
#+TBLFM: $3='(concat $1 ";" $2)

Can anyone explain this? and also how to solve this problem.

  • 3
    I can reproduce. This is obviously a bug thus I suggest reporting a bug to the org mode mailing list instead. – xuchunyang Mar 5 '18 at 11:51
  • It appears that org-table-eval-formula simply searches for the first ";" as a delimiter between formula and format string. – Juancho Mar 5 '18 at 19:38
  • so there's no workaround? – th1rdey3 Mar 6 '18 at 4:28
2

This doesn't look beautiful at all, but just for solving the issue...

You can use

(string 59)

or

"\u003B"

instead of ";". ASCII number 59 (3B in hexadecimal) stands for semicolon. For other special chars like period, single-quote etc., the same method will work as well.

  • You can also use "\u003B" (which also works inside constants). – Stefan Sep 29 '18 at 17:48
  • \u003B looks much better! this helped me as well, thanks – Mick O'shey Sep 29 '18 at 20:41

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.