all messages for Emacs-related lists mirrored at yhetil.org
 help / color / mirror / code / Atom feed
* how to remove parentheses from the output of a source code block
@ 2022-09-28  3:17 Andrés Ramírez
  2022-09-28  4:01 ` Greg Minshall
  0 siblings, 1 reply; 4+ messages in thread
From: Andrés Ramírez @ 2022-09-28  3:17 UTC (permalink / raw)
  To: emacs-orgmode

Hi.

I have this file:
--8<---------------cut here---------------start------------->8---
* labels table
** work on this file then move the output to the required buffers
#+name: source-in-table
| ID | MACRO_SRC_CODE_HEADER | LANGUAGE1_HEADER | LANGUAGE2_HEADER |
|----+-----------------------+------------------+------------------|
|  1 | LABEL_YES             | Si               | Yes              |
|  2 | LABEL_NO              | No               | No               |
** generate sql
#+BEGIN_SRC emacs-lisp :var table=source-in-table :results value raw
  (let ((sqlcode (mapcar (lambda (row) 
                           (concat "INSERT or ignore INTO labels_catalog (id, macro, language1, language2) VALUES ("
                                   (number-to-string (nth 0 row)) ", '" (nth 1 row) "', '" (nth 2 row) "', '"
                                   (nth 3 row) "');\n")
                           ) table)))
    sqlcode)
#+END_SRC
--8<---------------cut here---------------end--------------->8---

The above file generates this output:
--8<---------------cut here---------------start------------->8---
#+RESULTS:
(INSERT or ignore INTO labels_catalog (id, macro, language1, language2) VALUES (1, 'LABEL_YES', 'Si', 'Yes');
 INSERT or ignore INTO labels_catalog (id, macro, language1, language2) VALUES (2, 'LABEL_NO', 'No', 'No');
)
--8<---------------cut here---------------end--------------->8---

How could be removed the parentheses from the output?

Best Regards


^ permalink raw reply	[flat|nested] 4+ messages in thread

end of thread, other threads:[~2022-09-29 18:09 UTC | newest]

Thread overview: 4+ messages (download: mbox.gz follow: Atom feed
-- links below jump to the message on this page --
2022-09-28  3:17 how to remove parentheses from the output of a source code block Andrés Ramírez
2022-09-28  4:01 ` Greg Minshall
2022-09-28  6:42   ` Greg Minshall
2022-09-29 17:52   ` andrés ramírez

Code repositories for project(s) associated with this external index

	https://git.savannah.gnu.org/cgit/emacs.git
	https://git.savannah.gnu.org/cgit/emacs/org-mode.git

This is an external index of several public inboxes,
see mirroring instructions on how to clone and mirror
all data and code used by this external index.