searching a text file and importing selected data

B

brian

I would like to search a text file and import only data matching the sample
below for todays date. Can it be done?

<date>x
---------------------------------------
CLOSE CLOSE CLOSE CLOSE CLOSE
TRAN = 0016A 10-23-2007 19:58
---------------------------------------
TOTAL 0.00 TOTAL 0.00
TOTAL TAX: 0.00
---------------------------------------
CASH SALE: 150.00 1
CHECK SALE: 0.00 0
CREDIT SALE: 0.00 0
DEBIT SALE: 0.00 0
GIFT CARD SALE: 0.00 0
SALE: 0.00 0
CASH RETURN: 0.00 0
CHECK RETURN: 0.00 0
CREDIT RETURN: 0.00 0
DEBIT RETURN: 0.00 0
GIFT CARD RETURN: 0.00 0
RTRN: 0.00 0
NET SALES: 150.00
TOTAL TAX: 0.00
GROSS SALES: 150.00
TIPS: 0.00
CASH BACK: 0.00
SUB REG CASH: 150.00
CASH DROPS/PULLS: 0.00 0
+ CASH FUND: 100.00
CASH IN REG: 250.00
CHECKS IN REG: 0.00
CREDIT IN REG: 0.00
DEBIT IN REG: 0.00
/REG: 0.00
TOTAL PAYOUTS: 0.00 0
TOTAL DISCOUNTS: 0.00 0
TOTAL REDUCTIONS: 0.00 0
TOTAL COUPONS: 0.00 0
TOTAL VOIDS: 0.00 0
TOTAL GIFT CARDS: 0.00 0
SALES TRANSACTIONS: 1
RETURN TRANSACTIONS: 0
PAYOUT TRANSACTIONS: 0
NO SALE TRANSACTIONS: 0
GIFT CARD TRANSACTIONS: 0
TRANSACTION TOTAL : 1
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top