Extracting text from a column

Avatar

By Anjali Daga

updated 3 months ago

In this article, we will learn how you can extract text from a column or field using the following formula functions: 


  1. LEN()

  2. LEFT()

  3. RIGHT()

  4. MID()

LEN () 

LEN returns the length of a string. You can reference a value/column/string within the function following this format: LEN({COLUMN NAME})

Result:

Some of the interesting ways you can use LEN () function

1. Displaying a message based on character count

Here, we can use IF statements to know whether characters are under 35 limit and output a message depending on the character count. Whether you want to count characters in your tweet or managing your SEO title & meta descriptions, you can use the function below: 

Result: 

2. Counting words
You can use a similar formula to count the number of spaces in a text field, which in turn will give you a total count of words.
Formula: 

Result:

LEFT() and RIGHT()


The LEFT() and RIGHT() functions work similarly to one another by extracting a certain number of characters from the beginning (left) or end (right) of a string.


These are helpful functions to use when you need to extract data from a number of rows that share a similar structure.


Syntax: LEFT(String, howMany)


Example:
Result: 


MID()
This function lets you extract a certain number of characters starting at a specific place within a string.


Syntax: MID(String, wheretostart, count)


Example:

Result:


Did this answer your question?