I have an excel file with approximately 65000 rows and 2 columns. Column A contains an invoice number and does not need to be modified. Column B contains a text description of the invoice. The text description for some invoices contains a 5-digit ticket number. Not all text descriptions contain a ticket number.
There is a small XLS file attached containng a sample set of 20 records.
I need to filter the excel file data so it only contains two columns. Column A should be the invoice number and column B should be the ticket number. Any records that do not contain a ticket number should be excluded from the set.
I hope this makes sense. Thanks!
## Deliverables
A flat text or excel file containing the data resulting from the filter described in the above description.
## Platform
Any