title: Scan for all .csv in current folder and add new column to be populated later based on a previous column string
body: <p>I have lots of CSV files with 3 columns where I need to add a 4th one preferably with a batch script or Powershell.</p>
  <p>On the 4th column I should add the following string extracted between HTTPs:// and .shopdomain...</p>
  <p>This is how it looks now when opening on a table environment:</p>
  <div class="s-table-container">
  <table class="s-table">
  <thead>
  <tr>
  <th style="text-align: center;">ID</th>
  <th>buyer</th>
  <th>item url</th>
  </tr>
  </thead>
  <tbody>
  <tr>
  <td style="text-align: center;">01</td>
  <td>Tom</td>
  <td>https://safariland.shopdomain.com/fghj/shoes</td>
  </tr>
  <tr>
  <td style="text-align: center;">02</td>
  <td>Sam</td>
  <td>https://beastofshoes.shopdomain.com/ukgl/offers/1424</td>
  </tr>
  </tbody>
  </table>
  </div>
  <p>And how it should look after new column:</p>
  <div class="s-table-container">
  <table class="s-table">
  <thead>
  <tr>
  <th style="text-align: center;">ID</th>
  <th>buyer</th>
  <th>item url</th>
  <th>shop</th>
  </tr>
  </thead>
  <tbody>
  <tr>
  <td style="text-align: center;">01</td>
  <td>Tom</td>
  <td>https://safariland.shopdomain.com/fghj/shoes</td>
  <td>safariland</td>
  </tr>
  <tr>
  <td style="text-align: center;">02</td>
  <td>Sam</td>
  <td>https://beastofshoes.shopdomain.com/ukgl/offers/1424</td>
  <td>beastofshoes</td>
  </tr>
  </tbody>
  </table>
  </div>
  <p>The raw CSV looks as following:</p>
  <pre><code>ID,buyer,item url
  01,Tom,https://safariland.shopdomain.com/fghj/shoes
  02,Sam,https://beastofshoes.shopdomain.com/ukgl/offers/1424
  </code></pre>
  <p>At my search Info is not being as every question out there is looking for a formula where they need to sum, average or something.</p>
  <p>Already could manage to add a new column but my needs are to cut the text between the before column, not related to sum or average or maths.</p>
  <p>Would like a bit of light on how to achieve this if someone can help.</p>
  <p>EDIT: Tested the Python Solution and it worked like a charm, thanks!</p>