tr Skip to content
Black Friday FlowMattic for life, 12 payments of $33.25 Or $399 once. Nothing added for splitting Ends in --Days --Hrs --Min --Sec See the deal

Text Formatter: Clean, Split and Extract Text in Any Workflow

FlowMattic Text Formatter: a messy name with stray spaces and capitals is trimmed and title-cased into a clean name before it reaches the CRM.

Data rarely arrives the way the next app wants it. Names come in shouting capitals, emails hide inside paragraphs, and a webhook sends one field where you need three. The FlowMattic Text Formatter fixes this inside the workflow: fourteen actions that change case, extract, split, replace, trim, encode and convert text between the trigger and the action.

It is for anyone who maps form entries, order notes, emails or AI output into other apps and wants them clean on arrival. This guide walks through each text formatter action, the fields it uses and the fields it returns, then shows seven workflows that put it to work.

What is the Text Formatter?

Text Formatter by FlowMattic is a built-in action app in the workflow builder. You add it as a step, pick an action, map text from the trigger or an earlier step, and the result becomes a field the following steps can use. It runs on your own server and adds no per-task cost.

How to use the text formatter in a workflow

  1. Add a step and choose Text Formatter by FlowMattic.
  2. Pick the action, for example Basic Formatting.
  3. Map the text into Content (or Field, HTML Content or Markdown Content, depending on the action) and fill in the action’s options.
  4. Test the step. The output fields, usually result or value, are now available to every later step.
FlowMattic Text Formatter by FlowMattic step with the Basic Formatting action, the Content field and the Formatting Method dropdown set to Title Case.
Basic Formatting set to Title Case, turning a mapped name into properly capitalised text.

The fourteen actions

ActionFieldsOutput
Extract PatternContent, Pattern (a regular expression without the enclosing slashes), Combine Results?result_0, result_1…, and combined_result
Find in TextContent, Search Stringresult: the position of the first match, counting from 0
Replace TextContent, Search For, Replace Withresult with every match replaced
Basic FormattingContent, Formatting Methodresult, or numbered fields for the extract methods
Split TextContent, Separator, Segment Indexresult, or item_0… and all_items for All
Text BetweenContent, Start Text, End Textresult: the text between the first pair
Default ValueField, Default Valuevalue: the field, or the default when it is empty
TruncateContent, Max Length, Skip Characters, Append Ellipsis?, Custom Ellipsis Textvalue
URL EncodeContent, Convert space to plus?result
URL DecodeContent, Convert plus to spaces?result
Join LinesContent, Separator, Trim Lines?, Remove Empty Lines?result and line_count
HTML to MarkdownHTML Content, Save to Media Library?, File Nameresult, plus file_url and attachment_id when saved
Markdown to HTMLMarkdown Contentresult
Generate SlugContent, Separatorresult, a URL-friendly slug

Basic Formatting methods

The Formatting Method list has thirteen options:

  • Capitalize raises the first letter of each word and leaves the rest alone. Title Case also lowers the rest, so “priya SHARMA” becomes “Priya Sharma”.
  • Upper Case, Lower Case and Sentence Case (first letter up, the rest down).
  • Remove HTML Tags and Trim White Space, which also collapses runs of spaces and line breaks into single spaces.
  • Extract Numbers, Extract Email Address, Extract Phone Numbers and Extract URLs, which return every match as number_0, email_0, phone_0 or url_0 and onward.
  • Get Length of String and Get Word Count.

Separators and placeholders

Split Text takes [space] for a space. Join Lines defaults to \n and accepts [space], [tab] and [comma]. Generate Slug uses a hyphen unless you set another separator, such as an underscore. Split Text’s Segment Index can be First, Second, Last, Second to Last or All; All returns every piece plus an all_items list ready for an Iterator.

Use cases

Tidy customer names before they reach the CRM

Form entries arrive as ” amelia OKAFOR “. Trim White Space removes the stray spaces and Title Case fixes the capitals, so the CRM shows “Amelia Okafor”.

Flow: Form Builder New Form Submission → Basic Formatting (Trim White Space) → Basic Formatting (Title Case) → HubSpot Create Contact

Split a full name into first and last

A checkout sends one name field but the email platform wants two. Split Text on [space] with First gives the first name, and a second Split Text with Last gives the surname.

Flow: WooCommerce New Order Created → Split Text (First) → Split Text (Last) → Google Sheets Add New Row

Pull an order number out of a support email

Customers write “Order #4821 never arrived”. Extract Pattern with #(\d+) picks out the number, and the workflow looks the order up before alerting support.

Flow: Email Parser Email Received → Extract Pattern → WooCommerce Get Order by ID → Slack Send Channel Message

Slugs and short excerpts for new posts

A marketing team turns campaign names into slugs, “Autumn Sale 2026” into “autumn-sale-2026”, and cuts a 160-character excerpt with an ellipsis for social posts.

Flow: Google Sheets New Spreadsheet Row → Generate Slug → Truncate → WordPress New Post

Fill gaps so required fields never fail

Some leads skip the company field, and the CRM rejects an empty value. Default Value swaps in “Not provided” only when the field is empty.

Flow: Form Builder New Form Submission → Default Value → HubSpot Create Contact

Publish AI drafts as HTML, archive them as Markdown

An AI agent writes in Markdown. Markdown to HTML makes it ready for WordPress, and an agency keeps a Markdown copy of every published post in the Media Library with HTML to Markdown.

Flow: AI Agent Execute Agent → Markdown to HTML → WordPress New Post

Turn a pasted list into one line

An internal request form has a box where staff paste one SKU per line. Join Lines with [comma] and Remove Empty Lines? set to Yes produces a clean comma-separated list for the inventory API.

Flow: Form Builder New Form Submission → Join Lines → API by FlowMattic POST

Tips and gotchas

  • Pick Title Case for names. Capitalize only raises first letters, so “ADAEZE” stays “ADAEZE”. Title Case lowers the rest too.
  • No match is an error. Extract Pattern and Text Between fail the step when nothing matches. If that is normal for some inputs, tick Ignore Errors on the step’s Conditions tab.
  • Default Value treats “0” as empty. A field holding 0 is replaced by the default.
  • Truncate counts bytes. Accented letters and emoji take more than one byte, so text with them comes out shorter and can be cut mid-character. Get Length of String counts the same way.
  • Upper and lower case are for plain letters. Accented letters may be left unchanged; Title Case handles them.
  • Replace and Find are case-sensitive. “Order” will not match “order”.
  • Truncate tidies first. It collapses spaces and line breaks before cutting, so the length you set applies to the cleaned text.

Related features

FAQ

How do I change text to title case in an automation?

Add a step with the Basic Formatting action, map the text into Content and set Formatting Method to Title Case. The formatted text is returned in the result field.

Can I use regular expressions?

Yes. Extract Pattern takes a regular expression in the Pattern field, written without the enclosing slashes. Every match is returned as its own field, and Combine Results? joins them into one.

How do I extract an email address from text?

Use Basic Formatting with the Extract Email Address method. Each address found is returned as email_0, email_1 and so on.

It is one of FlowMattic’s built-in data tools. See FlowMattic pricing and let your workflows clean text before it lands.

More from the blog