how to format a flat file to database table

Anonymous Monk has asked for the wisdom of the Perl Monks concerning the following question:

i have data in this format

id:12345
name: che1 identifier
def: "chemical Identifier or CI numbers for molecules." 
subset:chemi slim
synonym: "chemical Identifier cI" E[]
synonym: "chemical Identifier c2" EXACT alternate []
synonym: "chemical Identifier c3" EXACT short []
xref: id-validation-regexp:\"[0-9\]+\"
[download]

I need the out put as

12345,che1 identifier
12345,chemical Identifier cI
12345,chemical Identifier c2
12345,chemical Identifier c3
[download]

Thanks

Comment on how to format a flat file to database table Select or Download Code

Replies are listed 'Best First'.
Re: how to format a flat file to database table by GrandFather (Saint) on Feb 27, 2009 at 05:24 UTC
Take a look at DBD::AnyData. It is able to be configured to read pretty much any regular flat file format and convert it to any one of a number of databases. True laziness is hard work	[reply]
Re: how to format a flat file to database table by Anonymous Monk on Feb 27, 2009 at 04:57 UTC
i basically need id Followed by name or synonym	[reply]