Built.io Blog

10 Ways Business People Can Automate And Update Data With Text Operations

,

Business users rejoice! Built.io Flow Express just introduced a way to automate data formatting and updating text.

There are two main ways you can use the new text operations action:

  1. To format data to the required format for a service (i.e. all lowercase, remove spaces, etc.)
  2. To search through a string of text to find a specific word or to replace a word.

In this blog post, we’ll show you how to use this new action to get your text formatted correctly using splitting, trimming, matching, replacing, capitalizing and more.

Here’s How It Works

1. Splitting texts

Splitting lets you separate a string of text based on a character like a comma or space. In the example below, the string is split using a comma.

Here’s how it works:

split-text-in-workflow.gif

2. Trimming extra spaces in texts 

If your string of text has extra spaces in it, you can use the trim operation to remove extra spaces.

Here’s how it works:

edit-text-spaces-in-workflow.gif

3. Searching and matching texts

This operation searches a string for match that you define. Using match, you can easily search through a string to match a word or phrase.

Here’s how it works:

search-text-in-workflow.gif

4. Replacing texts

‘Replace’ means exactly what it sounds like: find and replace words like you may have seen in text editors like Word or Google Docs. This is useful if you have to redact a document or change one word to another but you want to automate the process. Some use cases might include changing team names, dates, etc. Much more efficient.

Here’s how it works:

replace-text-in-workflow.gif

5. Capitalizing texts

Sometimes the output from a service isn’t capitalized correctly. You can use the capitalize operation to capitalize the first letter of a sentence.

Here’s how it works:

capitilize-text-in-workflow.gif

6. Lowercasing texts

If you need to input information in all lowercase, you can use the lowercase operation to convert any string of text to all lowercase.

Here’s how it works:

lowercase-text-in-workflow.gif

7. Uppercasing texts

This does the opposite of the lowercase operation. It will convert any string of text into all uppercase.

Here’s how it works:

uppercase-text-in-workflow.gif

8. Converting texts to Base64 format

You may run across a service that needs to have a string encoded in Base64. Use the Convert to Base64 operation to quickly convert your text into the correct format.

Here’s how it works:

convert-to-base64-in-workflow.gif

9. Converting special symbols to HTML entities

Not every character is interchangeable between “normal” text and UTF-8. This means you might have characters like the ampersand (&) look like a random collection of symbols. Use the Escape HTML entities to convert special symbols to their correct HTML entities.

Here’s how it works:

convert-to-html-entities-in-workflow.gif

10. Converting HTML entities to special symbols

This operation converts the HTML entities to their respective characters.

Here’s how it works:

converting-html-entities-in-workflow.gif

Now that you know how the ‘Text Operations’ action works, it’s time to try it out in your Built.io Flow Express workflows. For more information on ‘Text Operations’, click here.

Popular posts

Announcing On-Premises Deployment And DevOps Services For Built.io® Flow

,

Today we’re pleased to announce Built.io Flow On-Prem, a new deployment option and architecture for Built.io Flow. The Most Flexible Integra... Read More

New Year, New Us! Introducing A New UI, Improvements To Workflows And More

,

The New Year is just around the corner so we’re getting a head start to step into 2017 with a bang. New to Built.io Flow is a brand new user... Read More

Introducing Built.io® Flow Express – Automation for Business Users

,

Today is a big day for business users and citizen integrators! We’re introducing the world to the newest member of the Built.io family: Buil... Read More

It’s Flow Time

,

For enterprises, time is more precious than money. Hence, we bring you a host of activities that integrate your favorite time-saving apps wi... Read More

Go with the Flow

,

Happy New Year!! This year, let us make your life a little (or a lot!) easier with Built.io Flow. We just launched a host of new activities ... Read More

Subscribe to our blog