Data missing

Question

$t = "Server - shutdown in 2014, 2018 "Systems" database The server is expected to be kept until July 30th, 2023, and"
$i=0
if($t -Match ','){
            $Annotations = $t.replace('"',' ').Split(',')
            for($i; $i -le $Annotations.Count;$i++){
                $Annotation+= $Annotations[$i]                
            }
            Write-Output $Annotation
            Write-Output "clear"
        }
For the above sentence I am not getting the full string. I am getting the value upto July 30th, rest is missing. I tried using comma separation and everything but no solution.

Answer 1

First, the quoting in the string is incorrect. Replace the 1st and last double-quote with a single-quote.

Can you explain (or show) what you expect to see as a result of running that code?

You can do without the need for an intermediate array:

$t = 'Server - shutdown in 2014, 2018 "Systems" database The server is expected to be kept until July 30th, 2023, and'
if ($t -Match ','){
       $annotation = $t.replace('"',' ').Replace(',','')
       Write-Output $Annotation
       Write-Output "clear"
}

The result of running your code (or the code above) is:

Server - shutdown in 2014 2018  Systems  database The server is expected to be kept until July 30th 2023 and
clear

Answer 2

You are splitting the string $t on commas, which means that it will break at every comma in the text. The text itself has several commas within it that are not meant to be used as delimiters, which is why you're not getting the expected result.

If you want to replace double quotes with spaces and print the resulting string, you don't need to split the string at all. You can just do:

$t = "Barbados Sun Systems Financial Server - shutdown in 2014 Delete after December 1, 2018 ENV: Retired but keep POC: Stephen Galbraith SQL 2000 installed with \"Sun Systems\" database The server is expected to be kept until July 30th, 2023, and we will again follow up with the technical owners to get confirmation to proceed with decommissioning."

$Annotation = $t.Replace('"', ' ')

Write-Output $Annotation

Write-Output "clear"

If you were trying to split the string into parts for some other purpose, you'll need to choose a different delimiter or use a more complex method to parse the string, such as a regular expression that takes into account the structure of the data you're working with.