Data Processing

Remove BOM (Byte Order Mark) characters from text and file content. Perfect for cleaning up text files that have encoding issues, fixing CSV imports, and preparing data for processing. Features: - Detect and remove UTF-8 BOM (EF BB BF) - Detect and remove UTF-16 BOM (FE FF or FF FE) - Detect and remove UTF-32 BOM (00 00 FE FF or FF FE 00 00) - Support multiple input formats - Visual BOM character display - Detailed detection report - Support for batch text processing Common Use Cases: - Fix CSV file import errors - Clean up text file encoding issues - Prepare data for JSON parsing - Fix XML parsing problems - Resolve API data encoding conflicts - Standardize text data format

Data Processing

Validate foreign key relationships between multiple datasets. Perfect for checking data integrity, finding orphaned records, and ensuring referential consistency across related tables. Features: - Validate foreign key relationships - Find orphaned records - Check referential integrity - Support multiple key formats - Cross-table validation - Missing key detection - Duplicate key analysis - Relationship mapping Common Use Cases: - Database integrity checks - Data migration validation - ETL process verification - Referential consistency checks - Data quality assurance - Relationship analysis

Data Processing

Inject various types of noise into text data for testing purposes. Perfect for stress testing data processing systems, testing data quality algorithms, and creating realistic test datasets. Features: - Character-level noise injection - Word-level noise injection - Numeric data noise - Formatting noise - Whitespace noise - Special character noise - Configurable intensity levels - Realistic noise patterns Common Use Cases: - Test data validation systems - Stress test parsing algorithms - Evaluate error handling - Test data cleaning algorithms - Create realistic messy data - Benchmark data processing performance

Data Processing

Build Excel formulas with common functions and operators

Data Processing

Generate simple VBA macros for Excel automation

Data Processing

Validate CSV structure, detect malformed rows, unbalanced quotes and column mismatches

Data Processing

Upload a CSV file or paste CSV text, remove duplicate rows using exact or fuzzy matching, and download a cleaned CSV.

Data Processing

Infer a relational schema from CSV data and generate create-table plus ALTER migration plans for PostgreSQL, MySQL, SQLite, or SQL Server

Data Processing

Compare two CSV or XLSX datasets and export a PDF report with row, column, and cell-level differences

Data Processing

Assign own and inherited properties using lodash _.assignIn

Data Processing

Assign source properties to a target object using lodash _.assign

Data Processing

Count items by a derived key using lodash _.countBy