Remove specific table column properties from Markdown documentation using PowerShell

Add-Type -AssemblyName System.Windows.Forms

# Define the form
$form = New-Object System.Windows.Forms.Form
$form.Text = 'Markdown File Modifier for Oracle'
$form.Size = New-Object System.Drawing.Size(960, 600)
$form.StartPosition = 'CenterScreen'

# Define the ListView
$filesListView = New-Object System.Windows.Forms.ListView
$filesListView.View = [System.Windows.Forms.View]::Details
$filesListView.FullRowSelect = $true
$filesListView.MultiSelect = $false
$filesListView.Dock = [System.Windows.Forms.DockStyle]::Fill
$filesListView.Columns.Add('File Name', -2, [System.Windows.Forms.HorizontalAlignment]::Left)
$form.Controls.Add($filesListView)

# Populate the ListView with Markdown files
$folderPath = 'path_to_the_markdown_files_with_database_objects' # Set your folder path
$files = Get-ChildItem -Path $folderPath -Filter '*.md'
foreach ($file in $files) {
    $item = New-Object System.Windows.Forms.ListViewItem($file.Name)
    $filesListView.Items.Add($item)
}

# Define the options
$options = @('Key', 'Name', 'Data Type', 'Data Type Owner', 'Length', 'Precision', 'Scale', 'Char Used', 'Not Null', 'Default', 'Default On Nulls', 'Nested Table', 'Reference', 'Virtual', 'Description|')
# Create a checkboxes panel
$checkboxPanel = New-Object System.Windows.Forms.FlowLayoutPanel
$checkboxPanel.Dock = [System.Windows.Forms.DockStyle]::Top
$checkboxPanel.AutoSize = $true
$form.Controls.Add($checkboxPanel)

# Create checkboxes for each option
foreach ($option in $options) {
    $checkbox = New-Object System.Windows.Forms.CheckBox
    $checkbox.Text = $option
    $checkbox.Checked = $true
    $checkboxPanel.Controls.Add($checkbox)
}

# Add Save button to the form
$saveButton = New-Object System.Windows.Forms.Button
$saveButton.Text = 'Save'
$saveButton.Dock = [System.Windows.Forms.DockStyle]::Bottom
$form.Controls.Add($saveButton)

# Add Apply to All button to the form
$applyAllButton = New-Object System.Windows.Forms.Button
$applyAllButton.Text = 'Apply to All'
$applyAllButton.Dock = [System.Windows.Forms.DockStyle]::Bottom
$form.Controls.Add($applyAllButton)

# Save button click event
$saveButton.Add_Click({
    ProcessFiles -SelectedFile $filesListView.SelectedItems[0].Text
})

# Apply to All button click event
$applyAllButton.Add_Click({
    ProcessFiles -All $true
})

# Function to process files
function ProcessFiles {
    param (
        [string]$SelectedFile,
        [switch]$All
    )

    $filesToProcess = if ($All) { $filesListView.Items } else { $filesListView.Items | Where-Object { $_.Text -eq $SelectedFile } }
    
    foreach ($item in $filesToProcess) {
        $selectedFilePath = Join-Path -Path $folderPath -ChildPath $item.Text
        $content = Get-Content -Path $selectedFilePath -Raw

        # Define the block start and end markers
        $blockStart = '## <a name="#Columns"></a>Columns'
        $blockEnd = '##'

        # Extract content within the block
        $blockContent = $content -replace "(?ms)(.*${blockStart}\s*`n)(.*?)(\s*${blockEnd}.*)", '$2'

        # Remove any existing headers and separators from the block content
        $blockContent = $blockContent -replace '^\|\s*Key.*\n\|\:---.*\n', ''

        # Recreate the header based on checked options
        $header = '|'
        $dashLine = '|'
        foreach ($option in $options) {
            $checkbox = $checkboxPanel.Controls | Where-Object { $_.Text -eq $option }
            if ($checkbox.Checked) {
                $header += "$option|"
                $dashLine += "---|"
            }
        }

        # Prepend the header and separator to the block content
        $newBlockContent = $header + "`n" + $dashLine + "`n" + $blockContent

        # Replace the modified block content in the original content
        $content = $content -replace "(?ms)(.*${blockStart}\s*`n)(.*?)(\s*${blockEnd}.*)", "`$1$newBlockContent`$3"

        # Define the modified file path
        $modifiedFilePath = $selectedFilePath -replace '\.md$', '_modified.md'
        
        # Save the modified content to a new file
        $content | Set-Content -Path $modifiedFilePath

        [System.Windows.Forms.MessageBox]::Show("File '$($item.Text)' modified and saved as '$($modifiedFilePath | Split-Path -Leaf)'.")
    }
}



# Show the form
$form.ShowDialog() | Out-Null