AutomationAI

Text to Number

Transform text into numbers.

The Text to Number feature transforms a text input into a numerical output. It can convert emojis, basic math logic, phrases, and a variety of languages. It can also take instructions about your data and apply them to existing text, returning a number result.

Math in Text Columns

Large language models (LLMs) are generally not good at doing math when the input is pure text. Consider specifying in the instructions to ‘Do the given math equation.‘

Adding the Text to Number Feature

1

Open the table where you want to use the Text to Number column.

2

Add a new basic text column for the Input. The input can be any column that contains text, so if you’ve used another action or computed column to create a text result, you can also use that text result as the Input source.

  • New columns added with the plus button will always appear on the right. If you’d like to add a column somewhere else in your data, you can select the dropdown menu on an existing column and choose Add column right. You can also click and drag columns to rearrange them.
3

Add a Text to Number column to store the result. Search for ‘Text to Number’ or navigate to AI → Text to Number.

4

For Instructions, enter custom text to create more specificity for your prompt.

5

For Input, use the Input column created previously.

6

Adjust the display configurations for precision, group separator, and units if needed.

7

Note: If the action will be triggered in the Workflow Editor, then add a basic number Result column where the result will be stored.

8

Click on Done.

Frequently Asked Questions

The Text to Number feature requires a paid plan. Browse our plans to find the right fit for you.

The Text to Number feature will use one update every time it is triggered.