User Powershell to clean up categories

[Brodieman]

I am trying to use PowerShell to get a list of categories using qbt category list. However no matter what format I use I am having issues getting PowerShell to get the correct data.

Even if I output as CSV and export that I get one column named "length" and not Name and Save Path columns like I do when I just run the command.

Anyone figure out how to capture the category data so I can go through and delete ones I don't want?

[Brodieman]

Looks like if I export to txt file instead it exports the correct data: qbt category list --format csv | Out-File -FilePath $outputCsvPath -Encoding UTF8 -Force

I should be able to manipulate the data from there

[Brodieman]

This is the basics of what works. Likely going to try and clean it up some but this works (except for the new show Shogun as it has a funny character in it. Might have to play with that some.

# Specify the path for the output CSV file
$outputTxtPath = "C:\Users\USER\Desktop\File.txt"

# Export data to CSV
qbt category list --format csv | Out-File -FilePath $outputTxtPath -Encoding UTF8 -Force

# Import the text file as CSV (assuming the data is comma-separated)
$data = Import-Csv -Path $outputTxtPath

$data | ForEach-Object {
    if ($_.name -notlike "TV" -and $_.name -notlike "Movies"){
        qbt category delete $_.name
    }
}