I try to generate mail drafts from a table as template-tokens. The Problem is that that org-mode seems to auto-format the salary column as a number. I don´t need to calc this numbers so saving/getting it as string would be what I want.
It not only butchers the string because he interprets the numbers behind of the . as decimal point, while in germany we use the "," for that, and the point as a way to mark thousends. But even if he would understand that the number is 5000 and not 5, if the outcommented replace-regexp throughs a error because its not string. To convert it back makes no sense, the fields will always be interpreted as replacement-strings. #+TBLNAME: jobs | jobname | city | salary | email | | Taxi-driver | New York City | 500.000 | ma...@gotham-city.com | | Butcher | Peking | 5.000 | jinp...@china.cn | #+SRC_NAME: generate_job_mails_from_table #+BEGIN_SRC emacs-lisp :var table=jobs header=jobs data=jobs[1:-1] :results output (setq column-length (length header)) (setq lines) (dolist (line data) (setq tmp-line) (dotimes (i column-length) (add-to-list 'tmp-line (cons (nth i header) (nth i line))) ; (print (nth i line) ) (add-to-list 'lines tmp-line) ) (message-mail) (setq line1 (car lines)) (insert (cdr (assoc "email" line1))) (message-goto-subject) (insert "applying for the job: $jobname") (dolist (var line1) ; (replace-regexp (concat "$"(car var)) (cdr var )) (print (cdr var)) ) #+END_SRC #+RESULTS: : : "jinp...@china.cn" : : 5.0 : : "Peking" : : "Butcher" btw, is there a easier way to generate this dict(python) like "lines" in elisp?