[thelist] Asp Split

[Tab Alleman]

Why not use the MID() function to get the 22-23 characters in each line (and another for the 1-2 characters)?

I once did something like that in an EDI interface I wrote in ASP.  

> -----Original Message-----
> From: thelist-bounces at lists.evolt.org
> [mailto:thelist-bounces at lists.evolt.org]On Behalf Of Rob Smith
> Sent: Tuesday, May 23, 2006 10:06 AM
> To: thelist at lists.evolt.org
> Subject: Re: [thelist] Asp Split
> 
> 
> > What are you doing that requires an array of characters? 
> 
> :-\ *gulp*
> 
> In a nutshell, we're receiving a export.po file every 15 minutes that
> contains 60 characters or columns per line that contains information
> about the confirmation of our orders sent to third-party 
> warehouse drop
> ship solution that looks like: 
> 
> HR12345600019000012700020768601723BALSACCEPTED 09BBBDG*15:15
> HI12345600019000012800PO-601723       ACCEPTED              
> A112345600019000012900                ACCEPTED              
> A212345600019000013000                ACCEPTED              
> A312345600019000013100                ACCEPTED              
> A412345600019000013200                ACCEPTED              
> A512345600019000013300                ACCEPTED              
> A612345600019000013400                ACCEPTED              
> CI12345600019000013500                ACCEPTED              
> DT 00007312Z1000013600EPST544600      ACCEPTED              
> 
> There are hundreds of these per file.
> 
> Each grouping or set of characters per row has a different 
> meaning. The
> first row columns 1 and 2 is the HR or Header Row. Columns 3 through 8
> is our account number. Columns 9 through 13 is the 
> transmission number.
> And so on and so forth. 
> 
> The columns I'm really trying to isolate are cols 21 and 22. 
> That's the
> confirmation codes. Based upon the first two characters of each row,
> tells me how to handle each row in tandem with the conf codes.  
> 
> I need an array of characters to correctly parse the export file. 
> 
> In the end this is going to save our company and the company we're
> working with about $70k per year in overhead thanks to a little custom
> ASP/VBScript split function.
> 
> Rob Smith
> LexJet
> rob.smith at lexjet.com
> http://www.lexjet.com
> (800)453-9538
> (941)330-1210 Int'l
> (941)330-1220 Fax
> 1680 Fruitville Road, 3rd Floor
> Sarasota, FL 34236
> 
> -- 
> 
> * * Please support the community that supports you.  * *
> http://evolt.org/help_support_evolt/
> 
> For unsubscribe and other options, including the Tip Harvester 
> and archives of thelist go to: http://lists.evolt.org 
> Workers of the Web, evolt ! 
>