finding a text in a flat file
717817Jan 20 2010 — edited Jan 22 2010Hello experts,
I have a file that contains lots of data for particular retailers
My file has the following format. i have to import that in a table.
My question is as follows: Is it possible to identy a word in a text file and then take the number after that word ( eg i need to retreive the retailer number and save it in a retailer number column in my table)
Any help or guide will be really appreciated. Thanks in advance :)
CDC:00374 / Sat Jan-09-2010 Daily Sales Detail Sat Jan-09-2010 22:06:22
----------------------------------------------------------------------------------------------------------------------------------
Retailer Number: 200116 Terminal Number: 20011600 Retailer Name: Aman Snack
Refunds-- Free Prize Issued ------Free Promo----- ----Promo Credits---- ---Returns--- -----Net----- ----Sales---- -----Cash---- -------Net------
Product Cnt Amount Cnt Cash Value Cnt Cash Value Cnt Amount ---Commiss--- Discounts ---Commiss--- ---Commiss--- -------Due------
=============== ================ ============= ======= ============== ======= ================= =======
X 26,160.00 0.00 0 0.00 8 -910.00 0 0.00 0 0.00 0 0.00 0 0.00 0 0.00 0 0.00 0 0.00 0 0.00 0.00 0.00 -1,308.00 -9.00 23,933.00
Y 14,000.00 0.00 0 0.00 123 -10,840.00 0 0.00 0.00 0 0.00 0 0.00 0 0.00 0 0.00 0 0.00 0 0.00 0.00 0.00 -700.00 -72.00 2,388.00
Retailer Number: 200117 Terminal Number: 20011700 Retailer Name: Best For Less Company Ltd
Refunds-- Free Prize Issued ------Free Promo----- ----Promo Credits---- ---Returns--- -----Net----- ----Sales---- -----Cash---- -------Net------
Product Cnt Amount Cnt Cash Value Cnt Cash Value Cnt Amount ---Commiss--- Discounts ---Commiss--- ---Commiss--- -------Due------
=============== ================ ============= ======= ============== ======= ================= =======
X 26,160.00 0.00 0 0.00 8 -910.00 0 0.00 0 0.00 0 0.00 0 0.00 0 0.00 0 0.00 0 0.00 0 0.00 0.00 0.00 -1,308.00 -9.00 23,933.00
Y 14,000.00 0.00 0 0.00 123 -10,840.00 0 0.00 0.00 0 0.00 0 0.00 0 0.00 0 0.00 0 0.00 0 0.00 0.00 0.00 -700.00 -72.00 2,388.00