Hi all,<div><br></div><div>I have some data like:</div><div><div>CITY|STATE|ZIP</div><div><div>SCHAUMBURG|IL|60194</div><div>MATTESON|IL|60443</div></div><div>WARRENTON|OR|97146</div><div>MOUNTAIN HOME|AR|72653</div><div>FORT WORTH|TX|76107</div>
<div>CLEVELAND|MS|38732</div><div>WATERTOWN|SD|57201</div><div>GRAND CHUTE|WI|54913</div></div><div><br></div><div>I want to load it into a relational database in such a way that I have the proper keys to build a hierarchy.</div>
<div><br></div><div>so for example:</div><div><div>ID<span class="Apple-tab-span" style="white-space:pre"> </span>Name<span class="Apple-tab-span" style="white-space:pre"> </span>ParentID</div><div>0<span class="Apple-tab-span" style="white-space:pre"> </span>USA<span class="Apple-tab-span" style="white-space:pre"> </span></div>
<div>1<span class="Apple-tab-span" style="white-space:pre"> </span>IL<span class="Apple-tab-span" style="white-space:pre"> </span>0</div><div>2<span class="Apple-tab-span" style="white-space:pre"> </span>SCHAUMBURG<span class="Apple-tab-span" style="white-space:pre"> </span>1</div>
<div>3<span class="Apple-tab-span" style="white-space:pre"> </span>60194<span class="Apple-tab-span" style="white-space:pre"> </span>2</div><div>4<span class="Apple-tab-span" style="white-space:pre"> </span>MATTESON<span class="Apple-tab-span" style="white-space:pre"> </span>1</div>
<div>5<span class="Apple-tab-span" style="white-space:pre"> </span>60443<span class="Apple-tab-span" style="white-space:pre"> </span>4</div><div>6<span class="Apple-tab-span" style="white-space:pre"> </span>OR<span class="Apple-tab-span" style="white-space:pre"> </span>0</div>
<div>7<span class="Apple-tab-span" style="white-space:pre"> </span>WARRENTON<span class="Apple-tab-span" style="white-space:pre"> </span>6</div><div>8<span class="Apple-tab-span" style="white-space:pre"> </span>97146<span class="Apple-tab-span" style="white-space:pre"> </span>7</div>
<div>...</div></div><div><br></div><div>I'm not sure of a good way to do this.</div><div><br></div><div>I read the data an built a hash like:</div><div>USA => {IL => {SCHAUMBURG => {60194 => 0},</div><div>
<span class="Apple-tab-span" style="white-space:pre"> </span> MATTESON => {60443 => 0}},</div><div><span class="Apple-tab-span" style="white-space:pre"> </span>OR => {WARRENTON => {97146 => 0}}</div>
<div><span class="Apple-tab-span" style="white-space:pre"> </span>...</div><div><span class="Apple-tab-span" style="white-space:pre"> </span>};</div><div><br></div><div>I can't think of a good way to look through it and assign the keys. </div>
<div><br></div><div>Maybe someone has done this in the past and has an elegant solution?</div><div><br></div><div>Thanks</div><div>Jay</div>