TSV Tweaker

A powerful Visual Studio Code extension for editing and validating Tab-Separated Values (TSV) files with an intuitive tabular user interface.

Installation

1. Install the extension from the Visual Studio Code Marketplace or use the VSIX package:

   code --install-extension tsv-tweaker.vsix
   

2. Restart Visual Studio Code to activate the extension

Usage

Opening Files

1. Right-click on any TSV file in the VS Code Explorer
2. Select "Open With" > "TSV Editor"

Features

Comprehensive TSV Editing

• Interactive table-based editor with cell-by-cell editing
• Double-click cells to open a larger editing modal for better visibility
• Integrated column and row management through convenient dropdown menus
• Real-time validation of cell contents based on custom rules

Column Management

• Add columns before or after any existing column
• Delete columns with a single click
• Rename column headers directly in the interface
• Search and filter columns using the built-in search bar

Row Operations

• Add new rows above or below any existing row
• Delete rows with proper validation
• Automatic cell padding to maintain consistent column counts

Data Validation

• Load custom validation rules through JSON configuration
• Real-time validation feedback for cell contents
• Support for regex-based validation patterns
• Visual indicators for invalid data entries
• Type-specific validation with helpful error messages

User Interface

• Clean, modern interface that integrates seamlessly with VS Code
• Responsive design with proper handling of large datasets
• Column search functionality for quick navigation
• Context menus for quick access to common operations

Basic Operations

• Click any cell to edit its contents directly
• Double-click a cell to open the enhanced editing modal
• Use the column dropdown (⋮) to manage columns
• Use the row dropdown (⋮) to manage rows
• Type in the search bar to filter columns by header name

Validation Rules

Create a JSON file with your validation rules using the following format:

[
  {
    "column": "ColumnName",
    "validation": "regex-pattern",
    "type": "data-type"
  }
]

To apply validation rules:

1. Click "Load Validation Rules"
2. Select your JSON configuration file
3. Invalid cells will be highlighted automatically

License

This project is licensed under the MIT License - see the LICENSE file for details.

Acknowledgments

Built with React and TypeScript, leveraging VS Code's extension API for seamless integration.

Support

Not available yet.