
angeeze
New User
Nov 4, 2012, 7:48 AM
Post #1 of 5
(9201 views)
|
Parse csv file
|
Can't Post
|
|
I am looking for a program to parse info from a csv file. Those fields are: title text, reference text not null primary key, location text, hours text, wage text, work_pattern text, employer text, employer_ref text, pension text, duration char, -- P or T or NULL closing_date date, description text, apply text, added date not null default current_date, office_code char(3) I need a program that would check the location , if the location is "manchester" , output location and also output the information contained in the apply field. The location also contains a postcode , and I would like to have a total of all the number of postcodes , eg M1 5(occurances) M4 7(occurances) M21 3(occurances). I am unfortunately very new to perl. Any help in finding a program that does this would be very helpful. Thanks in advance.
|