Bdtjtk

Im working on a Powershell script that can put lines from a text file into a list box, but only lines that start with a date ../../....
The add list box part is working. But id like to delete older lines from the text file first.
I tried this but it not correct. Can anyone help me code this correctly.

I will rephrase the question to hopefully make it clearer.

The text file look like this:

text.txt

//Regular Roster | Only update if making a permanent change.

!The order for the entry must be: Day time,number,name,email(optional)

!With a comma ‘,’ separating the values.



Monday 9AM-2PM,0400499449,BILL

Monday 2PM-6PM,074477464,Terry

Monday 6PM-9PM,040484747,Leanne



Tuesday 9AM-2PM,07123456,BILL

Tuesday 2PM-6PM,054647383,Barbara

Tuesday 6PM-9PM,03937464,Mandy



//Changes to Regular Roster. This section will override the above.

!The date order of the entries below is not important but each line must follow this pattern:

!date(Dayxx/Monthxx/Yearxxxx),time(9AM,2PM or 6PM),number,name,email(optional)

!Date slash must be forward facing '/'.

!The only times that can be entered are 9AM,2PM or 6PM.

!With a comma ‘,’ separating the values.



01/01/2019,6AM,0400012345,Kurt,kurt@outlook.com

02/01/2019,6AM,0412345676,Bill,bill@outlook.com

03/01/2019,6AM,0400012345,Sam,Sam@outlook.com

04/01/2019,6AM,0412345676,Barry,barry@outlook.com

05/01/2019,6AM,0400012345,Kurt,kurt@outlook.com

If I try this code in Powershell assuming the current date is 04/01/2019 (4th January 2019) it works fine

$CurrentDate = "04/01/2019"

$Text = "05/01/2019,6AM,0400012345,Kurt,kurt@outlook.com"

$Text | ForEach-Object {

    $Roster1Date,$Roster2Time,$Roster3Number,$Roster4Name,$Roster5Email = $_.split(",")

    $Newdate = "$Roster1Date"

    $CurrentDate = [datetime]::ParseExact("$CurrentDate", 'dd/MM/yyyy', $null)

    $Newdate = [datetime]::ParseExact("$Newdate", 'dd/MM/yyyy', $null)

    if ($Newdate -ge $CurrentDate) {

     write-output "NewDate is bigger than or equal to"

    }

    else {

      write-output "CurrentDate is bigger"

    }

};

When I try to build a Listbox with this line it works fine

#Add Listbox

$ShiftsListBox = New-Object System.Windows.Forms.ListBox

$ShiftsListBox.Location = New-Object System.Drawing.Size(400,40)

$ShiftsListBox.Size = New-Object System.Drawing.Size(360,20)

$ShiftsListBox.Height = 160

Get-Content $RosterPath | select-string -Pattern '../../...' | ForEach-Object {[void] $ShiftsListBox.Items.Add($_)};

$FormCreateNewShift.Controls.Add($ShiftsListBox)

When I tried to combine the two it just comes up blank

#Add Listbox

$TextFile = text.txt

$ShiftsListBox = New-Object System.Windows.Forms.ListBox

$ShiftsListBox.Location = New-Object System.Drawing.Size(400,40)

$ShiftsListBox.Size = New-Object System.Drawing.Size(360,20)

$ShiftsListBox.Height = 160

Get-Content $TextFile | select-string -Pattern '../../...' | ForEach-Object {

    $Roster1Date,$Roster2Time,$Roster3Number,$Roster4Name,$Roster5Email = $_.split(",")

    $Newdate = "$Roster1Date"

    $CurrentDate = [datetime]::ParseExact("$CurrentDate", 'dd/MM/yyyy', $null)

    $Newdate = [datetime]::ParseExact("$Newdate", 'dd/MM/yyyy', $null)

    if ($Newdate -ge $CurrentDate) {

     [void] $ShiftsListBox.Items.Add($_)

    }

    else {

    }

};

$FormCreateNewShift.Controls.Add($ShiftsListBox)

The idea is that if the date is greater than or equal to the current date display the line in the list box, else don't. But then I will try to delete the line by adding in a replace line.

#Add Listbox

$TextFile = text.txt

$ShiftsListBox = New-Object System.Windows.Forms.ListBox

$ShiftsListBox.Location = New-Object System.Drawing.Size(400,40)

$ShiftsListBox.Size = New-Object System.Drawing.Size(360,20)

$ShiftsListBox.Height = 160

Get-Content $TextFile | select-string -Pattern '../../...' | ForEach-Object {

    $Roster1Date,$Roster2Time,$Roster3Number,$Roster4Name,$Roster5Email = $_.split(",")

    $Newdate = "$Roster1Date"

    $CurrentDate = [datetime]::ParseExact("$CurrentDate", 'dd/MM/yyyy', $null)

    $Newdate = [datetime]::ParseExact("$Newdate", 'dd/MM/yyyy', $null)

    if ($Newdate -ge $CurrentDate) {

     [void] $ShiftsListBox.Items.Add($_)

    }

    else {

          ((Get-Content -path $TextFile) -replace $_,"") | Set-Content -Path $TextFile;

    }

};

$FormCreateNewShift.Controls.Add($ShiftsListBox)

Based on new sample file, this script distinguishes

• between lines with a leading date
  
  
  
  
  • a date from today or later(keep)
  
  
  • a date before today (skip)
  
  
  
  


• other lines (keep)

## Q:Test201911SO_53992011.ps1

$Rosterpath = ".rosterpath"



$CurrentDate = (Get-Date).Date  # to have a datetime starting today at 00:00:00



$RegEx = [RegEx]"^(?<day>d{2})/(?<mon>d{2})/(?<year>d{4})"



$UpdatedContent = Get-Content $RosterPath | ForEach-Object {

    If ($_ -match $RegEx){

        If((Get-Date -Year $Matches.year -Month $Matches.mon -Day $Matches.day) -ge $CurrentDate){

            # yes keep this line

            $_

        } else { 

            #drop this line

        }

    } else {

        # line without a date, keep

        $_

    }

}



$UpdatedContent | Set-Content $RosterPath