Script to convert .log files to JSON

Hi Porter76,

you can automate the process of converting .log files to JSON using PowerShell.

The following PowerShell script example can be used and then integrated into your Lambda function to automate this conversion:

# Define the path to your input .log file
$sourceLogFile = "C:\Path\To\Your\LogFile.log"

# Define the path to the output JSON file
$outputJsonFile = "C:\Path\To\Your\OutputFile.json"

# Initialize an array to store JSON objects
$jsonArray = @()

# Read the .log file line by line
Get-Content -Path $sourceLogFile | ForEach-Object {
# Split the log line based on your log format (assuming space-separated fields)
$logFields = $_.Split(" ")

# Create a custom PowerShell object with the desired JSON structure
$logObject = [PSCustomObject]@{
"Field1" = $logFields[0]
"Field2" = $logFields[1]
# Add more fields as needed
}

# Add the log object to the JSON array
$jsonArray += $logObject
}

# Convert the JSON array to a JSON string
$jsonString = $jsonArray | ConvertTo-Json

# Write the JSON string to the output JSON file
$jsonString | Set-Content -Path $outputJsonFile

# Display a success message
Write-Host "Conversion completed. JSON file saved to $outputJsonFile."