Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>Gawk would be better, with it's specific support for fixed width fields. (Look up the FIELDWIDTHS variable.)</p> <p>It's also easy to write the simple rules to filter out the garbage you will get.</p> <p>Here's a simple script that just gives you the "important" lines and the variable mappings from that report you linked to:</p> <pre><code>BEGIN { FIELDWIDTHS="4 4 7 5 1 7 1 1 23 4 10 2 1 2 8 1 6 1 4 1 6 1 2 1 2 1 2 1 4 2 10 1" } function cvt_amt(a) { gsub(",", "", a); amt = a * 1; return amt; } function empty(s) { gsub(" ", "", s); return s == ""; } /* skip garbage lines */ /----/ { next; } /CASH RECEIPTS REPORT/ { next;} /PERIOD ENTERED/ { next; } /^ *$/ { next; } ($2 == "CUST") { next; } ($2 == "NO. ") { next; } /CUSTOMER TOTALS/ { next; } /GRAND TOTALS/ { next; } /SUMMARY BY STATUS/ { nextfile; } /* end of stuff we care about */ /* Identify user */ (!empty($2)) { user_no = $2; user_name = substr($0, 10, 30); } { /* variable mapping */ cust_no = $2; vchr_no = $4; inv_no = $6; inv_no_sign = $7; inv_desc = $9; recv_amt = cvt_amt($11); st = $13; recv_date = $15; check_no = $17; period = $19; batch = $21; bank = $23; cc = $25; dp = $27; acct = $29; amt_recv = cvt_amt($31); sign = $32; if (sign == "-") { amt_recv = amt_recv * -1; } print; } </code></pre> <p>Frankly, I think this is pretty clean, but I'm a (g)awk fanboi.</p> <p>Edit -- I added some code to pull out the user number and name. User number is field 2 from the fixed fields, but the user name had to substr() out, since it overlaps many of the detail fields.</p>
    singulars
    1. This table or related slice is empty.
    1. POBest tools to parse reports
      singulars
      1. PTQuestion
    1. PTAnswer
    1. USWill Hartung
    1. USWill Hartung
    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. COyou can combine all your regex that have "next" action by using alternation:> `/----|CUSTOMER TOTALS|GRAND TOTALS|PERIOD ENTERED|.../{next}`
      singulars
      1. PO
      1. USghostdog74
    2. COWhen I run your script, I get the relevant lines, but one thing that I want to do is net out a line that has the account # and name replicated on all the relevant lines (1000 Bill's Supply Co and 1200 Bills' Computer)....any suggestions on how that could happen?
      singulars
      1. PO
      1. USAndy Schaefer
 

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