Brethren,

Normally I would try to figure this out, but I'm in a hurry so burdened with work atm. (one big project with a impossible deadline, 2 "can you please tweak that script to do x instead of y, can't be much" (but is), and i'm in charge to do the hardware operators work as long he is in holliday (which means running around cleaning printers ans stuff) And so i have to ask for assistance.

I have data in a table that looks like this:

1. digit

1	Darth Vader
3	Luke Skywalker
5	Obi Wan Kenobi

2. digit

0	Lighsabre
5	Blaster
9	Rocket launcher

3./4. digit

10	Dagobah
14	Kashyyyk

what boils down to this data structure.

@data = 
(
    [
        [1, "Darth Vader"],
        [3, "Luke Skywalker"],
        [5, "Obi Wan Kenobi"],
    ],[
        [0, "Lighsabre "],
        [5, "Blaster"],
        [9, "Rocket launcher"],
    ],[
        [10, "Dagobah"],
        [14, "Kashyyyk"],
    ],
);
[download]

Now I need to shuffle this until I get the data in the form:

1010\tDarth Vader, Lightsabre, Dagobah
1510\tDarth Vader, Blaster, Dagobah
....
5914\tObi Wan Kenobi, Rocket Launcher, Kashyyyk
[download]

So I can put that stuff into two fields of a database.

__END__
[download]

---

---

• Are you posting in the right place? Check out Where do I post X? to know for sure.
• Posts may use any of the Perl Monks Approved HTML tags. Currently these include the following:

  <code> <a> <b> <big> <blockquote> <br /> <dd> <dl> <dt> <em> <font> <h1> <h2> <h3> <h4> <h5> <h6> <hr /> <i> <li> <nbsp> <ol> <p> <small> <strike> <strong> <sub> <sup> <table> <td> <th> <tr> <tt> <u> <ul>

• Snippets of code should be wrapped in <code> tags not <pre> tags. In fact, <pre> tags should generally be avoided. If they must be used, extreme care should be taken to ensure that their contents do not have long lines (<70 chars), in order to prevent horizontal scrolling (and possible janitor intervention).
• Want more info? How to link or How to display code and escape characters are good places to start.