|We don't bite newbies here... much|
reformatting tab delimited fileby garyboyd (Acolyte)
|on Sep 05, 2011 at 14:54 UTC||Need Help??|
garyboyd has asked for the
wisdom of the Perl Monks concerning the following question:
Hi, could someone give me pointers/pseudocode for converting a tab-delimited file into a different format?
My data looks like this:
And I want to get it into this format:
The information in each row is separated by tabs and any field containing more than one eg Name_3 has two PA entries, will produce both entries separated by a comma.
If there is no entry a blank should be left or I suppose "No corresponding entry"