For a certain app I need te following functionality:
A csv with multiple lines is stored in a place. I need a script that takes this csv for every line looks to a certain filed. This field contains a word( 2nd field, actually a product or department name). Based on this word, a new csv file with only this line in it must be made and mailed to a mailaddress that belongs to the Word mentioned above.
I am looking for a script (either c, shell or perl) which can help me handling this csv data?
Does anyone know of such a thing?
If someone gives me a running script which actually (more or less) does the thing mentioned above I'll raise the points to 600. I someone wants to give it a try, tekstfields are surrounded by double quotes in this csv.