79464494

Date: 2025-02-24 18:25:00
Score: 2
Natty:
Report link

In the end I generated the csv file by piping the invoke-sqlcmd results that are in a variable using export-csv then i used the below two lines just after the exporting.

(Get-Content -path %pathtoCsv%) -replace 'False', '0' | set-content "%pathtocsv%"

(Get-Content -path %pathtoCsv%) -replace 'True', '1' | set-content "%pathtocsv%"

Reasons:
  • No code block (0.5):
  • Self-answer (0.5):
  • Low reputation (1):
Posted by: Rami Aboulissane