Im some what a perl noob so bear with me on this one. Im trying to parse out a csv file and store the contents of the various columns in a hash. The problem is that everywhere I have looked the various solutions are talking about csv files where the top row is the column headings and the columns are all in one line kinda like:
heading 1, heading 2, heading 3
data, data, data
data, data, data
I have a csv file were the different columns and headings are all over the place, such as:
heading 1, heading 2
data, data
data,
heading 3
data
heading 4, heading 5
data, data
Not sure if this will make sense or not, but basically I want to be able to call the heading name and get data that is in its column, sometimes there will be 20 lines of data and sometimes it just one data item in the column. Once i am able to store the data and call it I want to be able to create an xml file using the data. All of the heading names are enclosed with <> if that helps. Any ideas on a simple way to do this?