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. |
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. |
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. |
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
Does the tool skip records that don't change?
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.
Can I use regex in Find and Replace?
Can I use regex in Find and Replace?
Yes. Toggle Use regular expression on and enter a valid regex pattern in the Find field.
Can I run multiple operations in one pass?
Can I run multiple operations in one pass?
No. Each run executes one operation type. Run the tool multiple times for multiple transformations.