StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

POgrep, awk, bash and friends? any tool to munge this data?
text
Body
copied!<p>I'm searching through input to pull out specific info about each record. The sad thing is that each record is spread out over multiple lines, e.g. (simplified excerpt)</p> <pre><code>01238584 (other info) more info, more info [age=81][otherinfo][etc, etc] </code></pre> <p>The only thing I really care about is the identifier and the age (<em>01238584</em> and <em>81</em>, in the example). To be crystal-clear, the only regex I can reliably search for in the input to get close to these two lines is</p> <pre><code>\[age=[0-9]+\] </code></pre> <p>... and of course I want to print out that age along with the identifying record number from the line above it, e.g.</p> <pre><code> 01238584 81 </code></pre> <p>With all my sysadmin shell experience and decent awk mastery, I haven't come up with a solution yet. I can of course use <code>grep -B1</code> to get each set of lines, but then what? I always use awk for these kinds of things... but associated data is always in the same line. <em>sigh</em> This is definitely beyond my current awk skills.</p> <p>Thanks for reading. Got any pointers?</p> <hr> <p><em><strong>EDIT</em></strong><br> I'm going with Charlie's suggestion and changing awk's record separator, which I had never done before. It's not pretty, but neither is the input. Job is done.</p> <pre><code>egrep -B1 '\[age=[0-9]+\]' inputfile | awk ' BEGIN{ RS = "--" } { printf "%s %s\n", $1, gensub(/.*\[age=([0-9]+)\].*/, "\\1", 1) }' </code></pre>

Querying!

Guidance

An individual column

Larger individual text columns get their own page to allow for proper reading.

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