blackadder has asked for the wisdom of the Perl Monks concerning the following question:
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
|
|---|
| 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 |