> ## Documentation Index
> Fetch the complete documentation index at: https://filla.io/docs/llms.txt
> Use this file to discover all available pages before exploring further.

# Text Processor

> Bulk text transformations across Airtable text fields: find and replace, case conversion, trim, and prepend/append.

## What this tool does

The Text Processor performs bulk text operations across one or more text fields in your Airtable table. Use it to clean data, standardize formatting, fix capitalization, or add consistent prefixes and suffixes across thousands of records at once.

## Settings reference

### Source

| Setting               | Description                                                                                                  |
| --------------------- | ------------------------------------------------------------------------------------------------------------ |
| **Source table**      | The table containing text fields to process.                                                                 |
| **Operation**         | The type of text transformation: Find and Replace, Case Conversion, Trim and Normalize, or Prepend / Append. |
| **Field scope**       | All text fields (process every text-type field in the table) or Selected fields (choose specific fields).    |
| **Fields to process** | Which specific fields to process. Only shown when Field scope is Selected fields.                            |

## Operations

### Find and replace

Search for a string and replace it with another across all selected fields.

| Setting                    | Description                                          |
| -------------------------- | ---------------------------------------------------- |
| **Find**                   | Text to search for.                                  |
| **Replace with**           | Replacement text. Leave empty to delete all matches. |
| **Match case**             | When on, the search is case-sensitive.               |
| **Use regular expression** | Treat the Find value as a regex pattern.             |
| **Match whole words only** | Only match complete words, not substrings.           |

**Example:** Find `Acme Corp`, replace with `Acme Corporation` to standardize company names across a table.

### Case conversion

Change the capitalization of text in selected fields.

| Setting        | Description                                           |
| -------------- | ----------------------------------------------------- |
| **Convert to** | UPPER CASE, lower case, Title Case, or Sentence case. |

**Example:** Convert a "Status" field to Title Case so all entries like `approved`, `PENDING`, `in review` become `Approved`, `Pending`, `In Review`.

### Trim and normalize

Clean up whitespace issues in text fields.

| Setting                                  | Description                                                      |
| ---------------------------------------- | ---------------------------------------------------------------- |
| **Trim leading and trailing whitespace** | Remove spaces and tabs at the start and end of each value.       |
| **Collapse multiple spaces to single**   | Replace consecutive spaces with a single space.                  |
| **Remove spaces before punctuation**     | Fix extra spaces before commas, periods, semicolons, and colons. |

### Prepend / Append

Add text before or after existing values.

| Setting               | Description                              |
| --------------------- | ---------------------------------------- |
| **Prefix text**       | Text to add before each value.           |
| **Suffix text**       | Text to add after each value.            |
| **Skip empty fields** | Don't add prefix/suffix to blank fields. |

**Example:** Add `https://` as a prefix to a URL field where URLs were stored without the protocol.

## Field scope

The **All text fields** option automatically discovers all text-type fields (Single Line Text, Multiline Text, Rich Text, URL, Email, Phone Number) in the table and processes all of them.

Use **Selected fields** when you want to limit the operation to specific columns.

## Preview

The Text Processor has a preview panel that shows how the transformation would affect a sample of your records. Review the preview before running.

## Common questions

<AccordionGroup>
  <Accordion title="Does the tool skip records that don't change?">
    Yes. The tool only writes back to Airtable for records where the transformation actually changed the value. Unchanged records are not updated.
  </Accordion>

  <Accordion title="Can I use regex in Find and Replace?">
    Yes. Toggle **Use regular expression** on and enter a valid regex pattern in the Find field.
  </Accordion>

  <Accordion title="Can I run multiple operations in one pass?">
    No. Each run executes one operation type. Run the tool multiple times for multiple transformations.
  </Accordion>
</AccordionGroup>