blackadder has asked for the wisdom of the Perl Monks concerning the following question:
Dear Gods
I wonder if you have a moment.
I have a data sheet containing the following column headers;
Your divine intervention is highly regarded....Thanks.
I wonder if you have a moment.
I have a data sheet containing the following column headers;
The data inside the table is of this nature;Srv_Name SAN_Info Criticality_rating Commission Date
And I need to consolidate the information pertaining to one entry in a single distinct record. Producing an output such as that;Srv_0A,xxxxxxxxx,,xxxxxxxxxxx Srv_0A,,, Srv_0G,,, Srv_0B,xxxxxxxxxx,,xxxxxxxxx Srv_0A,,,xxxxxxxxxxxxxx Srv_0G,xxxxxxxxxxx,xxxxxxxxxxxxxx, Srv_0B,,xxxxxxxxxxxxxx,
And All the entries that were not matched with any thing will be stored else were. I have spend a lot of thinking time but haven’t managed to come up with any ideas.Srv_0A,xxxxxxxxxxxxx,xxxxxxxxxxxx,xxxxxxxxxxxxxxxxxx Srv_0G,xxxxxxxxxxxxx,xxxxxxxxxxxx, Srv_0B, xxxxxxxxxxxxx,xxxxxxxxxxxx,xxxxxxxxxxxxxxxxxx
Your divine intervention is highly regarded....Thanks.
Blackadder
|
---|
Replies are listed 'Best First'. | |
---|---|
Re: Consolidating data from lots of different sources
by Zaxo (Archbishop) on Jun 08, 2005 at 21:57 UTC | |
Re: Consolidating data from lots of different sources
by ikegami (Patriarch) on Jun 08, 2005 at 21:54 UTC | |
Re: Consolidating data from lots of different sources
by Transient (Hermit) on Jun 08, 2005 at 21:47 UTC | |
Re: Consolidating data from lots of different sources
by tlm (Prior) on Jun 08, 2005 at 21:52 UTC | |
by ikegami (Patriarch) on Jun 08, 2005 at 22:04 UTC |
Back to
Seekers of Perl Wisdom