eliminting certain rows
Posted: Tue Jul 04, 2006 10:43 am
hi,
i am having big probs with this data,i get a flat file with a data on product codes,like soapcode,pastecode,transactioncode,drinkscode,winecode and so on..everytime the transaction of any of these products go thru it will create a respective code,,but i dont need winecode and pastecode, beside that i need all the codes generated in that column, can someone pls help me to know how to filter those 2 records and move all other recors.
thanks in anticipation
prashant
i am having big probs with this data,i get a flat file with a data on product codes,like soapcode,pastecode,transactioncode,drinkscode,winecode and so on..everytime the transaction of any of these products go thru it will create a respective code,,but i dont need winecode and pastecode, beside that i need all the codes generated in that column, can someone pls help me to know how to filter those 2 records and move all other recors.
thanks in anticipation
prashant