title: How to parse strings in a table cell generated by format-table in powershell?
body: <p>I used the following comlet to get the data: </p>
  
  <pre><code>import-csv .\ConnectionStrings.txt -Delimiter "`t" -Header Firms, URLs, Config, Type | format-table -Property Firms, URLs -HideTableHeaders -outvariable content
  
  #Not working part
  for($i = 0; $i -lt $content.Count; $i++){
      $url = $content[$i][1]    
      $instance = $url.SubString(0, $url.IndexOf(".") - 1)
  }
  </code></pre>
  
  <p>and below it is the result from import-csv... cmdlet: </p>
  
  <pre><code>value1    url1.test.com
  value2    url2.test.com
  value3    urle3.test.com
  ...
  valuen    urln.test.com
  </code></pre>
  
  <p>I used getType to check $content and it's ArrayList. I thought I could use it as a C# ArrayList because I need to parse the second column to get the url section. 
  But not working. Currently I think I am in a dead end without any idea where I can go...</p>