Workflow Action - Text Formatter

The Text Formatter action allows you to manage and transform text.

What is Text

Formatter? The Text Formatter action in workflows allows users to manipulate and modify text data through a variety of action types. This includes changing text to uppercase, lowercase, replacing text, finding specific words, and more. It is crucial for ensuring text data is presented or manipulated correctly before further processing.

How To Use Text Formatter

1. Create/Edit WorkflowNavigate to Automation > Workflows and click Create Workflow or edit an existing workflow.
2. Add ActionUse the plus (+) button to add an action and scroll or search until you see Text Formatter.
3. Configure Text Formatter SettingsGive the action a more specific name, select the action type you want to use (refer to the rest of this article), and the relevant field. Different action types have different configuration fields.Text Formatter DetailsTable - Action Type DetailsAction TypeDescriptionExampleFieldsUpper CaseConverts all text to upper case"text" -> "TEXT"Select FieldLower CaseConverts all text to lower case"TEXT" -> "text"Select FieldTitle CaseCapitalize the first letter of each word"text formatter" -> "Text Formatter"Select FieldCapitalizeCapitalizes the first letter of the first word"text formatter" -> "Text formatter"Select FieldDefault ValueIf the input text is empty, this formatter will set the default value you specify"" -> "Default Value"Select FieldDefault ValueTrimShortens/truncates the text by a specified number of characters"applesauce" -> "apple"Select FieldMax LengthRemove Characters From BeginningEllipses (Shorten the text by three characters and insert "..." to the end, if necessary)Trim WhitespaceRemoves leading (beginning) and trailing (ending) whitespace" hello " -> "hello"Select FieldReplace TextReplace all instances of an exact character, word or phrase with another character, word or phrase"this ain't it" -> "this is not it"Select FieldFindReplaceFindFind the first position of a value in the text, -1 if the value is not found"lorem ipsum dolor sit" -> "ipsum" = 7 OR "cat" = -1Select FieldFindWord CountCounts the number of words in a text string"lorem ipsum" -> 2 wordsSelect FieldLengthCounts the number of characters in a text string"cat" -> 3 charactersSelect FieldSplit TextSplits a text string based on a delimiter you provide and returns one of the segments (first, second, second to last, or last)"lorem ipsum dolor sit" -> split on " " = second segment is "ipsum"Select FieldSeparatorSegmentRemove HTML TagsRemoves HTML tags from text (converts HTML to plain text)"<p>Hello world!</p> -> "Hello world!"Select FieldExtract EmailGrabs the first email address found in the text"my email is [email protected]" -> "[email protected]"Select FieldExtract URLGrabs the first URL found in the text" my homepage is lioncleaning.com" -> "lioncleaning.com"Select FieldTable - Select Field DetailsField Level 1Field Level 2Field Level 3Contact(customers in the CRM)Full Name-First Name-Last Name-Email-Phone-Phone (raw format)-Company Name-Full Address-Address 1-City-State-Country-Postal Code-Timezone-Source-Website-ID-User(employees in the Account)Full Name-First Name-Last Name-Email-Phone-Phone (raw format)-Signature-Calendar Link-Twilio Phone-ID-MessageMessage Body-Message Subject-Message Attachments-Account(the Account business)Name-Full Address-Address Line 1-City-State-Country-Postal Code-Email-Phone-Phone (raw format)-Website-Logo URL-OwnerFirst NameLast NameEmailIDFacebook Lead IDPhone CallPhone Call Direction-Phone Call Duration-Phone Call From-Phone Call To-Phone Call From City-Phone Call From State-Phone Call From Country-Phone Call From Zip-Phone Call To City-Phone Call To State-Phone Call To Zip-Phone Call To Country-Phone Call Answered By Phone-Phone Call Answered By User Name-Phone Call Answered By User Id-Phone Call Answered By Device-Phone Call User Id-Phone Call User Name-Phone Call Start Time-Phone Call End Time-Phone Call Status-Client Portal ContactLogin URL (Magic Link)-AttributionFirstSession SourceURLCampaignUTM SourceUTM MediumUTM ContentReferrerCampaign IdFB ClickldGoogle ClickldGoogle Client IdUTM CampaignUTM KeywordUTM Match TypeAd Group IDAd IDLatestSession SourceURLCampaignUTM SourceUTM MediumUTM ContentReferrerCampaign IdFB ClickldGoogle ClickldGoogle Client IdUTM CampaignUTM KeywordUTM Match TypeAd Group IDAd IDCustom FieldsUnique to each Account-Custom ValuesUnique to each Account-Suggested TriggersForm Submission: trigger the Text Formatter action after a form is submitted to ensure the data is properly formatted (ex: fill in a default value "no answer" if a field is blank).New Contact Created: Automatically format text fields when a new contact is added to your CRM (ex: names are capitalized correctly)Webhook Received: Automatically format the text received from an external system (talk to your developer about this one).

Frequently Asked Questions

Q: Can I use the Text Formatter to personalize messages?

A: Yes! You can combine the Text Formatter with custom values and merge fields to create personalized messages with properly formatted text.

Q: Is it possible to chain multiple formatting actions together?

A: Yes! You can add multiple Text Formatter actions within a workflow to perform complex text transformations step by step.

Q: Does the Text Formatter work on numbers?

A: Sort of. If the numbers are in text form, then they can be manipulated like text. If the numbers are in numeric form, then use the Number Formatter action.

Q: I can't find the field my text is in

A: Double check the table to make sure that field is included and drill down deep enough to select it.