Knowledge Drop

How to extract names from email address in table calc

  • 15 June 2021
  • 0 replies
  • 176 views

Userlevel 2

Last tested: May 7, 2020
 

The Problem

Users will sometimes want to get a substring of their dimension, for example, extracting first.last from first.last@gmail.com

A Solution

We can pretty easily do this with a table calc. We can either use 2 columns or combine them.

  1. Create a "position" column to get the length of the string before the value we want. For emails this will be @.
    Position:

    position(${users.email}, "@")
  2. Then, we create the substring table calc;
    Name:

    substring(${users.email},0,${position}-1)
  3. The above 2 steps will extract the names, if you would like to combine those into a single column it would look like:

    Name:

    substring(${users.email},0, position(${users.email}, "@")-1)

 

This content is subject to limited support.                

 

 

 


0 replies

Be the first to reply!

Reply