How to read a string from text file using powershell

Question

I want to read a specific string from a text file and output the string into another text file.

My text file (Sample.txt) looks like below:

@{AssemblyName=Microsoft.Office.Excel, Version=1.0.0.0, Culture=neutral,     PublicKeyToken=1y08bdf1111e0105c; Path=C:\Tes\app1\cc\application; ProjectPath=C:\test\application\Application.vbproj; Name=Microsoft.Office.Excel}

@{AssemblyName=System; Path=C:\Tes\app2\ser\application; ProjectPath=C:\test\application2\Application.vbproj; Name=System}

I do not want to include anything except the assemblyname.. i.e, the script should not consider version, culture etc.

The text file has lot of such assembly information. I would like to read only the AssemblyName and write that to another text file in powersehll. For Ex: The output.txt should contain only Microsoft.Office.Excel.

Also, I want to exclude few assembly names that start with a specific string like for eg: System. How can I do that?

I tried below, but it's not writing anything to the output.txt.

$workdir = "C:\Test"
$Txt = "$workdir\Sample.txt"

Function GetAsmName($rTxt)
{

Get-Content $Txt

$regex = '@{AssemblyName="(\w*?)"[,|;]'
$matches = (select-string  -Path $Txt -Pattern $regex)
$matches | Select -Expandproperty Matches | Select @{n="Name";e={$_.Groups[1].Value}}
Set-Content -path $workdir\Output.txt -value $matches
}

Any help would be greatly appreciated.

Thanks

CB. · Accepted Answer · 2012-11-06 08:13:28Z

2

Try:

$workdir = "C:\Test"
$Txt = "$workdir\Sample.txt"    
Function GetAsmName($rTxt)
{    
$captures = gc $rTxt | 
            select-string -Pattern '(?<=AssemblyName=)([^;|,]*)' -allmatches |
            select -expa matches | select -expa value    
Set-Content -path $workdir\Output.txt -value $captures
}

GetAsmName $Txt

edited Nov 6, 2012 at 8:13

answered Nov 6, 2012 at 8:04

CB.

61.3k9 gold badges171 silver badges165 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

ashish g Over a year ago

Also, How can I exclude assemblies whose name starts with System?

CB. Over a year ago

@ashishg try this pattern '(?<=AssemblyName=)(?!system)([^;|,]+)'

Collectives™ on Stack Overflow

How to read a string from text file using powershell

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related