I have 75 files (sample attached). I need the files split in the following way. At the top part of the file is a list of IPs. I need those just dumped into a CSV file.
The second section of the file contains data in multiple columns.
Column A first row - contains a single IP
Column A & B underneath (row 2-n) contains an infection name & date
Column C first row contains a risk score (replicated 3 times, just need one)
Column C row 2 contains company name
Column C row 3 contains domain
Column C row 4 contains region
Column C row 5 contains asn
Column C row 6 sometimes contains a proxy with a type
I need this data in a seperate CSV.
I have 75 files roughtly and it's about 16MB of data uncompressed. It should be relatively easy to extract, you can probably do it with a macro in excel or with just straight code.
## Deliverables
Sample file attached.