How to delete org-mode table separator | quickly?

Question

If I have the following text:

Name Score Bob 87 Ted 99 Mary 78

I know C-c | will covert it to org table. But how can I do the other way around?

If I have a org table already, how can I convert it to text block?

I originally thought I could use multiple-cursor to delete, but this is not that effective if the table is huge.

Anyone any ideas? Thanks

Answer 1

Somewhat inspired by org-table-transpose-table-at-point:

(defun org-table-strip-table-at-point ()
  (interactive)
  (let* ((table (delete 'hline (org-table-to-lisp)))
     (contents (orgtbl-to-generic
            table '(:sep "\t"))))
    (goto-char (org-table-begin))
    (re-search-forward "|")
    (backward-char)
    (delete-region (point) (org-table-end))
    (insert contents)))