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