help deciding best method of parcing data for csv/excel

[rdp]

HI all,
         I found this product last week and the printer program works like a charm.  I would now like to get fancy and see if I can cut the printing process out together and upload the data directly.  I bought the advanced serial logger product (waiting for my key to be in the database to finish registering) but I'm not sure the best way to get the data I want.  The end result would be a CSV file that I can read into our SqL application and an excel spreadsheet for accounting.  below is an example of the output i get from the cradle now (please ignore trial version messages.

ACME STORES, INC.   04/18/2010  17:43    Page 1#0D#0A
                      POOL AUDIT100 packets trial version limit#0A

POOL LOCATION BLT     User ID D81

TRAILER# EEEEEEE129          MANIFEST # 345217   
SEAL# A144573   
 
STORE # 100 
   0131-0931-00-994892   0131-0931-00-994962   0131-0931-00-9949100
   0131-0931-00-995131   0131-0931-00-995138   0131-0931-00-9951100
   0131-0931-00-995188   0131-0931-00-995241   0131-0931-00-9952100
   0131-0931-00-995255   0131-0931-00-995256   0131-0931-00-9952100
   0131-0931-00-995260   0131-0931-00-995261   0131-0931-00-9952100
   0131-0931-00-995275   0131-0931-99-104083   0131-0931-99-1043100
   0131-0931-99-104382   0131-0931-99-107103   0131-0931-99-1071100
   0131-0931-99-107105   0131-0931-99-107140   0131-0931-99-1086100
   0131-0931-99-108707   0131-0931-99-108720   0131-0931-99-1087100
   0131-0931-99-108810   0131-0931-99-10100
   NUMBER OF CARTONS 00210

STORE # 101
   1267-0931-00-907553   1267-0931-00-907554   1267-0931-00-9075100
   1267-0931-00-907592   1267-0931-00-907597   1267-0931-00-9075100
   1267-0931-00-907599   1267-0931-00-907610   1267-0931-99-1034100
   1267-0931-99-104735   1267-0931-99-104736   1267-0931-99-1200100
   1267-0931-99-120065   1267-0931-99-12100
   NUMBER OF CARTONS 00110



TOTAL CARTONS 0777#0C

I don't see anything that starts the packets but it looks like everything ends with #0D#0A (they all don't show up because of the limit message
I was figuring that I could say packets start with #0A and end with #0D which would give me all the data except the very first line up to the date
The other odd thing is that the numbers under the store numbers
1267-0931-00-907553   1267-0931-00-907554   1267-0931-00-9075100
are treated as one line, not 3 separate numbers.  I'm not sure how i would split the individual numbers
out.  some numbers might be shorter but never longer than above.  The number of locations vary from store to store so i would probably have to key off of store# for the start and stop of the numbers.

My short term goal is to get an excel spreadsheet that looks like this
POOL LOCATION BLT     
User ID D81
TRAILER# EEEEEEE129         
MANIFEST # 345217 
SEAL# A144573
STORE # 100
0131-0931-00-994892
0131-0931-00-994892
0131-0931-00-994892
0131-0931-00-994892
NUMBER OF CARTONS 00210
STORE # 101
1267-0931-00-907553
1267-0931-00-907553
1267-0931-00-907553
1267-0931-00-907553
TOTAL CARTONS 0777#0C

where the location numbers are all now in their own cell under their respective stores.

My other goal would be a CSV file where all of the above data would be one comma delimited file and I should be able to use our data import tools to cut out the important data (Pool, trailer, seal, store number, total carton)

What would be the best parser/method to use to attempt something like this?  Am i asking too much of the parsing tools?

My programming days are far behind me but if it is possible i don't mind re-learning.  I do have some time before this becomes critical but not months.  I would rather start off in the right direction with the right parcer than go through all the options one by one.

I figure if i can only get one working I can create the CSV from the excel file or create the excel from the CSV.  I not sure which one would be easier.

thanks for your time.


 

[Arthur Grasin]

I'm sorry, but our parser can't do all that you need.

The parser can:

- extract rows and place it to CSV or Excel
or
- extract only numbers (0131-0931-00-994962) and place it to CSV or Excel without any other data

[rdp]

thanks for the reply. 

I think i might be able to use your product with another product to get the results i want