![]() |
searching a text file and importing selected data
I would like to search a text file and import only data matching the sample
below for todays date. Can it be done? <datex --------------------------------------- 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 |
All times are GMT +1. The time now is 08:25 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com