title: Copy variable within a column to a new cell
body: <p>I've exported my Java processes to include the 'Command Line' column. The file is in a .cvs file using the following powershell script:</p>
  
  <pre><code>Get-WmiObject win32_process -Filter "name like '%java.exe'"|select ProcessName,@{Name='WorkingSet (KB)';Expression={($_.WS/1KB)}},ProcessId,CommandLine|ft -AutoSize
  </code></pre>
  
  <p>Each java.exe is unique (obviously) and the only way I've found to identify where it points is by looking in the Command Line argument for the Appserver directory. </p>
  
  <pre><code>(Install_Directory)\AppServer\Profiles\AppSrv01\*\Configuration. 
  </code></pre>
  
  <p>The '*' variable is the key, and the information within the command line has this same information in the argument. I need to copy the variable to a new cell</p>
  
  <p>In the end i'll delete the Command Line column so I just see ProcessName, WorkSet, ProcessID, and Domain. Domain is the last piece that I need. </p>
  
  <p>Whether this is an extension of my existing powershell or if there is a something I can put into excel to copy everything that is between the 'AppSrv01' and 'Configuration' to a new cell.</p>