<div dir="ltr"><p class="MsoNormal"><span lang="EN-US">Hello, I
          need some advice:</span></p>
      <p class="MsoNormal"><span lang="EN-US">I use 2 different
          suppliers of trunk SIP in my infrastructure, both send me
          regularly prices in a
          .csv format.</span></p>
      <span lang="EN-US"></span><span lang="EN-US"></span>
      <p class="MsoNormal"><span lang="EN-US">
          <span style="white-space:pre-wrap">So I have two SQL tables that contain the prefix and the
tariff.</span> </span></p>
      <span lang="EN-US"></span><span lang="EN-US"></span>
      <p class="MsoNormal"><span lang="EN-US">
          <span style="background:rgb(248,249,250)"><span style="white-space:pre-wrap">For now, I generate a dialplan with a Perl script that allows
me to select the prefix trunk to use but the problem is that I change it
manually in some cases</span>.</span></span></p>
      <p class="MsoNormal"><span style="background:rgb(248,249,250)" lang="EN-US">For example</span><span lang="EN-US"></span></p>
      <p class="MsoNormal"><span lang="EN-US">Trunk A:<br>
              +355           
              0.1698€<br>
              +35521150     0.12815€<br>
              +35521151     0.12815€<br>
          <br>
          Trunk B:<br>
              +355           
              0.1144€</span></p>
      <p class="MsoNormal"><span lang="EN">Currently my script sees that +35521150 exists
          in Trunk A and will
          therefore use it while on the Trunk B it is less expensive but
          the prefix
          +35521150 is not directly indicated since it is covered by the
          +355</span></p>
      <span lang="EN-US"></span><span lang="EN-US"></span>
      <p class="MsoNormal"><span lang="EN-US">
          <span style="background:rgb(248,249,250)"><span style="white-space:pre-wrap">I would like to change that, generate a unique table of
prefixes. </span></span><span style="background:rgb(248,249,250)">Someone would
            have
            done that already?</span></span><span lang="EN"></span></p>
      <p class="MsoNormal"><span lang="EN-US">Thank you,</span></p></div>