VBScript for regrouping the content of text files on the basis of first and second column value in another text files

All replies

• 

  

  0

  Sign in to vote

  There is no way to decide what you want. Please tell us what the criteria is for selecting the different outputs?

  How to ask questions in a technical forum

  This Forum is for Scripting Questions Rather than script requests

  ---

  \_(ツ)_/

  Thursday, October 17, 2019 8:24 PM
• 

  

  0

  Sign in to vote

  What does your code look like so far?

  Please read this first:

  This forum is for scripting questions rather than script requests

  ---

  -- Bill Stewart [Bill_Stewart]

  Thursday, October 17, 2019 8:27 PM
• 

  

  0

  Sign in to vote

  In PowerShell, it would look like this:

  Get-Content master.txt | Foreach-Object{
     $parts = $_.split(':')
     $Filename = '{0}_{1}.txt' -f $parts[0..1]
     $_ | Add-Content $Filename 
  }

  
  

  or (just for grins):

  gc master.txt | %{$_ | ac ('{0}_{1}.txt' -f $_.split(':')[0..1])}

  
  

  If you trruly need VBScript, you're on your own.

  ---

  Keith

  Friday, October 18, 2019 4:31 AM