• NUMERIC
  • VALIDATED
  • REJECTED
  • HUMAN

How to clean Brazilian ID numbers with your AI

Connect your AI to a batch processor that handles the formatting work for you. It turns messy text into clean, numeric-only data.

Ask AI about this page

Short answer

How do I strip non-numeric characters from CPFs and CNPJs?

Your AI uses the clean_batch tool to scan your list and remove every character that isn't a number. You'll get a clean set of numeric strings ready for import. Here is what you'll get.

The results of a clean run.

Where your data lands.

Once the AI finishes the batch, you'll have these specific outputs.

NUMERIC

Pure digit strings

The tool strips all dots, dashes, and spaces. You get a list of numbers that match your database schema.

VALIDATED

Format consistency

Every entry follows the same length and character rules. This prevents import errors in your CRM or SQL tables.

REJECTED

Invalid entries flagged

If a string contains no usable numbers, the AI identifies it. You'll know exactly which rows failed the cleaning process.

HUMAN

Manual review needed

The AI won't guess if a number is wrong. You'll need to check any flagged entries that don't meet the required length.

The workflow

What your AI does when the list arrives.

The AI handles the heavy lifting of pattern matching so you don't have to write regex.

  1. Scan the source

    The AI reads your raw data from a sheet, a text file, or a chat message.

    clean_batch

  2. Strip characters

    It identifies and removes all non-digit symbols like periods or hyphens.

    clean_batch

  3. Verify length

    The tool checks if the resulting numbers match standard CPF or CNPJ lengths.

    clean_batch

  4. Output clean data

    The AI presents the final numeric list or saves it back to your source.

    clean_batch

Try it

Copy these to start.

Use these prompts to trigger the cleaning process.

Starting points

Replace the bracketed text with your actual file names or data sources.

CPF/CNPJ Batch Processor Connector

You're all set. Choose your MCP client and follow the setup instructions.

Connector linkhttps://edge.vinkius.com/vk_preview_lFNyu8UlZFkhP0wRgSvyc2AGW6mslkNnLO6XUQ8S/mcp

Claude Desktop

Follow the steps below to connect in seconds.

  1. 1In Claude Desktop, open Settings → Connectors.
  2. 2Click “Add custom connector” and paste the connector link above as the remote MCP server URL.
  3. 3Click Add and start a new chat — CPF/CNPJ Batch Processor capabilities are ready to use.
Configuration · claude_desktop_config.jsonCopy
{
  "mcpServers": {
    "cpfcnpj-batch-processor-mcp": {
      "url": "https://edge.vinkius.com/vk_preview_lFNyu8UlZFkhP0wRgSvyc2AGW6mslkNnLO6XUQ8S/mcp"
    }
  }
}
Copy into chat04

  • Clean the CPFs in my Google Sheet named 'Customer_List_2024'.

  • Strip all formatting from the CNPJs in this text block: [paste data].

  • Run a batch clean on the CSV file I just uploaded.

  • Check this list of IDs and give me only the numeric versions.

  • Claude
  • ChatGPT
  • Cursor
  • VS Code
  • Windsurf
  • Claude Code
  • JetBrains
  • Cline

Start here

Connect CPF/CNPJ Batch Processor once, then ask.

Just link the MCP to your client. Your credentials stay encrypted and the setup is handled on our end.

Connect CPF/CNPJ Batch Processor to your AI

FAQ

How this task behaves.

  • 01

    Will the AI change the actual numbers?

    No. The tool only removes non-numeric characters like dots and dashes. It does not alter the digits themselves.

  • 02

    Can it validate if a CPF is real?

    No. The tool cleans the formatting to make the numbers usable. It does not check the mathematical validity of the ID against government databases.

  • 03

    Does it work on large files?

    Yes, the clean_batch tool is designed to process lists in bulk rather than one by one.

  • 04

    What happens to empty rows?

    If a row contains no digits, the AI will flag it as an invalid entry rather than creating a blank space.

  • 05

    Can the AI delete my original file?

    No. The AI only reads the data and provides a cleaned version. It cannot delete or overwrite your source files.

  • More questions about CPF/CNPJ Batch Processor? The Connector page answers them. See everything the CPF/CNPJ Batch Processor Connector can do

Connect CPF/CNPJ Batch Processor to Claude, Cursor, ChatGPT & more