Complete Normalization Rules Reference

Pass through the value unchanged. No transformation applied.

Use when data is already clean or should not be modified.

Remove leading/trailing whitespace, collapse multiple spaces, and decode HTML entities.

Also decodes HTML entities: & → &, < → <, > → >, " → quote, ' → apostrophe.

Remove emojis, special Unicode characters, and normalize for API/JSON safety.

Removes emojis, control characters, and non-ASCII symbols.

Validate email format and convert to lowercase. Invalid emails are marked as errors.

Validates format: must have @ and valid domain with TLD.

Convert phone numbers to international E.164 format (+15551234567). Auto-detects country from location field if available.

Uses location field in your data (city, state, country) to determine country code. Defaults to US if not detected.

Ensure URLs have https:// protocol. Validates URL structure.

Removes trailing slashes, lowercases domain. Invalid URLs (missing TLD, malformed) marked as errors.

Extract numeric value from prices. Handles currency symbols, commas, and words.

Returns just the decimal number without currency symbol.

Format price with ISO currency code (e.g., 19.99 USD).

Detects currency from symbols ($, €, £, ¥) or words (dollars, euros, pounds, yen).

Convert various date formats to ISO 8601 (YYYY-MM-DD).

Handles US (MM/DD/YYYY), European (DD-MM-YYYY), and text formats.

Convert truthy/falsy values to standardized TRUE/FALSE. Supports inventory status terms.

Also accepts: Y/N, on/off, active/inactive, enabled/disabled, available/unavailable, in stock/out of stock, sold out.

Convert number words to digits.

Handles compound numbers like 'twenty-five' = 25.

Format location as 'City, ST' with proper capitalization and state abbreviation.

Expands state abbreviations, handles common city aliases.

Convert to Title Case (capitalize first letter of each word).

Smart handling of articles (a, an, the) and prepositions.

Convert to sentence case (capitalize first letter only).

Convert entire text to uppercase.

Convert entire text to lowercase.

Convert to URL-friendly slug format (lowercase, hyphens).

Removes special characters, replaces spaces with hyphens.

Truncate text to 60 characters for SEO meta titles.

Truncates at word boundary, adds ellipsis if truncated.

Truncate text to 160 characters for meta descriptions.

Truncates at word boundary, adds ellipsis if truncated.

Remove all HTML tags, keeping only text content.

Also decodes HTML entities.

Remove special characters, keeping only letters, numbers, and spaces.

Clean text for safe JSON/API output. Removes emojis, special Unicode, control characters.

Use for API responses and JSON exports to prevent encoding issues.

Truncate to 30 characters for Google Ads headlines. Cuts at word boundary.

Returns error if first word exceeds 30 chars (no mid-word cuts).

Truncate to 90 characters for Google Ads descriptions. Cuts at word boundary.

Returns error if first word exceeds 90 chars.

Clean keywords for PPC campaigns. Lowercase, remove special chars.

Ideal for keyword lists and negative keywords.

Convert product codes and SKUs to uppercase with trimmed whitespace.

Validate GTIN/UPC/EAN barcodes by checking the GS1 modulo-10 check digit. Supports GTIN-8, GTIN-12 (UPC-A), GTIN-13 (EAN-13), and GTIN-14.

Strips dashes and spaces before validation. Returns cleaned digits if valid, error if check digit fails.

Validate and format ISBN-10 and ISBN-13 book identifiers with standard hyphens.

Validates check digit (modulo-11 for ISBN-10, modulo-10 for ISBN-13). ISBN-13 must start with 978 or 979.

Normalize currency values to ISO 4217 three-letter codes.

Supports symbols ($, €, £, ¥, ₹, ₩, ₽), words (dollar, euro, pound), and code variants (usd, eur, gbp).

Convert currency words and codes to their symbol representation.

Opposite of Currency Code — outputs the symbol character instead of the ISO code.

Extract a clean numeric rating from various formats including fractions, text, and star characters.

Handles X/Y fractions, 'X out of Y' text, word numbers with decimals ('four point five'), star characters (★☆½), and plain numbers.