JA Technology Solutions
Development Tools
Tools for everyday development, debugging, and data wrangling. Convert between formats (JSON, XML, YAML, CSV, fixed-width, delimiters), decode JWTs, test regex, format SQL, generate hashes and UUIDs, build cron expressions, and more.
Check Digit Validator
Validate and calculate check digits for UPC, EAN, credit cards (Luhn), and ABA routing numbers.
Data & FinanceEBCDIC to ASCII Converter
Convert between EBCDIC and ASCII for IBM i, AS400, and mainframe systems. Fixed-length records, line ending options, CP037 reference.
DevelopmentPacked Decimal / COMP-3 Converter
Decode and encode packed decimal (COMP-3), zoned decimal, and trailing overpunch for IBM i and mainframe systems.
DevelopmentDDS Screen Explorer
Paste IBM i DDS display file source and see the screen rendered with authentic 5250 green-screen and modern preview.
DevelopmentDDS to SQL / SQL to DDS Converter
Convert between IBM i DDS physical file definitions and SQL CREATE TABLE statements in both directions.
DevelopmentBMS Screen Explorer
Paste mainframe BMS (CICS/3270) screen definitions and see the screen rendered with green-screen and modern preview.
DevelopmentCOBOL Copybook Explorer
Explore COBOL copybook structures with interactive tree view, field layout, SQL conversion, JSON Schema generation, sample data decoding, and visual hex ruler.
DevelopmentData Diff & Compare
Compare two datasets with key-field joining. Supports CSV, TSV, JSON, XML, YAML, and Excel with automatic dot-notation flattening for nested structures.
DevelopmentData Profiler
Profile CSV data with column-level statistics, value distribution charts, quality matrix, and drill-down column detail.
DevelopmentParquet File Explorer
View and explore Apache Parquet files entirely in your browser. See schema and metadata, browse data with filtering, export to CSV/JSON/Excel, or convert files to Parquet.
Data & FinanceJSON ↔ CSV
Convert between JSON and CSV formats. Paste, upload, or load sample data. Download or copy the result.
DevelopmentXML ↔ JSON Converter
Convert between XML and JSON formats. Handles attributes, CDATA, arrays, and nested elements.
DevelopmentYAML ↔ JSON Converter
Convert between YAML and JSON formats. Handles multiline strings, anchors, and flow syntax.
DevelopmentDelimiter Converter
Convert between CSV, TSV, pipe-delimited, semicolon, and custom delimiters with proper quoting.
DevelopmentXML Formatter
Format, pretty-print, minify, and validate XML with syntax highlighting and well-formedness checking.
DevelopmentSQL Formatter
Pretty-print SQL queries with proper indentation and keyword uppercasing. Supports common SQL dialects.
DevelopmentRegex Tester & Builder
Test regex patterns with real-time match highlighting. Built-in pattern builder and syntax reference.
DevelopmentJWT Explorer
Decode, inspect, and build JWTs. View claims, check expiration, and create HMAC-signed tokens.
DevelopmentCron Expression Builder
Build and decode cron expressions visually. 12 presets, 5-field editor, and human-readable descriptions.
DevelopmentBase64 Encode/Decode
Encode text to Base64 or decode Base64 to text. Supports UTF-8.
DevelopmentHash Generator
Generate SHA-256, SHA-384, SHA-512, and SHA-1 hashes from text using Web Crypto.
DevelopmentTimestamp Converter
Convert Unix epoch timestamps to human-readable dates and back. Timezone support.
DevelopmentUUID Generator
Generate v4 UUIDs. Single or bulk generation up to 100. Copy individual or all.
DevelopmentURL Encode/Decode
Percent-encode or decode URLs and query parameters. Component and full-URL modes.
DevelopmentColor Converter
Convert between Hex, RGB, and HSL color formats. Live preview swatch and ready-to-use CSS output.
DevelopmentMarkdown Preview
Live side-by-side markdown editor and rendered preview. Supports headers, lists, code, links, and more.
DevelopmentCard Number Validator
Validate card numbers with the Luhn algorithm and detect card network from prefix ranges.
Data & FinanceConnection String Builder
Build JDBC, ADO.NET, and ODBC connection strings with a browsable property reference for 8 database platforms and 18 drivers.
DevelopmentAll tools run entirely in your browser. Your data never leaves your machine. Need help? Ask James.
Other Tool Categories
Data & Finance
Banking, accounting, healthcare, payments, and EDI file formats.
Retail & POS
Barcodes, point-of-sale files, retail math, and fiscal calendars.
Shipping & Logistics
Freight estimation, container loading, route optimization, and trade compliance.
Inventory & Warehouse
Reorder planning, cycle counting, warehouse slotting, and cost allocation.
Networking
Subnet math, MAC vendor lookup, email authentication, and WHOIS.
IBM i & Mainframe
EBCDIC, packed decimal, COBOL copybook, DDS, BMS, and fixed-width.