Hi, I am working with a friend to use gui automation software to build a tree structure. The software looks for the name of a parent node, and adds a child to it. A simple parent child spreadsheet works for the most part. The problem is that if a node farther down the list shares the same name as a previous parent (or child for that matter), the automation software doesn't know which node to look for in order to add the child.

I'm looking for a process where I can:

1. look at each node (parent or child), and append a unique identifier if that node name exists already elsewhere.

2. The exception being that a parent node should have all its children assigned to it!

The input file is ordered in the way that the automation script would build the tree, so it is apparent which children go with with parents.

For example (and this is just to show the behavior) 

Root:For Her
For Her:Clothes -- Clothes would be marked as a child
For Her:Pants -- Pants would be marked as a child 
For Her:Shirts -- Shirts would be marked as a child
.
.
.
Scarves:For Her  -- 'For Her' is new, and should be unique.
Root:Clothes -- 'Clothes' here is new, and should be unique

[download]

Any tips would be much appreciated!!

In reply to Creating tree with unique categories out of parent-child pointer list by bryank

Title:
Use:  <p> text here (a paragraph) </p>
and:  <code> code here </code>
to format your post, it's "PerlMonks-approved HTML":


  • Posts are HTML formatted. Put <p> </p> tags around your paragraphs. Put <code> </code> tags around your code and data!
  • Titles consisting of a single word are discouraged, and in most cases are disallowed outright.
  • Read Where should I post X? if you're not absolutely sure you're posting in the right place.
  • Please read these before you post! —
  • Posts may use any of the Perl Monks Approved HTML tags:
    a, abbr, b, big, blockquote, br, caption, center, col, colgroup, dd, del, details, div, dl, dt, em, font, h1, h2, h3, h4, h5, h6, hr, i, ins, li, ol, p, pre, readmore, small, span, spoiler, strike, strong, sub, summary, sup, table, tbody, td, tfoot, th, thead, tr, tt, u, ul, wbr
  • You may need to use entities for some characters, as follows. (Exception: Within code tags, you can put the characters literally.)
            For:     Use:
    & &amp;
    < &lt;
    > &gt;
    [ &#91;
    ] &#93;
  • Link using PerlMonks shortcuts! What shortcuts can I use for linking?
  • See Writeup Formatting Tips and other pages linked from there for more info.