How to extract names from email address in table calc

Knowledge Drop

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.                

Comments
Former Community Member
Not applicable

PM kisan customer care number 7908676812

Former Community Member
Not applicable

PM kisan customer care number 7908676812

Former Community Member
Not applicable

PM kisan customer care number 7908676812PM kisan customer care number 7908676812

Former Community Member
Not applicable

PM kisan customer care number 7908676812

Former Community Member
Not applicable

PM kisan customer care number 7908676812 

Former Community Member
Not applicable

PM kisan customer care number 7908676812

Former Community Member
Not applicable

PM kisan customer care number 7908676812

Former Community Member
Not applicable

PM kisan customer care number 7908676812

Former Community Member
Not applicable

PM kisan customer care number 7908676812

Version history
Last update:
‎06-14-2021 06:16 PM
Updated by: