CMD Prompt / PS / Batch - Find Unique Values in a .TXT File

Hello @ricardobohner,

Thank you, but unfortunately, it only produced the following . . .

Code:

Normal           : %Title% %Author% Sets the default console foreground and background colors.

COLOR [attr]

  attr        Specifies color attribute of console output

Color attributes are specified by TWO hex digits -- the first
corresponds to the background; the second the foreground.  Each digit
can be any of the following values:

    0 = Black       8 = Gray
    1 = Blue        9 = Light Blue
    2 = Green       A = Light Green
    3 = Aqua        B = Light Aqua
    4 = Red         C = Light Red
    5 = Purple      D = Light Purple
    6 = Yellow      E = Light Yellow
    7 = White       F = Bright White

If no argument is given, this command restores the color to what it was
when CMD.EXE started.  This value either comes from the current console
window, the /T command line switch or from the DefaultColor registry
value.

The COLOR command sets ERRORLEVEL to 1 if an attempt is made to execute
the COLOR command with a foreground and background color that are the
same.

Example: "COLOR fc" produces light red on bright white

. . . which is the first TWO variable on the first line that had Variables.

Hello @ricardobohner,

I have been trying to achieve this using PowerShell [ I have spent hours on it ] as you are having a go using Batch. I do NOT know PowerShell, but I thought I would have a go along with my friend Google. Unfortunately, I am NOT having much success [ had some though ] with it, YET.

UPDATE:

I have cracked it using PowerShell, although a brute force approach . . .

Code:

$Source_File = Get-Content 'C:\Users\System-Admin\Desktop\System_Reports.bat'
$Destination_File = 'C:\Users\System-Admin\Desktop\AAA.txt'

if (Test-Path $Destination_File) 
{
  Remove-Item $Destination_File
}

ForEach ($Line In $Source_File) { 
  If ($Line -Like "%??%") {
    $Line | Out-File -FilePath $Destination_File -Append
  }
}

ForEach ($Line In $Source_File) { 
  If ($Line -Like "%???%") {
    $Line | Out-File -FilePath $Destination_File -Append
  }
}

ForEach ($Line In $Source_File) { 
  If ($Line -Like "%????%") {
    $Line | Out-File -FilePath $Destination_File -Append
  }
}

ForEach ($Line In $Source_File) { 
  If ($Line -Like "%????%") {
    $Line | Out-File -FilePath $Destination_File -Append
  }
}

ForEach ($Line In $Source_File) { 
  If ($Line -Like "%?????%") {
    $Line | Out-File -FilePath $Destination_File -Append
  }
}

ForEach ($Line In $Source_File) { 
  If ($Line -Like "%??????%") {
    $Line | Out-File -FilePath $Destination_File -Append
  }
}

ForEach ($Line In $Source_File) { 
  If ($Line -Like "%???????%") {
    $Line | Out-File -FilePath $Destination_File -Append
  }
}

ForEach ($Line In $Source_File) { 
  If ($Line -Like "%????????%") {
    $Line | Out-File -FilePath $Destination_File -Append
  }
}

ForEach ($Line In $Source_File) { 
  If ($Line -Like "%?????????%") {
    $Line | Out-File -FilePath $Destination_File -Append
  }
}

ForEach ($Line In $Source_File) { 
  If ($Line -Like "%??????????%") {
    $Line | Out-File -FilePath $Destination_File -Append
  }
}

ForEach ($Line In $Source_File) { 
  If ($Line -Like "%???????????%") {
    $Line | Out-File -FilePath $Destination_File -Append
  }
}

ForEach ($Line In $Source_File) { 
  If ($Line -Like "%????????????%") {
    $Line | Out-File -FilePath $Destination_File -Append
  }
}

ForEach ($Line In $Source_File) { 
  If ($Line -Like "%?????????????%") {
    $Line | Out-File -FilePath $Destination_File -Append
  }
}

ForEach ($Line In $Source_File) { 
  If ($Line -Like "%??????????????%") {
    $Line | Out-File -FilePath $Destination_File -Append
  }
}

ForEach ($Line In $Source_File) { 
  If ($Line -Like "%???????????????%") {
    $Line | Out-File -FilePath $Destination_File -Append
  }
}

ForEach ($Line In $Source_File) { 
  If ($Line -Like "%????????????????%") {
    $Line | Out-File -FilePath $Destination_File -Append
  }
}

ForEach ($Line In $Source_File) { 
  If ($Line -Like "%????????????????%") {
    $Line | Out-File -FilePath $Destination_File -Append
  }
}

ForEach ($Line In $Source_File) { 
  If ($Line -Like "%?????????????????%") {
    $Line | Out-File -FilePath $Destination_File -Append
  }
}

ForEach ($Line In $Source_File) { 
  If ($Line -Like "%??????????????????%") {
    $Line | Out-File -FilePath $Destination_File -Append
  }
}

ForEach ($Line In $Source_File) { 
  If ($Line -Like "%???????????????????%") {
    $Line | Out-File -FilePath $Destination_File -Append
  }
}

$Source_File = "C:\Users\System-Admin\Desktop\AAA.txt"
$Destination_File = 'C:\Users\System-Admin\Desktop\BBB.txt'

if (Test-Path $Destination_File) 
{
  Remove-Item $Destination_File
}

$Unique_Values = $( ForEach ($Line in Get-Content $Source_File) {
  $Line.Split(" ")
}) | Sort-Object | Get-Unique

$Unique_Values | Out-File $Destination_File -Append
$Unique_Values.Count | Out-File $Destination_File -Append

• It EXTRACTS ALL the Variables ONLY into AAA.txt.
• It then SORTS that file ALPHABETICALLY and creates BBB.txt which also includes the Total Unique Variables.

I will spend some time tidying up the code tomorrow if I get time.

Hello @ricardobohner,

ricardobohner said:

Cool, happy you made it. What do you need the variables of the batch file for?

First of all, THANK YOU for your time and effort on trying to resolve this, it is appreciated.

---

It is mainly for restructuring the Variables if needed. I have already written the Script for that and tested it anyway.

Thanks again.

Not sure exactly the format you have - but suggest using regex to get string patterns

https://docs.microsoft.com/en-us/pow...powershell-7.1

Thanks for the reply @Superfly,

Superfly said:

Not sure exactly the format you have - but suggest using regex to get string patterns.

Funny you should say that, because that is what I initially tried using. I am NOT up with PowerShell [ too long in the tooth now ], so I adopted an alternative brute force approach to get the data that I wanted.