Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>There comes a point at which <code>sed</code> is no longer the correct tool for the <a href="https://stackoverflow.com/questions/366980/what-are-the-differences-between-perl-python-awk-and-sed">job</a>. I think this task has reached that point (but see the clever <a href="https://stackoverflow.com/questions/9053632/passing-part-of-patterns-from-sed-to-shell/9054367#9054367">answer</a> by <a href="https://stackoverflow.com/users/967492/potong">potong</a> which shows that it can be done with <code>bash</code> and <code>sed</code>).</p> <p>Which alternative tool do you use? You don't show the function, but if it can be conveniently calculated in the shell with a shell function, the chances are that <code>awk</code> is powerful enough to do the job. I'd probably fall back on Perl myself, but Python (or Ruby) would also work well. All of these allow you to write a function, to read the data and apply the function to the data before writing the data back out.</p> <p>The problem with trying to use a function in <code>sed</code>is that it has no mechanism to define functions or to execute shell functions. To use <code>sed</code>, you'd have to think in terms of two passes through the data, the first extracting the (unique) tokens for subsequent processing, which would be to apply the shell function to each token, <em>generating</em> a <code>sed</code> script which simply matches each token and substitutes it with its replacement, followed by applying that script in the second pass over the data.</p>
    singulars
    1. This table or related slice is empty.
    1. POPassing part of patterns from sed to shell
      singulars
      1. PTQuestion
    1. PTAnswer
    1. USCommunity
    1. USJonathan Leffler
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. POPassing part of patterns from sed to shell
      singulars
      1. PTQuestion
    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. VTAcceptedByOriginator
    3. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    1. COThank you for the suggestions Jonathan. Like I mentioned, I can write these functions (even in Python, Ruby etc.), but for long time, I was wondering if sed can export those parts back to shell. From your answer, the answer seems to be NO :-(
      singulars
      1. PO
      1. USSalil
    2. COCorrect - the answer is (for all practical purposes) No. If it was a life-or-death situation where Perl, Awk, Python could not be used, then a multi-step scheme could be devised using `sed`, `uniq`, `sort`, your shell function, etc. But unless there is an idiotic restriction on the tool set available, `sed` is not the correct answer this time.
      singulars
      1. PO
      1. USJonathan Leffler
 

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