I'm working on this and I've decided to stop trying to do the xBase part. The reasons are too numerous to list. It's just not getting me anywhere. I'm going to solve this with Perl and some brainpower.I transferred all files to my Linux laptop and turned off my *other* operating system

I have better tools now, I have underestimated the text processing power I have. Anyways, here's my diagram that I've printed out for myself with the fixed positions that I will be using.

1234567890123456789012345678901234567890123456789012345678901234567890
+1234567890123456789012345678901234567890
         |         |         |         |         |         |         |
+         |         |         |         |
 aaaaaaaaaaaaaaaaa, aaaaaaaaaa        aaaaaaaaaaaaa, aaaaaaaaaaaaaa   
+    aaaaaaaaaaaa, aaaaaaaaaaaaaaa
 bbbbbbbbbbbbbbbbbbbbbbbbbbbbb        bbbbbbbbbbbbbbbbbbbbbbbbbbbbb   
+    bbbbbbbbbbbbbbbbbbbbbbbbbbbbb 
 ccccccccccccccccccccccccccccc        ccccccccccccccccccccccccccccc   
+    ccccccccccccccccccccccccccccc 
 ddddddddddd ee     99999-9999        dddddddd ee        99999-9999   
+    dddddddddd ee      99999-9999 
 |                  |                 |                  |            
+    |                  |
 2                  21                39                 58           
+    75                 94

[download]

Obviously you need to see the text without word-wrap, but you get the gist of it. The cool thing is that address1(b) and address2(c) can be grabbed as a fixed-length string and then chomped(?) or TRIMed in xBase.

The lastname(a) and firstname(a) fields need to be switched for the purposes of my new output needs.

The city(d) and state(e) can also be grabbed as a string of fixed length because I'm not interested in sorting them here.

Then I can jump directly to the zipcode position and grab 10 characters.

The issue with the intermittent 2nd address will have to wait.

The are *no* spaces between the labels. It's just one messy report.

Step 1: Figure out how to handle each line
Step 2: Learn to play with the array(s)
Step 3: Start picking out data from each line.

Then I'll do the loop and the output text file.

Be back in a few hours (I'd better make more coffee)

RF

In reply to Re: Re: Pattern Matching examples by Anonymous Monk
in thread Pattern Matching examples by renef

Title:
Use:  <p> text here (a paragraph) </p>
and:  <code> code here </code>
to format your post, it's "PerlMonks-approved HTML":


  • Posts are HTML formatted. Put <p> </p> tags around your paragraphs. Put <code> </code> tags around your code and data!
  • Titles consisting of a single word are discouraged, and in most cases are disallowed outright.
  • Read Where should I post X? if you're not absolutely sure you're posting in the right place.
  • Please read these before you post! —
  • Posts may use any of the Perl Monks Approved HTML tags:
    a, abbr, b, big, blockquote, br, caption, center, col, colgroup, dd, del, details, div, dl, dt, em, font, h1, h2, h3, h4, h5, h6, hr, i, ins, li, ol, p, pre, readmore, small, span, spoiler, strike, strong, sub, summary, sup, table, tbody, td, tfoot, th, thead, tr, tt, u, ul, wbr
  • You may need to use entities for some characters, as follows. (Exception: Within code tags, you can put the characters literally.)
            For:     Use:
    & &amp;
    < &lt;
    > &gt;
    [ &#91;
    ] &#93;
  • Link using PerlMonks shortcuts! What shortcuts can I use for linking?
  • See Writeup Formatting Tips and other pages linked from there for more info.