Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>This is not <em>exactly</em> the answer, but this is how I was doing it:</p> <ol> <li><p>Align on &amp;, for example: <kbd>C-x . &amp;</kbd>.</p></li> <li><p>Select the entire column I need using regular selection commands.</p></li> <li><p>Cut a rectangular area by using <kbd>C-x r k</kbd>.</p></li> </ol> <p>This is not super automatic, but given some exercise isn't really a hurdle, except, perhaps, if you have to re-format some old document and make a lot of changes all at once.</p> <p><strong>EDIT</strong></p> <pre class="lang-lisp prettyprint-override"><code>(defun latex-merge-next-column (start end column) "Works on selected region, removes COLUMN'th ampersand in every line in the selected region" (interactive "r\nnColumn to merge: ") (labels ((%nth-index-of (line) (let ((i -1) (times 0)) (while (and (&lt; times column) i) (setq i (position ?\&amp; line :start (1+ i)) times (1+ times))) i))) (let ((region (split-string (buffer-substring start end) "\n")) amp-pos replacement) (dolist (line region) (setq amp-pos (%nth-index-of line) replacement (cons (if amp-pos (concat (subseq line 0 amp-pos) (subseq line (1+ amp-pos))) line) replacement))) (kill-region start end) (insert (mapconcat #'identity (reverse replacement) "\n"))))) </code></pre> <p>This would work on the selected region and remove the n'th ampersand in every line. You could bind it to some key that is comfortable for you, say:</p> <pre class="lang-lisp prettyprint-override"><code>(global-set-key (kbd "C-c C-n") 'latex-merge-next-column) </code></pre> <p>Then <kbd>C-c C-n 2</kbd> would remove every second ampersand in the selected lines.</p>
    singulars
    1. This table or related slice is empty.
    1. POEmacs & LaTeX: amount of columns for tables/matrices/arrays
      singulars
      1. PTQuestion
    1. PTAnswer
    1. USN.N.
    1. This table or related slice is empty.
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    2. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    1. COI am sorry, could you explain more? I cannot get my head around what this should be doing/how it works.
      singulars
      1. PO
      1. USPascalVKooten
    2. COVery nice! Thank you for the effort. I will probably make a function/macro from this :). Since indeed this is not the entire answer, I am going to give others a chance to give a complete answer.
      singulars
      1. PO
      1. USPascalVKooten
    3. COI will make a macro that will search backwards for a "\begin{", go down one line, start the mark with C-U space, search forward for "\end{", then use your "C-c C-." for & and \\, then pop the mark, save as macro and bind to key.
      singulars
      1. PO
      1. USPascalVKooten
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload