Help with importing data

[cmarchman]

Here's the situation:

I've got a file that has been arranged in the following manner;

Session|

http://xxx.xxx.xxx.xxx:80/<directory>/<etc.>/|xxx.xxx.xxx.xxx/80

(this is on a single line)
Issue|3508|IP Disclosure|20|<summary of issue>|<execution of issue>|<implication of issue>|<solution to issue>|<references (this is one a long single line)
Issue|45|Directory found (<directory>)|25||<summary of issue>|<execution of issue>|<implication of issue>|<solution to issue>|<references ( and this is on a long single line )

Session|

http://xxx.xxx.xxx.xxx:80/<etc.>

Issue|<etc.>
Issue|<etc.>
Issue|<etc.>

Session| (I think you get the picture)

I am trying to write a script in Perl DBI to place the data of the Session line into a table "Sessions", then have the data of the Issue line put into a table "Issues" and have an association between the Sessions and Issues tables as per the "

http://xxx.xxx.xxx.xxx:80/<directory>/<etc.>/"

which is the URL that was tested.

Any ideas are welcomed.

Thanks,

cmarchman