How to parse a File in power shell with conditional and garbage

Question

I need to get part of this file for example, I need extract the following

Main, Branches\Branch1

in one variable also the I cannot have duplicate values

It is possible with powershell?

This is the file:

This is a garbage line
This is another garbage line
c:\Folder\Main\Folder\..\Folder
c:\Folder\Main\Folder\..\Folder
c:\Folder\Branches\Branch1\Folder\..\Folder
c:\Folder\Branches\Branch1\Folder\..\Folder
c:\Folder\Branches\Branch1\Folder\..\Folder
c:\Folder\Main\Folder\..\Folder
c:\Folder\Main\Folder\..\Folder
this is the final line..

JPBlanc · Accepted Answer · 2015-02-11 04:15:52Z

2

But of course ...

According to the fact $files contain your lines

$files = Get-content "your file"

You can use the following to be sure that there is no duplicate :

$files | Sort-Object -Unique

Then you can use Test-path to be sure that path exists

$files | Sort-Object -Unique | where {Test-Path $_ -ErrorAction SilentlyContinue}

answered Feb 11, 2015 at 4:15

JPBlanc

73.1k17 gold badges137 silver badges180 bronze badges

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

4 Comments

davdomin Over a year ago

Thanks man, when I put $files | Sort-Object -Unique delete all the util information and just show this:This is a garbage line This is another garbage line this is the final line..

JPBlanc Over a year ago

Sorry, I don't understand. Does it answer your question ?

davdomin Over a year ago

No, I have probhlem with the first line

JPBlanc Over a year ago

What is the problem with the garbage line ?

mjolinor · Accepted Answer · 2015-02-11 10:35:33Z

-1

This will extract those values from the sample data using a -like filter to take out the garbage and a -replace to do the extract. The sort -unique will remove the duplicates, but it won't keep the extracted values in the same order they were in the file.

(get-content testfile.txt) -like 'c:\Folder*' -replace 'c:\\Folder\\(.+?)\\Folder.+','$1' |
 sort -unique

answered Feb 11, 2015 at 10:35

mjolinor

68.7k7 gold badges118 silver badges141 bronze badges

Collectives™ on Stack Overflow

How to parse a File in power shell with conditional and garbage

2 Answers 2

4 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

4 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related