Select all characters before "@"

Hi everyone,

Does anyone know a way to filter or select only those characters that are before an “@” symbol?

Im trying to extract the characters before the “@” of an email:

i.e. john@gmail.com The result I want is: “John”

Thanks!

Solved Solved
0 6 247
1 ACCEPTED SOLUTION

Steve
Platinum 4
Platinum 4

Try:

ANY(SPLIT("john@gmail.com", "@"))

View solution in original post

6 REPLIES 6
Top Labels in this Space