How to Use While loop in Powershell?

Question

I'm using the variable $listing as the file name as given below.

Get-Content BHS_output.txt | Select-String -pattern $listing| sort | Foreach-Object {$_ -replace "$listing", ""} > $listing

Where $listing is the variable from the first row of the file on first iteration. On the second iteration

$listing = Get-Content .\file.txt | select-object -First 1 .

$listing must have BHS_E_CNBY20150622035126.CSV .. Not BHS_E_BHSA20150622035126.CSV .

File name : TestFile1_sorted.txt

BHS_E_BHAA20150622035126.CSV
BHS_E_BHSA20150622035126.CSV
BHS_E_CNBY20150622035126.CSV
BHS_E_PACS20150622035126.CSV

possible duplicate of Remove Top Line of Text File with Powershell — Matt
– Matt, Commented Jun 30, 2015 at 12:18
In case it is related can you show us what you mean by I need to use the output file inside the while loop statement for more than 5 times — Matt
– Matt, Commented Jun 30, 2015 at 13:10
I was using the variable $listing as the file name as below. Get-Content BHS_output.txt | Select-String -pattern $listing| sort | Foreach-Object {$_ -replace "$listing", ""} > $listing Where $listing is the variable from the first row of the file on first iteration. On the second iteration $listing = Get-Content .\file.txt | select-object -First 1 . $listing must have BHS_E_CNBY20150622035126.CSV .. Not BHS_E_BHSA20150622035126.CSV. — John Christopher
– John Christopher, Commented Jun 30, 2015 at 15:21
So i need to delete the first row from the file TestFile1_sorted.txt to proceed furthur.. I'm woking as a Sybase developer and this was my first project. Thanks in Advance Matt. — John Christopher
– John Christopher, Commented Jun 30, 2015 at 15:26
Can you edit your question with that information. Your question possible different then your title suggests. — Matt
– Matt, Commented Jun 30, 2015 at 15:36

Matt · Accepted Answer · 2015-06-30 12:14:59Z

1

The error you would be getting would be about saving to the same file you are reading from which is the product of the pipeline you created. Each line is processed one at a time so the second line is being written to file while the files is still open to keep reading.

(Get-Content $path) | Select-Object -Skip 1 | Set-Content $path

Putting the (Get-Content $path) in brackets will process the entire file into memory. Beware if the file is large. Then the rest of your code will work as normally.

answered Jun 30, 2015 at 12:14

Matt

47k9 gold badges90 silver badges125 bronze badges

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

2 Comments

John Christopher Over a year ago

If both the path of Get-content and Set-content is same, Will it work? For me its throwing error as Unable to Open the document.

Matt Over a year ago

@JohnChristopher Yes this exact code will work assuming that the file is not already open and that you have the right permissions in the first place.

Community · Accepted Answer · 2017-05-23 12:14:04Z

0

have you tried just "select" instead of "select-object"

Get-Content TestFile1_sorted.txt | Select -Skip 1

Someone answered a question about this before: Remove Top Line of Text File with Powershell

get-content $file |
    select -Skip 1 |
    set-content "$file-temp"
move "$file-temp" $file -Force

edited May 23, 2017 at 12:14

CommunityBot

11 silver badge

answered Jun 30, 2015 at 12:14

Jon Allen

3351 silver badge9 bronze badges

1 Comment

Matt Over a year ago

Select is the same as Select-Object one is an alias of the other.

Avshalom · Accepted Answer · 2015-06-30 12:34:15Z

0

you can do this:

$a = Get-Content C:\temp.txt
$a[1..-1] | Out-File c:\newfile.txt

if you want to overwrite the file replace the destination

what it does it creates new array and select it from the 2nd to the end

edited Jun 30, 2015 at 12:34

answered Jun 30, 2015 at 12:16

Avshalom

8,9471 gold badge29 silver badges50 bronze badges

1 Comment

John Christopher Over a year ago

I want to use it inside the while loop Statement.So there should not be destination Folder in it.

Collectives™ on Stack Overflow

How to Use While loop in Powershell?

3 Answers 3

2 Comments

1 Comment

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

2 Comments

1 Comment

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related