BCT e and f

We receive a csv file weekly which needs to be modified and outputted into 2 csv files as per my instructions. FAXBCT is the original file - we will always have it in this format.? We need a program to do the following: Any row that has "EMAIL" in column G....create a sepearate file with just the email address from those lines (sample output attached) called [login to view URL] Every other row - export, columns D, B and C (in that order as A B and C in the new file)....remove anything that is a "0" in the original D column (sample output attached) ## Deliverables none