Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
importing text file data into excel | Excel Discussion (Misc queries) | |||
Importing Text File Data into Excel where records span several row | Excel Discussion (Misc queries) | |||
Can I automatically replace data when importing a text file? | New Users to Excel | |||
Importing Selected Source Book Data | Excel Discussion (Misc queries) | |||
character restrictions when importing data from a text file | Excel Discussion (Misc queries) |