Databases
StackOverflow2013
Postsdbo
POSed - conditional branching within an address range
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POSed - conditional branching within an address range
    primarykey
    data
    text
    <p>I needed to format a bulk entry file from some raw text data. I was able to achieve the bulk of my solution using <code>Sed</code>, which was/is preferred, but not absolutely required (I'd just like to stick to this one tool). The problem became clear when I got branch crazy trying to parse through [a much larger amount of] the following input:</p> <pre><code>---- Start Product ---- PartNumber&gt;&gt; 123457 Size04_Req&gt;&gt; 2 Size02_Req&gt;&gt; 1 PartColor&gt;&gt; Natural PartDescription&gt;&gt; Guys Tee ---- End Product ---- ---- Start Product ---- PartNumber&gt;&gt; TPIOO9205 Size05_Req&gt;&gt; 1 PartColor&gt;&gt; Natural PartDescription&gt;&gt; Black Hoodie ---- End Product ---- ###...with the objective of achieving the following output: ---- Start Product --- PartNumber&gt;&gt; 123457 Size01_Req&gt;&gt; 0 Size03_Req&gt;&gt; 0 Size05_Req&gt;&gt; 0 Size06_Req&gt;&gt; 0 Size04_Req&gt;&gt; 2 Size02_Req&gt;&gt; 1 PartColor&gt;&gt; Natural PartDescription&gt;&gt; Guys Tee ---- End Product ---- ---- Start Product ---- PartNumber&gt;&gt; TPIOO9205 Size01_Req&gt;&gt; 0 Size02_Req&gt;&gt; 0 Size03_Req&gt;&gt; 0 Size04_Req&gt;&gt; 0 Size06_Req&gt;&gt; 0 Size05_Req&gt;&gt; 1 PartColor&gt;&gt; Natural PartDescription&gt;&gt; Black Hoodie ---- End Product ---- </code></pre> <p>I do believe this is as simple as working within the address range <strong>/----\ Start\ Product\ ----/,/----\ End\ Product\ ----/</strong> and doing some elegant branch and :label work, but my inclination, obviously, is to jump on Awk or something for this logic - because I'm going nuts -- and it would be easier, perhaps, with another tool to achieve this. However, sticking to my original desire to stay with Sed, and because I like to learn me a new Sed trick any day, how might this be done? Notice that the logic is to insert <strong>SizeXX_Req>> 0</strong> for the sizes 01-06 that are not accounted for, and the order is not important, which is why I was thinking Sed could get even this last little part done semi-sanely. There will always be at least one <strong>SizeXX_Req</strong> line in between each Start/End Product section. Any Sed(i) Masters make quick work of this? Am I just geeking out from the boatload of regular expressions I've been writing lately and missing an easy fix?<br><br> Go ahead. Show me in another rando language without even explaining how (or why) you did, I'm down with that, too. Thanks in advance, peeps.</p>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. USBerti
    1. USBerti
    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. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. POSed - conditional branching within an address range
      1. This table or related slice is empty.
      1. VTApproveEditSuggestion
    1. COFixing the missing bits is, I think, beyond `sed` (or, at any rate, beyond sane `sed` or only mildly insane `sed`). You would do better with a full programming language — `awk`, `perl`, `python`, ...
      singulars
      1. POSed - conditional branching within an address range
      1. USJonathan Leffler
    2. COcomplicated logics are always well presented in other tools:awk or even start from scratch using scripting language. I would not preder sed underthis situation.
      singulars
      1. POSed - conditional branching within an address range
      1. USzinking
    3. COSo it is indeed beyond what one could accomplish in Sed? It seemed so to me, but I thought perhaps I was just reaching the boundaries of my personal skill with Sed rather than Sed itself. Only because :labels and branches seem, like, well, they can get 'deep', heh, ya know? [f]awk it, I will. But I'd still be tickled with some Sed trickery >:-) Anyone wanna drop the awk while I go shift gears? feel free!
      singulars
      1. POSed - conditional branching within an address range
      1. USBerti
 

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