OttoKit Text Formatter

Working with messy text data? The Text Formatter has you covered. This tool eliminates the pain of common text tasks that would otherwise consume hours of your time.

Need to pull email addresses from a customer list? Extract phone numbers from mixed data? Convert HTML to Markdown for your documentation? You can clean up some text by removing extra spaces and fixing the capitalization. The Text Formatter handles all of this and more with just a few clicks.

Getting Started

1. Add the Formatter app as an action
2. Under the Select Event field, choose Text
3. Select your desired action from the available options

Related Formatters

For additional data manipulation capabilities, explore these related formatters:

• Number Formatter – For numerical data manipulation
• Date/Time Formatters – For date and time data processing

Available Text Actions

Default value

This sets a fallback value when the input text is empty or null, ensuring your workflow continues smoothly even with missing data.

Enter Key: Map the key you would like to check for empty responses.

Enter Default Value: Enter default value that will be passed, if there is no response in the mapped key.

Result:

Find

It searches for specific text patterns within your input string and returns matching results.

Enter Text: Enter the text string where you would like to search a specific text.

Enter Find Text: Enter the value you want to search for. If value is found, the result will indicate the position of the string from the start, if it not located it will return -1.

Skip Characters: Enter the number of characters to pass before searching. Found value encountered before this point will be overlooked.

Result:
It returns the position of the word “OttoKit” as 0

Replace:

This action will replaces specified text or patterns with new content. Perfect for bulk text substitutions and data standardization.

Enter Text: Enter text string where you would like to search and replace a specific text.

Enter Find Text: Enter the text you want to search for

Enter Replace: Enter the text you would like to replace with the found text. Leave blank to delete the found text

Result:

Pluralize: 

It automatically converts singular words to their plural forms

Enter Text: Enter the text you want to pluralize.

Remove HTML tags: 

This action will strip all HTML markup from text, leaving only the plain content.

Enter HTML: HTML you would like to convert to plain text.

Result:

Split text: 

This will divide text into multiple parts based on a specified delimiter. 

Enter Text: Enter string you would like to split to multiple strings.

Enter Separator Value: Enter character or word that will be used as a separator for the string. [:tab:], [:newline:], [:return:] can also be used as separators. Default separator is [space]

Segment Index: Select the segment of text to return after splitting. You can choose: first, second, last, second to last and all. The default is first.

Split text on length: 

Breaks text into chunks of a specified character length, useful for formatting constraints like when posting to a social media platform that has a character limit.

Trim Whitespace: 

This removes all leading and trailing spaces from text.

Enter Text: Enter text from where you would like to remove leading and trailing whitespace from.

Truncate: 

This will shorten text to a specified length, with optional truncation indicators.

Enter Text: Enter text that you would like to truncate.

Max Characters: Enter the maximum number of characters you want for the truncated result.

Skip Characters: Enter the number of characters to skip from the left of the input text.

Add Three Dots at the End? If yes is selected, the truncated text will be shortened by three characters and “…” will be added at the end. You can also map values here. e.g. yes, no

Result:

The text is truncated, and a part of it is returned

Word Count: 

This will count the number of words in the provided text.

Enter Text: Enter the text you want to know the word count of.

Count characters:

Unlike the “Word Count” action, this returns the total character count, including or excluding spaces as specified.

Enter Text: Enter the text you wish to count the characters of.

Extract Email address:

This action will identify and extract email addresses from text using pattern recognition.

Enter Text: Enter the source text you would like to find email addresses from.

Result:

Extract Number: 

This finds and extracts numerical values from mixed text content.

Enter Text: Enter the text you would like to find and copy a number from.

Result:

Extract Pattern: 

Uses custom regular expressions to extract specific text patterns.

Enter Text: Text you would like to find a pattern from

Enter Pattern: Enter a Python Regular Expression to find a match for, e.g. f[o]+ (bar).

Match All?: You can choose yes or no here to match all occurrences of pattern and return results as line items. You can also map value here. e.g. yes, no

Ignore Cases: You can choose yes or no here to Ignore case when matching. You can also map value here. e.g. yes, no

Result:

Extract Phone number: 

It identifies and extracts phone numbers in various formats from text.

Enter Text: Enter source text you would like to find phone numbers from.

Select Phone Number Format: There are three formats to select from here, the North American Number Plan, the International and the Universal. The Universal search is the default option to find many NANP and International numbers. If this does not work consistently, try a specific format (NAMP or International), which will find most phone numbers, but can also result in false positives.

Result:

Extract URL:

This action will locate and extract all web URLs from text content.

Enter Text: Enter source text you would like to find web URLs from.

Result:

Capitalize: 

It converts the first letter of each word to uppercase while keeping the rest lowercase.

Enter Text: Enter the text you would like to capitalize.

Result:

Lowercase: 

This will convert all text to lowercase letters.

Enter Text: Enter the text you want to convert to lowercase.

Title Case: 

Formats text with proper title capitalization (first letter of major words capitalized).

Enter Text: Enter the text you want to convert to titlecase.

Convert HTML to Markdown: 

Transforms HTML markup into Markdown syntax for documentation and content management.

Enter HTML: Enter HTML you would like to convert to Markdown.

Result:

Convert Markdown to HTML: 

This does the opposite of converting “HTML markup into Markdown” text. It converts Markdown to HTML

Enter Mardown : Enter Mardown you would like to convert to HTML.

Convert to ASCII: 

Transforms text to ASCII encoding, removing special characters and accents.

Enter Text: Enter text you would like to convert to ASCII. All non-ASCII characters will be removed.

URL Encode:

It encodes text for safe use in URLs by converting special characters.

Enter URL: Enter the URL that you would like to encode.

Result:

URL Decode: 

This will decode URL-encoded characters back to their original form.

Enter URL: Enter the URL that you would like to decode.

URL parameter encode: 

Specifically encodes text for use as URL parameters.

Enter URL: Enter the URL that you would like to encode parameters.

Text In between: 

Extracts text that appears between two specified delimiters or markers.

Enter Text: Text you would like to parse.

Text Match: After – Enter the text after which you want to extract the string

Text Match: Before – Enter the text before which you want to extract the string

Result:

Normalize accented Letters: 

This action will convert accented characters to their non-accented equivalents.

Enter Text: Enter the accented text you would like to normalize.

The example in the screenshot shows a sentence: “The café in Montréal serves délicious crêpes, while the naïve tourist enjoyed a piña colada at the résumé writing workshop” containing accented characters

Result: 

Spreadsheet type formula: 

This action will process text using spreadsheet-style formulas and functions.

Enter input: Please check supported formulas here.

In the example below, the CONCATENATE(“A1”, ” – “, “B1”) formula was used to join two texts.

Result:

PHP Serialize: 

This converts data into a PHP serialized format for cross-platform compatibility.

Click on the Add New Key-Value pair

Enter Key* and Enter Value*

Result:

Convert to MD5: 

This action generates an MD5 hash of the input text for checksums and verification.

Enter Text: Enter the text you want to convert to md5.

The example below converts “support@ottokit.com” to it MD5 harsh value

Result:

Convert to SHA-256: 

This function creates a SHA-256 hash for enhanced security and data integrity verification.

Enter Text: Enter the text you want to convert to SHA-256.

The example below converts “support@ottokit.com” to it SHA-256  value

Result:

Base64 Encode: 

Encodes text into Base64 format for safe data transmission and storage.

Enter Text: Enter the text you want to convert to Base64 encoding.

The example below converts “support@ottokit.com” to Base64  

Result:

Base64 Decode: 

Decodes Base64 encoded text back to its original format.

Enter Text: Enter the text you want to convert to Base64 encoding.