I have a few large CSV files that I am looking to process through the SearchBug API to obtain some results and then produce a CSV output file. For example, I have a CSV file that looks like this: [url removed, login to view] which contains about 100,000 rows of data. When I upload it, the app/script should ask me what row contains the phone number and what row contains the name. Then it should process the data via API calls as described here: [url removed, login to view] which is simply an API call such as: [url removed, login to view] The API will output some results such as: [url removed, login to view] If the "LandorCell" result says "Landline" then that record is ignored, however if the result is "CELLULAR" then the app/script will append to an output file the result such as number,name (Remember upon upload the app should ask us which field contains the name, because each CSV may have a number/name in a different row)
So an input CSV that looks like this: [url removed, login to view]
Would output something like this: [url removed, login to view]
Basically in summary I want to upload large CSV files, detect which lines have cell numbers listed then output those lines with cell numbers into a new csv file containing only the name,number from the original input line.
I am okay with a php script running on my server or a windows app to complete this.