[thelist] Asp Split
Rob Smith
rob.smith at lexjet.com
Tue May 23 09:06:01 CDT 2006
> 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
More information about the thelist
mailing list