asked on

Powerhell adjust text file to read postcode and generate time

Olemo created the underneath powershell script but i want to adjust it that its checking the postcode in the text file and that it will make 2 directories
First directory are all the postcodes 1011 en 1012
2nd directory are the rest of the postcode's
Attached the text file

Thanks Danny
----
$FileIn = 'C:\Temp\EE\test.txt'
if (!(Test-Path $FileIn))
{
Write-Error "ERROR: Input file `"$FileIn`" does not exist."
return
}

$path = split-path -parent $FileIn
$header = Get-Content $FileIn | ? { $_ } | select -First 2
Get-Content $FileIn | ? { $_ } | Select -Skip 2 |
% {
$line = $_ -replace "0:00:00", " "
$FileOut= $path + '\' + $line.SubString(20,50).Trim() + '.txt'
if (!(Test-Path $FileOut)) { $line = @($header, $line) }
$line | Out-File -Append $FileOut
}
https://www.experts-exchange.com/questions/28649471/Why-is-this-script-not-running-from-powershell.html?anchorAnswerId=40705140#a40705140
test.txt

Mark Bullock

Something like this should do it. You didn't have 1011 or 1012 in your input data though, so you'll only see files in the Second directory.

$FileIn = 'C:\Temp\EE\test.txt'
 if (!(Test-Path $FileIn))
 {
   Write-Error "ERROR: Input file `"$FileIn`" does not exist."
   return
 }

 $path = split-path -parent $FileIn 
 $header = Get-Content $FileIn | ? { $_ } | select -First 2
 Get-Content $FileIn | ? { $_ } | Select -Skip 2 | 
   % {
     $line   = $_ -replace "0:00:00", "       " 
	 $postcode = $line.Substring(72,5)
	 If (($postcode -eq "1011") -or ($postcode -eq "1012")) {
	    $directory = "First"
	 }
	 Else
	 {
		$directory = "Second"
	 }
     $FileOut= $path + '\' + $directory + '\' + $line.SubString(20,50).Trim() + '.txt'
     if (!(Test-Path $FileOut)) { $line = @($header, $line) }
     $line | Out-File -Append $FileOut
   }

Open in new window

Danny Kon

ASKER

Mark,

That's sloppy work sorry for that, i will test what you make and i put the correct test file.

Thanks for helping

Danny
test.txt

Mark Bullock

You data is hard to parse because it looks like it's fixed position, but some characters, like accented e take two bytes.

Try this.

$FileIn = 'C:\Temp\EE\test.txt'
 if (!(Test-Path $FileIn))
 {
   Write-Error "ERROR: Input file `"$FileIn`" does not exist."
   return
 }

 $path = split-path -parent $FileIn 
 $header = Get-Content $FileIn | ? { $_ } | select -First 2
 Get-Content $FileIn | ? { $_ } | Select -Skip 2 | 
   % {
     $line   = $_ -replace "0:00:00", "       " 
	 $indexPostcode = 84
	 if ($line.Substring($indexPostcode,1) -eq ' ') {
		$indexPostcode++
	 }
	 $postcode = $line.Substring($indexPostcode,4)
	 If (($postcode -eq "1011") -or ($postcode -eq "1012")) {
	    $directory = "First"
	 }
	 Else
	 {
		$directory = "Second"
	 }
     $FileOut= $path + '\' + $directory + '\' + $line.SubString(20,50).Trim() + '.txt'
     if (!(Test-Path $FileOut)) { $line = @($header, $line) }
     $line | Out-File -Append $FileOut
   }

Open in new window

Danny Kon

ASKER

Mark,

The output goes direct to the second directory and nothing is going to the first its also hard for me to see where it goes wrong because i don't see what is happening (is it possible in powerhell to see what its doing (like remove the @echo off in a dosscript?)) i dont get any errors.

Thanks for your help

Danny

ASKER CERTIFIED SOLUTION

Mark Bullock

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Danny Kon

ASKER

Mark Bullock

Yes, that's correct. Remove Write-Host and you will not see any messages on the console.