Hi,
I'm currently working on a script to export the content of a .txt file to Csv format but the issue I am having is that, the empty field in the txt file is being ignored in Csv file. Hence, the data is sort of a mess. I would
like to retain the blank cell in my output csv file. Is there a way I could twerk my code to do that? Below is how the content of the csv looks like.
Input in text file($path_out):
Number Debit Amount Number Credit Amount
Amount 1,816,208.71 1,816,208.71
Accum 874 1,816,208.71 23 1,816,208.71
Difference .00
.00
Output in CSV file:
Number Debit Amount Number Credit Amount
Amount 1,816,208.71 1,816,208.71
Accum 874 1,816,208.71 23 1,816,208.71
Difference .00 .00
My powershell code structure:
$input = Get-Content $path_out
$data = $input[1..($input.Length - 1)]
$maxLength = 0
$objects = ForEach($record in $data) {
$split = $record -split "\s{2,}|\t+"
If($split.Length -gt $maxLength){
$maxLength = $split.Length
}
$props = @{}
For($i=0; $i -lt $split.Length; $i++) {
$props.Add([String]($i+1),$split[$i])
}
New-Object -TypeName PSObject -Property $props
}
$headers = [String[]](1..$maxLength)
$objects |
Select-Object $headers |
Export-Csv -NoTypeInformation -Path "X:\project\Monarch\out.csv"
